Convert Money from SQLServer to Decimal

In SQLServer, Money is converted to DecimalSQLServerDECLARE @ login, @ digitsSMALLINT, @ login, @ sqlstrNVARCHAR (100) DECLARE @ inputMONEYDECLARE @ fFLOATSET@input234214.4434SET @ int_digitsfloor (log10 (@ input )) + 1SET @ f @ input-fl

In SQL Server, convert Money to Decimal SQL Server DECLARE @ int_digits SMALLINT, @ digits SMALLINT, @ total_digits SMALLINT, @ sqlstr NVARCHAR (100) DECLARE @ input MONEYDECLARE @ f FLOATSET @ input = 234214.4434 SET @ int_digits = floor (log10 (@ input) + 1 SET @ f = @ input-fl

Convert Money to Decimal SQL Server in SQL Server

DECLARE @int_digits SMALLINT,@digits SMALLINT,@total_digits SMALLINT,@sqlstr NVARCHAR(100)DECLARE @input MONEYDECLARE @f FLOATSET @input=234214.4434SET @int_digits=floor(log10(@input))+1SET @f=@input-floor(@input)SELECT @digits=case LEN(CAST(@f AS VARCHAR))-2WHEN -1 THEN 2WHEN 1 THEN 2WHEN 2 THEN 2WHEN 3 THEN 3ELSE 4ENDSET @total_digits=@int_digits+1+@digitsSET @sqlstr=N'SELECT CAST('+STR(@input,@total_digits,@total_digits)+' AS DECIMAL('+STR(@total_digits)+N','+STR(@digits)+N'))'exec sp_executesql @sqlstr