jdowling 65301
Old Hand
Points: 336
More actions
August 26, 2011 at 1:38 pm
#247139
SELECT ISNULL(SUM(CAST(hsi.itemdatapage.filesize AS BIGINT)),0)/1024/1024 AS Storage
This give me back MB. If I try to add another /1024, it blows up. WHy?
Ninja's_RGR'us
SSC Guru
Points: 294069
August 26, 2011 at 2:04 pm
#1374098
Try / 1024.0 (any of them).
That will convert to decimal so that you don't get 0 when it's less than 1.
August 26, 2011 at 2:11 pm
#1374101
Yep that worked, thanks. Hmm, less than one...learn something new every day...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply