CAST('2.' + CAST(ROW_NUMBER() OVER(ORDER BY P.PaymentID) as varchar) as real) AS ProfitCenterFlag
The Real data type is already in the original query written by DavidChase who, I guess, knows its specifics.
In any case, if necessary, you can read here:
Sign in to comment