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

Also there needs to be some rationale more than just name for when there are more than 1 child rows.

Consider this:

select * from #oldAccount where Name = 'MyAccount1' order by...

But can...