Craig Farrell (9/8/2010)

---

Lutz, since when does a case statement in a...

Would you mind sharing your solution so others might benefit?

I would prefer a solution that would be able to benefit from an index on that date column, or I would add shift table that would specify the period it's...

A totally different approach:

You might want to have a look at one of Jacob Sebastian's TSQL Challenges.

It might help to look through the various solutions...

Or, if you already know the...

Steve Jones - Editor (9/8/2010)

---

I think Lutz has some bad karma going. It seems every weird thread I come across with a difficult OP is one in which Lutz is...

Tom.Thomson (9/8/2010)

---

Now that I've seen that one, and the one...

Please have a look at the CrossTab article referenced in my signature.

Give it a try and post back if you get stuck.

Once you figured how it works you might want...

Funny...

Now that you actually have an avatar go back to your question and re-read it. After that have a look at the avatar right next to it. 😉

I know, the...

Almost.

Just try to run that code on a just created (empty) database in your test environment.

Most probably you'll get the same message like we do when we try...

As requested:

SSC1,

SSC2,

Several links at phpfreaks.com, go4expert.com, and...

What would be your expected output for

INSERT INTO @Tbl VALUES(1,1,'A')

INSERT INTO @Tbl VALUES(1,2,'D')

INSERT INTO @Tbl VALUES(1,3,'X')

INSERT INTO @Tbl VALUES(1,4,'A')

Would you mind telling us where you're located at?

It seems like a phenomenon...

I've seen this very same question (including exactly the same query even down to POPDATA.ANCNUMBER=720) at least a...

What would be your true or false condition?

Sounds like...

WayneS (9/8/2010)

---

Something like:

CREATE TABLE Book (BookID int....)

CREATE TABLE Borrow (BookID int, ...)

INSERT INTO Book...