In addition to the benefits of a NUMBERS table shown by Micahel, the ability to intentionally generate a Cartisian product is anoter use of the table.  I'm referring to a Cartesion product...

Christopher,

This has got to be a first for me.  It's been 24 hours since I posted the above item and I have yet to recieve a single response.  Am I...

Does anyone know how to get to the Calculator referenced in the article?  It says you have to be a memeber of baseline and I tried to sign up but...

First off let me say thanks for the replies.

The query needs to return the following data:

Custmer ID, Min(Payment COntrol #), Date Of Min(PaymentControl#)

The problem is getting the right date for...

Can you provide a few example customer numbers that demonstrate both numeric and text values and then tells us how you would sort those manually, what logic you would use...

Thank you sooo much for writing an article that is an honest look at XML and not one that’s nothing but another praise of XML and how XML is...

With 65 replies so far I have not been able to read them all (nor do I plan to) so I hope what I say isn't a repeat.

In my mind...

Gilamonster,

I have read the comments by some advocating less or little to no documentation and I do understand why you feel the way you do but that type of mentality...

I've been at my current job for 5+ years and it seems like no one in our development dept ever provides comments in any type of code be it in...

Arun,

    The first reply to your message has the correct answer however I'd like to elaborate on the answer and try and re-word it another way that I think is...

Thanks to everyone for offering some input.  Unfortunately in the end we just had to remove everything off of our SQL Server hard drives in order to make room for...

Anyone know if there is a way to report this to Microsoft as a possible bug?

Thanks

Ed

Thanks to everyone for your replies.  I just can't believe that there is no way in SQL Server to deal with a case like this, where the client has backed up...