<pre>SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = 1 WHERE CurrencyName = ''Rupee'';'
SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = '+@Rupee+'CurrencyName = ''Rupee'';'
Error converting data type varchar to float.
SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = ' + convert(varchar(100), @Rupee) + ' WHERE CurrencyName = ''Rupee''';
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)