SQL remove groupings from CTE in stored procedure--
Have to remove the groupings from a stored procedure, I keep getting a syntax error that I can't figure out. I will post the original and the 2nd one as the one to be converted.
This line has the problem
SELECT s.[Service], s.MEPERSCode, (DATEDIFF(MINUTE,p.AnesSta
unt) * ac.stfCount AS MinutesRaw, 1.0 / sc.svcCount AS CasesRaw
sc.svcCount and ac.stfCount has Invalid column nameSPConverted.txtSPOriginal.txt