fyi.. THSI ONLY SHOWS THE FIRST sp THAT THE NAMED sp IS CALLING. fOR EXAMPLE IF i HAVE THE FOLLOWING sp

LF5_Job

LF5_Job2

LF5_Job3

LF5_CalcFess

Where LF5_Job calls LF5_Job2 and Lf5_Job2 Calls Lf5_Job3 and LF5_CalcFees

When...

After getting a lot of heat from angry customers RG did make a formal posting about the issue acknowledging the problems with SQL History and said they're working on it. ...

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 3 years, 2 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 3 years, 2 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 =...