I need a gander at this query to figure out what i'm doing wrong.
set pmpg = (select PMPG from Performance_Calculator
where EFFDT_Converted = (select CAST(FLOOR(CAST(getdate() AS FLOAT)) AS DATETIME))
and Performance.DR_CODE = Performance_Calculator.FW_OWN
group by Performance_Calculator.FW_OWN, Performance_Calculator.PMPG);
basically the performance calculator, in the subquery, does return around 320 rows of data. I thought the where clause would match up the rows of data and insert the pmpg into the performance table but instead I get subquery returned more than
This is true but only if the performance_calculator.fw_own = performance.dr_code wasn't there. I'm confused on this... any suggestions?
View Complete Post