Hello Dawain,

Excellent, Thanks for sharing the query.

It works like a charm !!!

Thanks

KJ

Hello ColdCoffee / Dawain.c

Thanks for your prompt reply,

I tried both options CTE and Left join, it both works except for below condition,

INSERT INTO #TableA ( Col1 , Col2 , Col3...

thanks a lot...! Erik,

cheers

KJ

Hi,

how do you remove the default column (text) and underlines (----------------)?

Thanks

kj