By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,361 Members | 3,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,361 IT Pros & Developers. It's quick & easy.

How to create a distinct table combining records with Null values

P: 1

So I've been trying to figure out how to do the following in T-SQL:

Orig Table:
Col1 Col2 Col3
Set A Null Null 20
Set A Null 20 Null
Set A 10 Null Null
Set B Null Null 80
Set B Null 60 Null
Set B 50 Null Null

Iím trying to make it look like:

Col1 Col2 Col3
Set A 10 20 20
Set B 50 60 80

So essentially...grabbing distinct rows and combining the datas of the distinct this possible?

Aug 20 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
How many columns are we talking about here?

-- CK
Aug 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.