Lynn Pettis (12/1/2012)
CELKO (12/1/2012)
to add comma as the thousand separator
NO! Display formatting is done in the presentation layers of any tiered architecture. The proprietary MONEY data type is left-over from the 1970's Sybase dialect. It formats numeric values to look like they had been written with a COBOL PICTURE clause.
01 FOOBAR PICTURE $999,999,999,999V9999
We do not do this in SQL any more.
Joe, you're a dinosaur like me. Most people on this forum probably don't even know what COBOL is.
Isn't that a shade of blue 😀 as far as why to do it, there are some limited times when i want my results window to look preaty on a couple of queries i run when checking our platform. I would prefer to leave it to the UI but when the UI does not have the options (SSMS) in the SQL is the only place to really do it.
For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]
Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
Jeff Moden's Cross tab and Pivots Part 1[/url]
Jeff Moden's Cross tab and Pivots Part 2[/url]