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

How to create a distinct table combining records with Null values

P: 1
Hello!

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 rows....is this possible?

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


ck9663
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.