No, we mean it exactly as we wrote it. What you posted is a sort of random mish-mash of things we posted...

Sweetbee870 (1/14/2016)

---

Thank you! I appreciate the help!

I do have a question when joining multiple tables together I do know we use the like fields within each table. As you add...

TomThomson (1/13/2016)

---

SQLRNNR (1/12/2016)

---

I dunno about the "correct" answer on this one. The statements compile for me but produce an error at run-time. Seems to be a bit of a mixup...

A very good question and I am absolutely happy with it.

One thing that is missing is the explanation of WHY in this specific case enforcing the order impacts the performance....

ScottPletcher (1/13/2016)

---

That said, an identity column is often useful on a table, although not always. However, so many are addicted to the crutch of having an identity there that...

You probably have users that have dbo rights. Those bypass all security checks. (Or users do the deletes through stored procedures that are owned by the table owner, in which...

etl2016 (1/13/2016)

---

thanks.

The 20 tables are actually intermediate 'result sets' each of which are LEFT OUTER JOIN-ed to the other incrementally.

I believe, whether its 20 physical tables or 20 data sets...

It actually is. If not needed, it is a waste of storage both on disk, in all...

First, create a table source (e.g. temporary table, CTE, derived table, ...) that has all the weeks you need to include in your report.

Second, replace the

From @Temp

Where (Week_no IN...

Not sure how you do a cursor over a stored procedure result. If you do it by storing it in a temporary table then cursoring over that, then my remark...

Fixed that for you. 😉

Based on what logic is that row returned? The date listed is not within the next two months, and the course listed is not the course you include in the...

Okay, I have not run your code yet, but I did notice that you do not have any ORDER BY in your cursor definition - so how do you ensure...

Gail's observations are correct. Some more input:

* If cost threshold for parallelism is at 50 and you still see lots of CXPACKET (meaning: lots of parallel stuff), then you are...

Thanks for the additional information. Please repost the INSERT statements for the CourseInstance table, using an unambiguous date format: yyyymmdd. Now I have no idea how to interpret the dates...