Yes INSERT INTO.

I am getting an error that I need an output clause. Sorry, not sure where to put that or what syntax.

Exact Error:

Msg 10716, Level 15, State 1, Line...

P.S. I tried an insert in the sample below but is says I need a FOR OUTPUT and this is where I am stuck, don't know where to put...

Figured out solution. Still need to fine tune it but if it is useful to anyone here it is.

You can change the DB name, I just have that going into...

I am such an idiot. I was beating my head against the wall. It is not like I have not done this before.

Good grief.

I had 'stf.TableName'

Instead...

I hope this addresses what you are looking for. I uploaded the tables. with data for a give table.

Now if you query both those tables;

SELECT DISTINCT *

FROM SourceTableFields stf

WHERE TableName...

The environment is mixed. Thank you for the recommendation.

That is a great suggestion. In those case it wont work because I am having to link server call everything and their are many databases across multiple servers. In other...

Very awesome, thank you so much.

Thanks I had something like this as well but I need to specify the DB to get the count from. It will be a stored procedure and will be getting...

I messaged the person that sent the message to my group. They are usually pretty on point but I am confirming. And yes agreed this is not a MS SQL...

The issue seems to be outside my trigger.

And, I did include the text of the error message. Error message is as follows:

would update more than one row.

And yeah... you...

I tried manually updating a record that would result in a single row updated. And then one that results in multiple rows.

Both work fine. I should have done that...

So you are saying my trigger looks fine for updating several records? Not what I wanted to hear 🙁 It is a purchased app and I put audit tables on...

My new assignment here is full of it. If i were not so darn tired I probably would have gotten it. Thanks again! And yes dynamic SQL...

You Lynn are a genius!

Thank you so much for your help.