GilaMonster (5/18/2009)

---

Yup. Family came to SA when I was 4

Its still raining...

rodjkidd (5/18/2009)

---

Tom Brown (5/15/2009)

---

So you're a Brummie?

How long did you stick around before heading off for the sun

Its still...

Which is why I'm suggesting an INSTEAD OF trigger. ...

would it work as you wanted it if it were an 'INSTEAD OF INSERT' trigger?

and I agree with Luke .. a Unique constraint is probably the way to go.

Yes question is wrongly worded.

But to top answer was the only one with the two numbers 50 & 16 so i ventured a guess.

something like this- assuming there is a 1 to 1 relationship tblA.pKey = tblB.updateKey

UPDATE tblA

SET tblA.col1 = tblB.col1

FROM tblB

WHERE tblA.pKey IN (SELECT TOP (100) tblB.updateKey

...

This may not be the best way, and without knowing your exact record structure this can only be a hint, but it will give you an idea to try out.

WITH...

Is there a reason for this piecemeal update?

I can think of 2 methods that may be of use. You could use TOP, or a WHILE Loop.

So you're a Brummie?

How long did you stick around before heading off for the sun

Its still raining by the...

OMG! Thats not what I think it is - is it? one of Uncle Sams air...

Did I detect something flying through the air?

You old robot killing machine 😉

GilaMonster (5/15/2009)

---

Luke L (5/15/2009)

---

Nope I was referring to the link Tom Brown posted. It seemed like he was trying to post a location and ended up putting that in...

Right in the middle of good ole Blighty. 😀

http://maps.google.com/maps?source=ig&hl=en&rlz=&=&q=We%20walk%20in%20the%20dark%20places%20no%20others%20will%20enter&um=1&ie=UTF-8&sa=N&tab=wl

Where it is currently raining 🙁 as usual.

Or using EXISTS as was mentioned.

INSERT INTO tblFileNumber

SELECT TU.FileNumberRF

FROM tblUpdates AS TU

WHERE NOT EXISTS (SELECT * FROM tblFileNumber AS TFN

...

Hi - Try this, it should give a Rowtotal column at the end of each row

-- Parameters

DECLARE @StartDate Datetime;

DECLARE @EndDate Datetime;

DECLARE @SubjID INT;

-- Parameter values

SET @StartDate = '04/08/2009';

SET @EndDate =...