locked
query to eliminate the duplicates records coming from two tables result in sqlserver RRS feed

  • Question

  • Hi All,

    I have requirement to eliminate the duplicate records that comes out by using below query:

    The query is as follows:

    select distinct ColumnA,convert(varchar(max) ,ColumnB )as ColumnB1 from TableA
    unionall
    select distinct ColumnA,convert(varchar(max) ,ColumnB )as ColumnB1 FROM TableB

    Can anyone help me on this?

    Regards


    sudha

    • Moved by Tom Phillips Tuesday, November 6, 2012 3:46 PM TSQL question (From:SQL Server Database Engine)
    Tuesday, November 6, 2012 9:54 AM

Answers

All replies