Home Forums SQL Server 2008 T-SQL (SS2K8) T SQL Help - Comma separated numric value RE: T SQL Help - Comma separated numric value

  • October 14, 2012 at 7:04 am

    #1548944

    Jeff Moden (10/12/2012)

    Cadavre (10/12/2012)

    If you insist on doing it in the database layer, it can be achieved like this:

    Check again. OP's desired output doesn't actually have a comma as a thousands separator. It would appear that the OP wants a comma only after the 2nd character of the integer part of each number.

    Lakhs instead of thousands.

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]