So then...

saltpepo (9/25/2012)

---

Using function u can get desired result without cursors.I created split function above use that.

Declare @asd nvarchar(100)

select @asd=Field1 from Test where create_dt='24/Sep/2012'

Select Data as...

And of course if the exact rows matter this can get a LOT more challenging because there may be more than 1 pair where the sum is the total you...

SQL_beginner1 (9/24/2012)

---

Thanks, Lynn and Sean.

Yes, that worked!! 🙂

So can I take way the following as a rule?

"Don't fully qualified the column that needs to be updated (in a scenario like...

L' Eomot Inversé (9/24/2012)

---

Sean Lange (9/24/2012)

---

Tom I was typing before I really understood the question completely. Maybe if I had used the...

Tom I was typing before I really understood the question completely. Maybe if I had used the word history instead of audit...

Oh I think I see your error. You fully qualified the column to update which I think will not work. If Lynn's does not work try this one. Although he...

Gazareth (9/24/2012)

---

Ha, almost certainly!

Thanks for your input Sean, just had a nagging thought at the back of my head that I can...

SQL_beginner1 (9/24/2012)

---

Sean, the code you provided returned one row of data that included all the columns from table ContractData; and accountnumber, sourcesystem, effectivedate, siccode & coreprocesstoken18 from UDBSourceData for the...

SQL_beginner1 (9/24/2012)

---

Lynn, it's a table.

Both the source and the destination tables have the same columns, and I need to update the column coreprocesstoken18 in...

Gazareth (9/24/2012)

---

Sean Lange (9/24/2012)

---

Are you trying to audit when a given sourcefile was used to update a specific server? The way you have this coded you can only ever update...

I too suspect this is a view. What does this return?

select top 1 *

FROM ContractData AS cd

INNER JOIN

(select accountnumber, sourcesystem, effectivedate, siccode, coreprocesstoken18

from RR_GMC.RCA.dbo.UDBSourceData

where sourcesystem = 'CAN'

and effectivedate = '6/30/2012')...

I see you are pretty new around here. For this type of thing it really requires that you post ddl (create table statements) and sample data (insert statements) along with...

Gazareth (9/24/2012)

---

Hello,

I seem to recall from my database design classes a while back, being told that a link table with just a datetime field in wasn't really a link table.

I've...

chinn_chris (9/24/2012)

---

Yes, that does help. Thank you for your almost immediate response! I had a feeling it might be that but couldn't find anything online about that particular...