I didn't see anywhere that it said that the Server crashed, did it? I thought that Johan restarted the server himself in order to clear everything out.

Yes, but Reporting Services is expecting a single consistent set of columns in the rows that are returned to it. Are you saying that it doesn't matter which column...

Hmm, did you realize that based on ProductType, the fields (columns) that are returned are substantially different? How would you see that being resolved?

I will say this, an inability to properly manage employees is rarely fixed by outsourcing the employees.

Likewise, however, an inability to properly manage consultants is rarely fixed by hiring employees...

Heh, I started with half-adder circuit diagrams when I was 13. Then FORTRAN II, then original BASIC, then COBOL, etc...

Heh.

Cross-Joins are set-multiplications. The only metaphors I have ever seen for them are grids and rectangular areas.

JohnG; Actually, we've been talking about the BIT datatype. I think that you are talking about bit-masks encoded into INT's.

And a FULL OUTER JOIN would be both cricles? Hmmm,

I am curious to see how you are going to fit a Cross-Join into that example Grant. 😀

Jeff Moden (12/23/2008)[hrIt was a very long time ago that we did some testing on this very forum and I can't even remember who the players were. I can't...

Ninja's_RGR'us (12/23/2008)

---

The only problem I see is to be able to create a dynamic amount of keys without looping and without sacrificing performance (how do you handle making 10 keys...

And it's so much more general. The reason that I keep forgetting that SIGN() is in SQL is not because I am not familiar with it. Heck, I...

Yes, kudos is like an "Attaboy", only more prestigious. 😀

Actually I had intended to point to my own presentation and code, but flubbed the post (you can still find it at my blog, linked in my signature). I...

Check out this presentation and the associated code. It demonstrates how to do this.

Like matt says, there are lots of ways to move data from one table to another. Service Broker is one way, but is a lot more work than most...