SELECT 'IATA' AS 'MODULE',(SELECT * from [DBO].[FormatIndianCurrency](cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT' FROM TABLE NAME
Incorrect syntax near 'cast', expected 'AS'.
SELECT 'IATA' AS 'MODULE',(SELECT (cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT' from [DBO].[FormatIndianCurrency]) FROM TABLE NAME
SELECT 'IATA' AS 'MODULE', (SELECT * from [DBO].[FormatIndianCurrency] (cast(ISNULL(SUM(AMOUNT)*-1,00)) as decimal(19,2))) AS 'AMOUNT' FROM TABLE NAME
SELECT 'IATA' AS 'MODULE',(SELECT * from [DBO].[FormatIndianCurrency](cast(ISNULL(SUM(AMOUNT)*-1,00) as decimal(19,2)))) AS 'AMOUNT' FROM TABLE NAME
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)