Sean Lange (11/5/2012)

---

Looks like all you need is:

Insert Into [Table1]
Select *, GETDATE()
From [Table2]
Where Record_ID NOT IN (Select Record_ID From Table1)

You could also make your Record_Change_date not null with a default of getdate().

menon.satyen (11/5/2012)

---

Hi David,

You have an incorrect query thats the reason why I asked for sp_help tables.

1. When you do an insert with record_change_date the end then it means the last column is record_change_date
2. But record_change_date is your 128th column and not the last
3. Hence you will have to specify the query like this

Insert Into [TableB]
Select column1,column2...column 127th,getdate(),column128th...column146th
From [tableA]
And name NOT IN (Select name From TableA)


Regards
Satyen