Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
CASTING SUMMARIZED FIELDS 2
- Thread starter cristi22
- Start date
-
1
- #2
-
1
- #3
Cristi,
You say that you want to pass the value as decimal 9,2 and that both columns are 9,2 but in the code you seem to be asking for a decimal 12,2 format. Which do you require?
Either way, I believe that something along the lines of the following should help:
Marc
You say that you want to pass the value as decimal 9,2 and that both columns are 9,2 but in the code you seem to be asking for a decimal 12,2 format. Which do you require?
Either way, I believe that something along the lines of the following should help:
Code:
SUM(CAST RATE * QTY AS DECIMAL(9,2)) AS AMOUNTMarc
- Thread starter
- #5
- Status