You may also want to try using multiple Selects separated by UNION ALL.

Oh... I almost forgot... I ran Phil's tests without modifying his code. I was so engaged in why he was getting his "reverse" findings, that I actually forgot to...

Thought I'd give a little feedback here... Phil reran his tests on his machine several times... same result... the While loop on a super string beat the tar out of...

chileu17 (10/6/2008)

---

eventhough the table has a primary key? and a non-clustered index?

non-clustered indexes are supposed to be inserted in a specific order right? :ermm: please correct me if I am...

Then, methinks that something is drastically wrong... you just said (and...

T-SQL isn't just "Declares"... it also includes all those really handy date functions. 🙂 And, yes... everything is possible...

SELECT CONVERT(CHAR(8),d1.StartDate,1) + ' thru ' + CONVERT(CHAR(8),d1.EndDate,1) ...

J (10/6/2008)

---

Thanks for the help.

Still, the thought process of whoever came up with this one remain baffling. Same as for the guy who figured out that nitroglycerin, an unstable explosive,...

bobhovious (10/6/2008)

---

Somewhat embarassing to get caught in typos that increase volumes :w00t:, or quick reads that miss the point being made. But I'll survive.

You never answered the...

Is that good or bad? 🙂

Very well done, Matt. 🙂

J... your "agressive curiosity" is what I call "intellectual curiosity". I believe you won't find yourself alone in that area.

I've not been able to keep...

Zypsy absolutely wants to use a spreadsheet because of some functionality that's easily available there. Although I normally oppose denormalized pivots for processing, Zypsy may be correct here and...

This forum is a bit odd... it sometimes turns left parenthesis into smiley faces. There was one in the test code generator. I've repaired that. Also, to...

Ok... got it. Since you didn't post the data in an easy to consume format and I just can't bring myself to post untested code, you'll have to put...

That's better, but guess what this code means?

SELECT BillDaten, CustCode, COUNT(*) AS ThingsThatNeedPivoting

FROM Sample_Data

GROUP BY BillDaten, CustCode

HAVING COUNT(*) > 1

BillDaten ...

Will those ranges always be for whole months that start on the first of a month and end on the last of the...