Thanks for the CTE, I'll give that a go 🙂

Koen Verbeeck (10/3/2013)

---

You'll probably need a cursor to update your values, because to calculate the OneStopOrNot column for one row, you need the calculated result of OneStopOrNot column of the...

2008R2

Attached is a sample data set from excel, that I'm creating...

Koen Verbeeck (10/3/2013)

---

J39L4753 (10/3/2013)

---

Sorry forgot to add that A8, A9 E8, E9, L8 are cell rows within Excel

Column A = PersonID

Column E = DateOfAppt

Column L = is the column that...

Sorry forgot to add that A8, A9 E8, E9, L8 are cell rows within Excel

Column A = PersonID

Column E = DateOfAppt

Column L = is the column that I will use...

Thats it 😀

Brilliant thanks for the help

Gazareth (5/8/2012)

---

Yes, just do:

SELECT CASE WHEN EXISTS(subquery) THEN...

There are some situations you can't use it (e.g. in a group by clause IIRC), but SQL should tell you quite clearly in...

I need to be able to Insert or Update the fields depending on what the source table has done.

The MERGE has been working very well now, which is great 🙂

One thing I do have a question on is this

I get this error below

Msg 8672, Level 16, State 1,...

SQL Kiwi (1/9/2012)

---

The ON clause is used to specify conditions to determine if source and target rows join or not. In your case, it seems the ON clause should...

jez.lisle (1/9/2012)

---

John Mitchell-245523 (1/9/2012)

---

I would guess this is caused by a difference in the local settings for each user - you and the user that connections to the linked server...

Dev (1/9/2012)

---

I understood you don’t have access to another server except read / execute. But my question is still unanswered. Can someone verify that the job runs successfully...

Yes, because the Linked Server has...

John Mitchell-245523 (1/9/2012)

---

I would guess this is caused by a difference in the local settings for each user - you and the user that connections to the linked server are...