Hello everyone, I m going to share the query for convert MB to GM in sql server.
The Query as given below.
ALTER FUNCTION [DBO].[FUN_CONVERTMBTOGB]
(
@USAGEINCLUSION
BIGINT
)
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE
@RETURN VARCHAR(50)
DECLARE
@ISRESULT VARCHAR(50)
DECLARE
@TGB INT
IF(@USAGEINCLUSION >= 1024)
BEGIN
SET
@ISRESULT =(SELECT CAST(@USAGEINCLUSION AS DECIMAL(18,2))/1024 AS INT)
SET
@TGB = (SELECT VALUE FROM [DBO].[SPLIT](@ISRESULT, '.') WHERE ID= 2)
IF
@TGB > 0
BEGIN
SET @RETURN = CAST(FORMAT(CAST(@ISRESULT AS DECIMAL(18,2)),'N2') AS NVARCHAR(15)) + ' GB';
END
ELSE
BEGIN
SET @RETURN =(SELECT VALUE FROM [DBO].[SPLIT](@ISRESULT, '.') WHERE ID=1) + ' GB'
END
END
ELSE
BEGIN
SET @RETURN = CAST(@USAGEINCLUSION AS NVARCHAR(15)) + ' MB';
END
RETURN
@RETURN
END
|
Anil Singh is an author, tech blogger, and software programmer. Book writing, tech blogging is something do extra and Anil love doing it. For more detail, kindly refer to this link..
|