asked on SQL ROUND SYNTAX FOR COMPUTATION OF AN ALIAS
Ok, I do not know why I am having syntax issues with the ROUND statement! I have the following:
,[RENTAL_COST_FW]
,[DAYS_BILLED_FW]
,[MILEAGE_RATE_FW]
,(([COST_LABOUR_FW] + [COST_PARTS_FW] + [CVR_FEE_FW] + [TOTAL_TAX_FW])) as FW_COST_TOTAL
I want to round the alias "FW_TOTAL_COST" to 2 decimal places... I keep getting a syntax error when I put the ROUND clause in.
,[RENTAL_COST_FW]
,[DAYS_BILLED_FW]
,[MILEAGE_RATE_FW]
,(([COST_LABOUR_FW] + [COST_PARTS_FW] + [CVR_FEE_FW] + [TOTAL_TAX_FW])) as FW_COST_TOTAL
I want to round the alias "FW_TOTAL_COST" to 2 decimal places... I keep getting a syntax error when I put the ROUND clause in.
Microsoft ExcelMicrosoft SQL Server 2008
Last Comment
Jim Horn
ASKER
Jim,
Yes, you are correct, my fault... it is FW_COST_TOTAL
Yes, you are correct, my fault... it is FW_COST_TOTAL
Give this code fragment a whirl..
,ROUND([COST_LABOUR_FW] + [COST_PARTS_FW] + [CVR_FEE_FW] + [TOTAL_TAX_FW],2) as FW_COST_TOTAL
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Scott, this is it. Cast didn't even cross my mind.. must have been in la la land at the time! Each variable (column) used in the computation is defined with 4 decimal places. What you gave me serves the purpose as I am working with 3rd party software, so this will keep me from having to physically change the attributes in the table.
Jim, thanks for your response, that syntax worked, but you had the round for one of the variables, not the alias.
Jim, thanks for your response, that syntax worked, but you had the round for one of the variables, not the alias.
>but you had the round for one of the variables, not the alias.
Curiosity overwhelms me ... what exactly do you mean by that?
The below code looks like four columns, not variables, and aliases are for naming only and do not participate in expressions, unless we're talking a subquery/cte..
Curiosity overwhelms me ... what exactly do you mean by that?
The below code looks like four columns, not variables, and aliases are for naming only and do not participate in expressions, unless we're talking a subquery/cte..
,ROUND([COST_LABOUR_FW] + [COST_PARTS_FW] + [CVR_FEE_FW] + [TOTAL_TAX_FW],2) as FW_COST_TOTAL
Show us the T-SQL that does this, and what is the data type (float, numeric, etc.) of this column?
>I want to round the alias "FW_TOTAL_COST" to 2 decimal places...
I don't see the column FW_TOTAL_COST anywhere in the above T-SQL block, (FW_COST_TOTAL, same thing?), so show us that too.