I am a purist at heart and was looking for a plain vanilla view. But you are convincing me that you need this sequence number stuff both of you are...

That's correct.

The keyword is contiguous.

Give me the start and end date of all contigous date sequences.

The interval can be anything. It can be a single day or 150 days. They never overlap. It's easy to get the start of an interval (the previous non weekend...

Just the min and max of each interval.

I just realized that the full title is "Matrix month columns out of sequence in 'Reporting Services'". The 'Reporting Services' part doesn't show up in the browser. I caught it...

So I ask the forum, has anyone understood Steve's problem - much less Scott's solution?

Having 'duly noted' my comment about posting code sounds like you're a bit ticked off with...

You should really post some DDL and sample data along with exactly what the output should look like. Once you do that you'll have about a zillion people on this...

Seems we all suffer from this and, I presume, the site administrators are aware of it.

A workaround suggested by Jeff Modem works fine for me, i.e. paste into MS Word...

If OrderSequence has a known upper limit this should do the trick. And if it should contain a correlated subquery, I beg everyone's pardon.:)

select [Order],max(od1)+' '+max(od2)+' '+max(od3)+' '+max(od4)+' '+max(od5)

from

...

Can you describe this in more detail? I can't see the problem.

I'm not sure that's going to be easy. Thus I did a quick display of numbers in a float column where I know I placed numbers with at most 6...

Tony Davis (11/1/2007)

---

Note, however, that I am having some formatting issues in IE6, with regard to the size of the code boxes. Do you see that too? All the code...

One thing I used frequently in VB6 to remove the time was the DateSerial function...

sp_prepare appears to be SS2005, i.e. don't see it in SS2K. In any case, many SPs in master have execute permission to public. I found at least one (sp_remove_tempdb_file) which...

I suspect some stored procedures require special permissions, i.e. datareader/datawriter is not enough. Just to give you one example, to use sp_password to change someone else's password requires you to...