Posted on: 6/13/2015 5:04:15 AM | Views : 878

Hi all,
Calculating file size
DECLARE @fileSize DECIMAL(18, 2) = 2073741824 SELECT CASE WHEN @fileSize < 1024 THEN CONVERT(NVARCHAR, @fileSize) + ' B' WHEN @fileSize >= 1024 AND @fileSize <= 1048575 THEN CONVERT(NVARCHAR, ROUND(@fileSize / 1024, 2)) + ' KB' WHEN @fileSize >= 1048576 AND @fileSize <= 1073741823 THEN CONVERT(NVARCHAR, ROUND(@fileSize / 1048576, 2)) + ' MB' ELSE CONVERT(NVARCHAR, ROUND(@fileSize / 1073741824, 2)) + ' GB' END it returns
(No column name) 1.9300000000000 GB

I want to keep 2 digits after decimal like this
1.93 GB
How to get 2 digits after decimal ?

Thanks in advance




sds

Go to the complete details ...