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...

First off I don't make any decission to make anyone's lives difficult.  The use of CR is a management decission which I have to deal with just as anyone in my...

Well if you try working with a query using some interface that doesn't support syntax highlighting and you compare this

SELECT T.Field As 'Alilas'

FROM TABLE T

verses this

SELECT T.Field Alias

FROM TABLE T

You'll...

Thats a nice littel utilty there.  I personally would love to see something that can add to this the ability to add table & field aliases using a best pratices...

Thank you Euan!  You are dead on with that answer.  After re-registring the DLL I am no longer having problems with veiwing the properties of a DB via Ent Mgr...