DECLARE @SS bigintSET @SS=9999999999999 select convert(varchar(200),cast(@ss as money),3)
DECLARE @SS bigint declare @i int declare @s varchar(100) set @i=1 SET @SS=9999999999999 set @s=reverse(@SS) while @i<len(@s)+1 begin select @s=stuff(@s,@i,0,',') set @i=@i+4 end select left(reverse(@s),len(@s)-1)
select convert(varchar(200),cast(@ss as money),3)
declare @i int
declare @s varchar(100)
set @i=1
SET @SS=9999999999999
set @s=reverse(@SS)
while @i<len(@s)+1
begin
select @s=stuff(@s,@i,0,',')
set @i=@i+4
end
select left(reverse(@s),len(@s)-1)