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)  Select one instance of an occurence from table

Author  Topic  aramos2 Starting Member 1 Post Posted - 2001-05-19 : 15:13:38 I am trying to select one instance of a vendor . Ex date Vendor No , Vendor Desc, Date 1234 , item1 , march 1 2001 1234, item2a , march 23 2001 12345 item1 , march 2, 2001 12345 item1a , march 14,2002 What I am trying to do is select only one instance of Vendor 1234, and It does not matter which desc , or date. I have tried a select distinct. But I get too many records back becuase the Vendor_No can be slightly diffrent for the same vendors and the date can be variable. I have tried a temp table .. . but it has not worked the way I want