brasso_42
asked on
SQLCMD leave 000s after rounding
Hi
I have a sqlcmd script that runs a simple select query and outputs it to a .csv
However one of the fields rounds using
ROUND(dbo.KASSTRNS.KAS_BET RAG / 1.175, 2, 2) AS Expr2
But when I look at that in the out put file its change for example 1.22222 to 1.22000
Is there any way I can drop the 000 at the end??
Cheers
Brasso
I have a sqlcmd script that runs a simple select query and outputs it to a .csv
However one of the fields rounds using
ROUND(dbo.KASSTRNS.KAS_BET
But when I look at that in the out put file its change for example 1.22222 to 1.22000
Is there any way I can drop the 000 at the end??
Cheers
Brasso
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.