Next time I will make sure to format the query 🙂

Ahh got it, by removing where clause, thank you

Sorry for the confusion here is the actual query

yeah Table_A have 7 columns 🙂

ID,ROW_NUM,Error_CD,SRC_YR,SRC_CD,SRC_ID,SRC_NM

Insert into table_b

(ID,

ROW_NUM,

Error_CD,

ERR_MSG_TXT) -- brackets required

select

A.ID,

A.ROW_NUM,

Error_CD,

SRC_YR+SRC_CD+SRC_ID+SRC_NM as ERR_MSG_TXT -- double-pipe is not TSQL concatenation operator

from...

So Inner Join will work... right? I was confused weather to use Left Outer Join or not.

Thanks a lot for help

Like this

ID ROW CD Error_Msg_txt (concatination of Col1,Col2,COl3Col4 from table_A)

1 4 DUPBDGT FY12...

They are 4

select

A.ID, 1

A.NUM, 2

A.ECD, 3

Col1||Col2||Col3||Col4 as ERR_MSG_TXT 4 this is concatenation of columns of Table_A, the error_mesg_text will display duplicate rows data

Thanks

Well Actually I am doing Insert select and table have only 4 columns

In fact I started with OVER Function but then I also want my error_msg_taxt to display Concatenation of...

Thanks everyone.

Well Except is a good idea, but if the error exit I will have to Insert the error in Error table.

Can we use "except" to handle this situation ?

...

Well ON was by mistake I entered, my actual query doesn't have ON after left outer join, Only Left outer join table name .

Here what Business rule says,

A Utili...