September 9, 2005 at 9:13 am
I'm attempting to load several comboboxes (C# .NET) from an SQL 2000 data table (Reports). Now the problem is each combobox loads everything, even nulls that I don't need.
Simpy coding a 'Distinct' in the SQL will eliminate the nulls, however I have more than one column to be selected as 'Distinct'.. The following code is an example of what I need. It obviously does not work though.
Select distinct col_1, distinct col_2, distinct col_3 from table_1
September 9, 2005 at 9:24 am
Please dot not cross-post.
Finish the thread here :
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=218415
September 9, 2005 at 9:51 am
Sorry, didn't know which forum to post too.........
September 9, 2005 at 9:53 am
NP... just post to general when unsure.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply