I have a problem for the SUM and REPLACE function, the SQL script will as below,
,' + @SelectColNames + '
SUM(' + @SelectColNames + ') AS TotalCost
for the @SelectColNames parameter will return the result as
[Q1 '10] ,[Q2 '10] ,[Q3 '10] ,[Q4 '10] ,
My Question as below,
(1) How can i SUM all the Quarters as above with the REPLACE symbol (+)
(2) Since from the statement above, i have symbol (') and (,). So i cant write the correct way on that.