Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @tcal table(TagIndex smallint,TagName nvarchar(20),Total decimal(18,2))
- 284.45
- 233.97
- 240.17
- 81.39
- 67.55
- 0.00
- 71.57
- 72.91
- select sum(CAST(Total AS decimal(18,2))) FROM @tcal where TagIndex>44
- 767.56
- 1052.01
Add Comment
Please, Sign In to add comment