formatNumber

Det mest fornuftige ville efter min mening være at lade det program der viser dataene lave formateringen, og så lade databasen lave databasearbejde.

Sådan kan det gøres...

create Procedure up_DecimalSeparator @Amount decimal(19), @R varchar(20) output
as
SELECT @R=
        Sig+RIGHT(d3+'.'+d2+'.'+d1+'.'+d0,
                          LEN(ABSN)+(LEN(ABSN)-1)/3)
FROM
(SELECT
    cast(ABS(@Amount) as int ) AS ABSN,
    CASE WHEN @Amount < 0 THEN '-' ELSE '' END AS Sig,
    Right(cast(cast(abs(@Amount) as int)as varchar(20)),3) AS d0,
    Right(cast(cast(abs(@Amount)/1000 as int)as varchar(20)),3) AS d1,
    Right(cast(cast(abs(@Amount)/1000000 as int)as varchar(20)),3) AS d2,
    Right(cast(cast(abs(@Amount)/1000000000 as int)as varchar(20)),3) AS d3
) Z

GO


Du kan checke/bruge den således

declare @@S varchar(20)
exec up_DecimalSeparator 12345678, @@S output
print @@S -- skriver 12.345.678