Erro converting varchar to float

See more:

SQL

SQL-Server

database

, +

I have written a stored procedure which takes some paramters. These are then used to populate a currency conversion rate table with data.

My issue is near the end of the stored procedure with my 2nd sql command.

The command works if I hard code the value like this:

<pre>SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = 1  WHERE CurrencyName = ''Rupee'';'

But i wish to use the values input by a user for @Rupee,@Euro etc.
Something like:

SELECT @SQL2 = 'update [dbo].[CurrencyTbl] set '+@CurrencyName+' = '+@Rupee+'CurrencyName = ''Rupee'';'

But I get the error:

Error converting data type varchar to float.

My code can be found at the below link

What I have tried:

mydb, Sql Server - rextester[^]