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 ...