Very cool and good to know.

I think you just saved my plenty of time in my OCD of ordering joins and where clauses logically.

I agree with you on...

Thanks Grant 🙂

I know how to use sp_executesql and pass parameters through that. My only issue is getting around the character limit for my more robust queries 🙂

Not this one necessarily, but I have several Stored procedures that are similar to this vien, some of them have multiple variations that I would like to test the viability...

Yes my jaw hit the desk when I saw 50million cost originally!

I concluded after researching the chaotic sea that was the execution plan, that the distinct counts done on...

So I managed to get this refactored finally, other critical projects took priority!

I managed to squeeze the script down to 1 CTE and its subsequent Select statement. The high level...

Gail,

On your second link when you wrote about the Dynamic SQL; I really like that idea however my code is a little over 10k characters and parametrized

I have been...

Awesome idea Gail thanks!

Thank you for the links as well, they were very helpful!

Sorry for the delayed response on this!

I believe I figured out the problem. Here is what I believe was the issue; The stored proc is used for reporting service reports....

Thanks for the info!

Haha nice! Yea I know I can do it...its doing it when I have a lot on my plate already, plus deadlines of getting these queries done...faced...

That's actually exactly my intended need!

That solution crossed my mind a few times, the problem is I would have to rewrite the query I have which is over 200 lines...

Ok I have attached a text file that builds the data (19 rows) and does 3 select queries.

The first is the main and would be a small chunk out...

Ok Lynn you got it 😀

I know the article...I was being lazy (ok I was extremely busy!) and hoping for an easy answer...I will compose something here to consume 😀

Yes Autocreate Statistics are on. I was just making sure the DTA tuning engine creating its own extra ones, if I should add that to the table drop and create...

Not a problem Bob.

What is the Crosstab solution?

So the Join ended up doubling the time it took to run, but I did find a single query solution to assign the values outside of a CTE :-D. It's...