You my friend have a collation problem. The problem is you are using accent sensitive collation. If you check your collation, it is probably SQL_Latin1_General_CP1_CI_AS. The problem...

This segment of code looks right. I would work my way through the code testing it piece by piece, from the top to the bottom. This way you...

Sorry, before making my post I really did not look at your data. The problem is that you are wanting to compare the inserted data to a table that...

Your left join is messing you up. Using left joins with additional join filters is not the most reliable method to return data. You should use the where clause...

All the syntax looked good except that in the CASE statement @PayFormulaCode you are missing the end. I think this is the one you were speaking of before. ...

HolderNum is an integer so when you are trying to concatenate it to the string, SQL server is trying to add the value...

Good solution ksullivan. I like it. It is much better than making the entire code block dynamic sql and is quite efficient.

Between the code we have discussed and the above mentioned ‘print’, there are two more IF statements (working) and a CASE select statement (working) of around 25 lines. Plus some...

You cant do it like that. You have to use truly dynamic sql.

e.g.

DECLARE @sql nvarchar(500)

SET @sql = N'

IF NOT EXISTS(SELECT ' + @ColumnName + ' FROM ' + @TableName...

Your begin and ends look to be correct. One thing I see with the code is your are comparing comparing units to null, with an equal operator

OR @Units =...

I would use ISNUMERIC

select distinct acct

from tbl_CYProcessedSales

where ISNUMERIC(Acct) > 0

order by acct

If exists should have a begin and end too. It is much easier to see this when you format the code, to make it look purtee 😀

IF @PayFormulaCode =...

Ok, I misunderstood what you are doing. I thought you were updating user ids. When an update occurs the new value goes into inserted and the old value...

In the output clause you have access to the inserted and deleted tables. To get the original value you would have to use the deleted table.

e.g.

DECLARE @tTest1 TABLE

(...

You run into more problems with dynamic sql like indexing, caching, recompiles etc. But if you must go with a dynamic sql solution I would recommend that you use...