Post repeat, please see question/responses here: http://www.sqlservercentral.com/Forums/Topic986689-145-1.aspx

The more urgently you need something, the more time you'll need to take writing out the sample code you'd like us to mess with. A couple of things though:

That...

For the code, you'll really need to...

Steve Jones - Editor (9/15/2010)

---

By the way, if going down is much faster than...

Swap to bulk-logged. The target system(s) will have to recreate the work but your logs will be smaller.

And thus, we find out why...

If it makes you feel better, I just did a facepalm...

CirquedeSQLeil (9/15/2010)

---

Steve Jones - Editor (9/15/2010)

---

Once that guy got outside the caged area, my stomach was flip flopping. Struggled to watch, and then was stunned again when he reached that...

rpalacios 19022 (9/15/2010)

---

Thanks for replies Mike and Derrick.

Derrick, when I execute the new query, I'm getting the following error:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "aspnet_users1.ApplicationId" could...

I'm... not sure. But, hazarding a guess, it's got to do with Truncate simply doing page deallocations instead of actually wiping data. Now, why backup is actually picking...

drew.allen (9/15/2010)

---

It's actually not a CROSS JOIN, because the value...

brian_winzeler (9/15/2010)

---

Ahh that fixed it. My whole point was to be pointed in the right direction (which this most certainly did!). I will definitely keep that in mind for future...

Yeah, I didn't build DDL out for the table so I didn't doublecheck my code for functional running, but I forgot to drop AS [name] in at the select levels...

:ermm: Yikes. That is one twisted piece of code you've got there.

Let me see if I get this straight. You set the group code, get the itemcode/levelval, and...

But but Lowell, If Iz answerz I kin haz internets cookie! Right? Prize iz internetz cookie?