Sounds goods. Thanks for all the efforts from you...

thanks guys the fix was to pass in Updatedt=Updatedt the trigger itself was provided as required by the DBA wacky but that's the way they do things so I...

Can you post some sample data and the results you expect please? Make sure you're posting the data as formatted text (like you should be when pasting code). You can...

OK, well, here's the FULLY dynamic answer. This'll handle additional columns to your table, and additional dates. It's ugly, but it works. Is this a good idea, certainly not, but...

• This reply was modified 6 years, 7 months ago by Thom A.

I'm guessing you're wanting something a bit more dynamic here?

The problem is that people are taught to do this as a crutch to insure that the previous statement is terminated by a semicolon instead of being taught to...

Ok I have changed the code.  I added a things in the original code just because I was desperate. I tried changing the code closer to the original way...

There a few problems here, and each time I look at it I find another.

Firstly you are using the ‘’ characters, where you should be using ' for literal strings....

Binned this answer

• This reply was modified 6 years, 7 months ago by Thom A. Reason: Yeah, more errors than I first though
• This reply was modified 6 years, 7 months ago by Thom A. Reason: Binned

This is one reason why I dislike people being taught that a CTE "starts" with a semi-colon (;), because it doesn't. ; is a statement terminator, not a statement "beginningator"...

I assume Branch_key is some kind of numerical data type? Numerical data types don't store leading zeros. Assuming that Branch_key should have 6 characters (as you're casting to a (DT_STR,6,1252)...

That trigger is flawed, it assumes one row will only be affected. If inserted or deleted contain more than 1 row, what do you suppose these 2 statements will do?

The edit button is in the top...

yemeradil15 has made a couple of spam topics today Steve; if anyone can remove.

The simple answer is, you can't (not out of the box). What you are looking for is a Data Driven Subscription, and that is an Enterprise feature.

That's not to say,...