Is there a reason why you don't have the logic to create the temp tables in the main SP?

You might also try:

;with DateCTE(FullDate, SubSet)

as

(Select FullDate,

SubSet = NTILE(52) OVER(ORDER BY FullDate)

from dw.DimTime

where FullDate between '12/28/2009'...

LOVE the tips!! At work, I'm a go-to person for query help and agree that the 3000+ is a bit overwhelming. I'm going to encourage users to read your...

We currently have data dictionaries for much of our data warehouse, but as we build new tables (and corresponding data dictionaries) this will be helpful. Thanks for the procedure!

My...

There's likely a much simpler solution, but it's Saturday morning and I'm not quite "clicking" 😉

Try this:

with TermCTE (Doc, ProdType, Term, TermType) as

(Select

Doc,...

Depending on the uniqueness of the data, I'd recommend a non-clustered index on both tables for the following fields at a minimum: DataAreaId , BOMID, PriceCalcID

When I say...

Are you hoping to populate all rows with the one value or is it a different value for each row?

If you want to know if it's in any row within the table then try:

SELECT QUESTION_ID,

POSSIBLE_ANSWERS,

...