dbowlin (9/9/2010)

---

Apologies. I have had similar problems, I should have thought of this before my answer.

Usually when I run into this, I have to go back to...

David Burrows (9/9/2010)

---

sangeethu (9/9/2010)

---

Hi Lutz,

Thanks for the reply. I have gone through Cross Tab and Dynamic Cross tab and found that it involves aggregation of a column. But in my...

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?