Combining two sql columns into one column

Question

I have table with two columns, both of them contains integer values, that looks like this:

DocumentUpId    RelatedDocId
31608768        31624333
31608768        31624334
31618133        31618117

And I am trying to merge them into a single column like so:

DocumentUpId    
31608768        
31608768        
31618133    
31624333
31624334
31624334

I have tried this:

select rel_CTE.DocumentUpId + rel_CTE.DocumentDownId as 'RelatedDocId' 
into #temprelations 
from RelationsCTE rel_CTE

But it gives me concatenate of values (well sum in this case), so is it possible?

Serg · Accepted Answer · 2016-08-16 13:12:48Z

9

UNION ALL

select rel_CTE.DocumentUpId  as 'RelatedDocId'  from RelationsCTE
union all
select rel_CTE.DocumentDownId from RelationsCTE

answered Aug 16, 2016 at 13:12

Serg

22.9k5 gold badges23 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

StackUser · Accepted Answer · 2016-08-16 13:24:47Z

4

Try like this,

SELECT DocumentUpId as DocumentUpId 
FROM RelationsCTE

UNION ALL

SELECT DocumentDownId as DocumentUpId 
FROM RelationsCTE

edited Aug 16, 2016 at 13:24

answered Aug 16, 2016 at 13:12

StackUser

5,3983 gold badges29 silver badges48 bronze badges

4 Comments

sstan Over a year ago

union will not give the correct results as it filters duplicate values.

Tanner Over a year ago

don't really understand the down vote for something that's easily corrected within a reasonable time frame, what's the point? have a +1 from me

sstan Over a year ago

@Tanner: And what I want to know is why these easy questions/answers get so many votes (both up and down), and then those that answer difficult questions barely get any upvotes. I think I know the answer to that, but still...

Tanner Over a year ago

@sstan that's the way of the world. the suggested duplicate was too late and not really a suitable candidate, but that would have been the way to go. it's not too late to close.

Unnikrishnan R · Accepted Answer · 2016-08-16 14:13:59Z

0

Try some thing different using CROSS -APPLY :).

SELECT [RelatedDocId]  
FROM RelationsCTE 
  CROSS APPLY (VALUES(DocumentUpId),
                     (DocumentDownId)) V( [RelatedDocId])

answered Aug 16, 2016 at 14:13

Unnikrishnan R

5,0511 gold badge15 silver badges21 bronze badges

Collectives™ on Stack Overflow

Combining two sql columns into one column

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related