manibad (9/5/2013)
Hi,We use Informatica for reporting the data and we are able to do it in Informatica. But I am unable to do it in SQL.
Formatting should be done in the visualization layer, in this case Informatica.
You could always convert the number to a string and place commas where they are needed.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP