Forum Discussion
Rob_Wilcox1
12 years agoLevel 6
My suggestion would be that this:
SUM(SS.ItemSize)/1024
isn't returning an integer.
Related Content
- 11 years ago
- 10 years ago
You're going to have to CAST the item to a bigger int
SUM(CONVERT(bigint,SS.ItemSize))
My suggestion would be that this:
SUM(SS.ItemSize)/1024
isn't returning an integer.