Thanks for the tip

• This reply was modified 1 year, 9 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...

If I try to use what I showed it fails. I get an error on WO.dtCall, says multi-part identifier could not be bound.

Thanks

Will do.  Currently the report that uses the existing non-pivot query takes up to 5 minutes to render on screen even though the source query it uses completes within a...

Thank you for replying.  After posting this I tried searching via google for the answer and to my surprise the search terms I used were correct, somethin that rarely happens...

UPDATE: Since getting back from being out sick I've not had a chance to catch up on all the feedback for this post but I did want to take a...