Lynn Pettis (6/1/2016)

---

Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need to do...

So, is 6/1/2016 June 1,...

Just looking at the diagrams here does anyone else think a few of them may be wrong? It could just be me, but I need to do some testing...

It might be me, but I think two or three of those diagrams may be wrong. I'll have to set up some tests to verify.

info 88249 (6/1/2016)

---

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

I changed...

I haven't used...

info 88249 (6/1/2016)

---

Lynn Pettis (6/1/2016)

---

info 88249 (6/1/2016)

---

I changed them all 😉

this is...

info 88249 (6/1/2016)

---

I changed them all 😉

this is my final query:

SELECT

S.TICKETNUM...

You will also need to change the inner join to Level5 to an outer join as well.

Change the join to the Items table from an inner join to a left outer join, see if that helps.

Any error messages in the SQL Logs? Just from your description, not much we can do to help.

jasona.work (6/1/2016)

---

Grant Fritchey (6/1/2016)

---

jasona.work (6/1/2016)

---

You know what's annoying?

When you're reading something, think of something (maybe related, maybe not) that you want to look up, and in the time it took...

If you can put a DBAUtilities database on the same server as the 3rd party database, your queries can execute the DelimitedSplit function from the utility database. No worry...

Post the actual execution plans for both runs as *.sqlplan files.

Any Threadizens in the Moab, UT area, please PM regarding a non SQL question.