End Google Ads 201810 - BS.net 01 --> Hi all,

I want to write a sql generic function that will return numeric value.
I want to pass the whole sql query.
but it results error when executing

my user user defined function:

Create FUNCTION GetDoubleAmount(@strSQL varchar(500))
RETURNS decimal(18,6)
AS
BEGIN
return (select @strSQL)
END

calling with:
select dbo.GetDoubleAmount(
'SELECT SUM(CRAMT) As TotAmt From tblTLHistory'
)
results:

Msg 8115, Level 16, State 6, Line 1
Arithmetic overflow error converting varchar to data type numeric.

please help in asap