Here's a snippet of code that works....
BEGIN TRANSACTION
DECLARE @Sql VARCHAR(8000)
DECLARE @Crlf NCHAR(2)
DECLARE @Tab NCHAR(1)
SET @Crlf = CHAR(13) + CHAR(10)
SET @Tab = CHAR(9)
SET @Sql = 'BEGIN TRANSACTION' + @Crlf +
'INSERT INTO' + @Crlf +
'AIM_SSPLVS_Dosage_Factor_Cost' + @Crlf +
@Tab + '(Producer_Type,' + @Crlf +
@Tab + 'Producer_Type_Id,' + @Crlf +
@Tab + 'Level2_Name,' + @Crlf +
@Tab + 'Level2_Id,' + @Crlf +
@Tab + 'Level3_Name,' + @Crlf +
@Tab + 'Level3_Id,' + @Crlf +
@Tab + 'Cost_Per_Dose,' + @Crlf +
@Tab + 'Cost_Per_Year,' + @Crlf +
@Tab + 'Doses_Per_Year)' + @Crlf +
'VALUES (' +
'''' + @Producer_Type + ''',' + @Crlf +
@Tab + convert(nvarchar(3),@Producer_Type_Id) + ',' + @Crlf +
@Tab + '''' + @Level2_Name + ''',' + @Crlf +
@Tab + convert(nvarchar(3),@Level2_Id) + ',' + @Crlf +
@Tab + '''' + @Level3_Name + ''',' + @Crlf +
@Tab + convert(nvarchar(3),@Level3_Id) + ',' + @Crlf +
@Tab + convert(nvarchar(3),0) + ',' + @Crlf +
@Tab + convert(nvarchar(3),0) + ',' + @Crlf +
@Tab + convert(nvarchar(3),0) + ')' + @Crlf +
'COMMIT TRANSACTION'
PRINT @SQL + @Crlf + @Crlf
--EXEC (@SQL) --uncomment this line to execute the above code
COMMIT TRANSACTION