Yes this is no problem. Even though this link is for 2005 it is the exact same process in 2008, not sure about 2012 since I don't have it.

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/d91d265a-59d3-4c8a-94ad-227611c342d8/%5B/url%5D

Is the datatype for archiveID int? Do you have any triggers on these tables?

reliableitservice (11/6/2012)

---

Thank you Lowell!!!!!!!

It works!!!!

I just not sure this this is what I was expecting. See, I am getting three columns: BILL_NUM, VALUE, and zzedatawhse.value.

The table shows all records from...

David F (11/6/2012)

---

Sean, I used varchar(Max) and the string was truncated. Is that a 2005 vs 2008 difference? Because i tried dynamic SQL first. Maybe...

Zeev Kazhdan (11/6/2012)

---

Oh no !!!! :blush:

It is pretty embarrassing! I didn't think about the update option at all it works like a charm with a minor change - ORDER BY...

ROFL. I drove past this bar the other day...honest it is called RBAR.

See the attached photo.

Eye Dee Ten Tea????

halifaxdal (11/6/2012)

---

GSquared (11/6/2012)

---

You'd have to define the variable inside the scope of the Exec command in order to do it that way. You're better off using sp_executeSQL instead.

EXEC sp_executeSQL...

river1 (11/6/2012)

---

Sean Lange (10/30/2012)

---

I think this should do what you are looking for but it is untested because I don't have ddl to work with.

create trigger TRG_CONTRIBUINTES_VERIFCA_RF_E_NIF on contribuintes

for update

as...

I am glad you found a way to solve your issue and thanks for letting us know.

I'm only disagreeing with the sentiment that listing out the columns is "the way...

David F (11/5/2012)

---

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...

David F (11/5/2012)

---

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...

weston_086 (11/5/2012)

---

I have two tables .Both have same columns except in table1 i have flag column which i need to update with 'yes' or 'no' after joining two tables on...

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...

OK I think this may be what you are looking for.

;with cte as

(

select *, ROW_NUMBER() over (PARTITION by Name order by ParentID) as RowNum

from #oldAccount

)

,cte2 as

(

select *, ROW_NUMBER() over (PARTITION...