Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Use of DISTINCT

Author  Topic 

KevinWilhelm
Starting Member

2 Posts

Posted - 2001-07-31 : 03:06:15
I'm trying to pull a list of DISTINCT names from a column - "names" and at the same time build a complete recordset that includes a description, date-recorded etc. How can I pull the DISTINCT list off one column but not affect the other columns included in the SQL statement.

Kevin

   

- Advertisement -