Also, he states that using the Distinct will not get the recommended results and can be very unreliable, in these cases. He does this for a living.

Thank you everyone for your help the answers, my instructor helped me figure this one out. The answer he was looking for was this:

SELECT VendorName

...

Yes I am a new student to TSQL and SS2K8. its a bit different than DB2s SQL. A lot of new code to learn. Last night at...

Ok. Thanks for all your help. But my SQL Server 2008 Instructor found the solution - it was when I downloaded the murach book example databases that caused the...

I need alittle more information since I cannot find the SQLEXPRESS Connection Mgr in the Properties window. But I did notice the Operation System is Window NT 6.1, when...

Even if this is a SS2008 version