this is very urgent somebody help...

column may change time to time

Thanks everybody...

It helps me a lot .

thats cool. Me too tried the same....

is there any other way ?

Sean Lange (8/27/2013)

---

vignesh.ms (8/26/2013)

---

hi SSCrazy Eights,

I have 2 table say source and destination.

I'm trying to insert data from source table to destination table ,which are not available in the destination...

hi SSCrazy Eights,

I have 2 table say source and destination.

I'm trying to insert data from source table to destination table ,which are not available in the destination table.

this is the...

how do i get that tool?

is there any other way??

THANKS EVERY BODY

Hi jethrow ..

if the all the marks are same need to show all the column names

@jeff Moden

Case is doing good ..

but that question was not for the case solution. that's for Erland's Query...

Yes Erland Sommarskog..

Thanks for your kind response & the assistance....

Well said ... I'm newbie to sql ...

your query uncovers some new query techniques to me

thanks again..

this gives the ans but difficult to understand that's why....

yes I accept that this is the bad design ..

Is there any other possible way??

this sounds good ..

kindly share me the query to create a trigger to achive this.