I wouldn't vary the query, just vary the association. Easiest way to do...

Don't worry Celko, your continued posting is admission of failure on the part of evolution to remove the...

Ugh, nasty. You need a row-repeater. Which means... To the TALLY!

Check out the link in my sig on tally tables if you're unfamiliar. They're nothing more then...

fave_dba (12/1/2011)

---

We have a request from application team to refresh database for testing. This will be here for a short period and the drive space is low. As you may...

Brian, any chance you can bring up the actual execution plans...

tacy.highland (12/1/2011)

---

Is there a better way to do this? I need to set it up like this so one set of report recipients can receive the full report, while...

Lowell (12/1/2011)

---

where's the link to Gails articles about catch all queries?

( -- Get Non-Peer Categories without regard to Assignments

(esc.statusname != 'PEER' And @FilterAssigned = 0)

OR -- Get Non-Peer Categories Assigned...

Unfortunately, you're going to need to do as mentioned, create a quick software in .NET (and friends) that can create a filestream, and append each row in order and rebuild...

Can we see the .sqlplans for the two queries un-unioned and the unioned version?

Something's just not right...

Been there,...

Two options. As Elliott already mentioned, you can use a derived column task to include the variable as the column you're looking for before getting to the destination. ...

Grant Fritchey (12/1/2011)

---

Kiara (12/1/2011)

---

Brandie Tarvin (12/1/2011)

---

Hey, guys. Is Gus gone yet?

GSquared (12/1/2011)

---

- GSquared, RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA,...

p-nut (12/1/2011)

---

I'm not sure what you are doing, your pseudocode is not making sense to me except number 1. Please include DDL of both tables, sample data, and...

What is the variable type you're using to store the...

+1...