Couldn't you also accomplish the same thing using the PIVOT command? Wouldn't that perform better?

Enjoy!

Sorry about that. They won't let me edit it after submission. Not sure why the formatting didn't work.

/*********************************************************************************

Name: SP_BAK_MIGRATE

Author:...

Thanks, not sure why it didn't format correctly.

/*********************************************************************************

Name: SP_BAK_SVN

Author: Sean D. Brian, ITX Enterprises

...

HowardW (9/27/2011)

---

SDB15 (9/27/2011)

---

Use CTEs with care, if the expected row count is very high, you're actually better off with a temp table. I've also read that CTEs have a hard...

Jack Corbett (9/27/2011)

---

You can often get the same data using a CTE or derived table. Something like this:

CTE:

;WITH ItemCount AS

(

...

Here are a few ideas:

Put the sub-query in the from clause as a derived...

Another common problem I've had is where SQL will assume I want the results rounded to an INT. I usually solve the problem by adding .00 after the number in...

Sorry for the double post, I'm also looking into putting DBCC pintable on the tables in question (2 tables that make up the greater part of our datamart). Im hesitant...

notoriousdba (9/13/2011)

---

It's hard to say without more information, but here's an article I found very useful when I ran into similar problems that did turn out to be an issue...

Thanks, still no dice.

The query still isn't returning on the 2008 box. It still has to do an insert into the result table so it has the same problem.

I'm stuck.

Tried changing "H" to a subquery inside the recursive CTE but aggregates and even left outers are not allowed. Its ugly, but it buys me time to find a real...

Sean Lange (9/9/2011)

---

Are the row counts on the base tables and the temp table similar? Rowcounts can adversely affect the execution plan especially with large temptables. I have the suggestion...

Tried changing the table variable to just adding another CTE to the stack. It runs but MUCH slower than my specs allow. Not sure why a CTE would be so...