The SQL Prompt User forums are filled with unhappy users.  You're the first person I've seen say it's better.  I tried SQL History and it was incredibly slow and not...

• This reply was modified 2 years, 5 months ago by YSLGuru.

Jeff - the code in the original post was removed b/c in just a few mins after posting it I figured  it out and I was going to delete the...

Jeff - Gotcha!

Jeff - The trigger did capture the change of a non-null value to null when I removed the date form an item and dtInactive was set to NULL.

Thanks for the tip

• This reply was modified 2 years, 5 months ago by YSLGuru.

Jeff - Below is the code I used for INSERTs. Originally the join conditions (in the parens) were all set to AND. Once I switched to OR instead it worked....

Dumb Dumb me was looking at it in the opposite direction. Its 1AM and because the work computer is in the hallway next to my kids bedrooms I can't get...

I too was wondering why the temp table. I've had to create several AFTER INSERT/UPDATE triggers and never even considered adding a  temp table to the process. I Just use...

1. Even though its the vernacular right now we really should stop calling these chatbots AI as they aren't Artificial Intelligence.
2. As the story already has cited they have failed,...

I could see that, the Spock brow

Thanks Johan. For me it just looks wrong/bad. I mean if in some situations it provides better performance and enough so to justify  it then yeah but it just looks...

Jeff - is this something you'd personally recommend trying to avoid in queries?  Clearly it's a valid query because it does run but I can't help but wonder if like...

You can defer the ON clause for a JOIN until after other JOINs.  Normally you wouldn't do that unless it's absolutely necessary.

LEFT OUTER JOIN TABLEC CC ON (CC.hFKey4 =...

IIRC, you'll find no place where I've suggested doing such a thing in the article because there are much more effective methods to find gaps in a sequence of values

Jeff...

NOTE: I was not the one who designed the DB I am working with so I can not ask questions as to "why did they do that" or 'Why did...