Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Format of number RE: Format of number
Sean Pearce
SSCoach
Points: 15999
More actions
August 12, 2014 at 5:06 am
#1737162
WHEN Loc.[rent-group] = 'F' THEN COALESCE(CAST(ARENT.[NET-AMT]*12/52 AS DECIMAL(10, 2)),0) /*To work out weekly rent on monthly run*/
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]