How to merge multiple resultset into one column in sql server ?

Posted by Ranjeet_8 under Sql Server category on 1/1/2013 | Points: 40 | Views : 1863

Post Code |

Search Codes |

Code Home


  SELECT Column_Name as Result  FROM Table_1
  UNION ALL
  SELECT Column_Name FROM Table_2
  UNION ALL
  SELECT Column_Name FROM Table_3

Alert Moderator

Bookmark It

Comments or Responses

Posted by: Jasminej on: 10/23/2012 Level:Starter | Status: [Member] | Points: 10

Question and answer is something messing up!

The question should be like "How to merge multiple resultset into one"!

But, the question is different and the answer is different. Kindly check and update accordingly!

Do you agree this ?

thank you

Posted by: Sourabh07 on: 10/23/2012 Level:Starter | Status: [Member] | Points: 10

hi ranjeet...

I think question must be like "How to merge multiple tables into one excluding duplicate rows?".

Regards,
Sourabh

Posted by: Ranjeet_8 on: 10/23/2012 Level:Gold | Status: [Member] [MVP] | Points: 10

@Jasminej
Thanks.

Latest Code Snipptes