It's more accurate...

Do you have specific rules in mind? If you do, then we might be able to help you build whatever you need. Just try to lay out what...

If you were to store the times in datetime fields, then it's simply a comparison. No hard logic other than whatever rules you wish to apply based on the...

smells like homework to me.....:ermm:

If it's truly the primary key, then the TOP 1 is not going to help.

I personally dislike (where dislike = is something I bounce back during code reviews) using TOP...

AnzioBake (10/30/2008)

---

Just to Play devils advocate...

At the lowest level even "set based" queries are handled at a row by row level:D

Think about updating running totals with the

var=col=var +cnt

syntax

(goes...

Well keep in mind that the code in one instance is running under your credentials, and in the other, under the SQL Agent's service account. That's two accounts right...

DavidL (10/30/2008)

---

OK, I tried it an see that the answer is not as obvious as I thought (...destroy all floats). But if there isn't a broad brush way to...

GilaMonster (10/30/2008)

---

Matt Miller (10/29/2008)

---

Not knowing your background, you may also start by making sure you fully understand what recovery modes are and why you would use one over the other....

Are you still having trouble? I can't quite tell if you fixed your own issue, or just one and there's still something to do.

If you still have trouble...

If you're using natve Access queries - you will need to use the NZ function instead of the ISNULL function Lynn mentioned (ISNULL is something different in Access).

Not quite - what I've seen that acts oddly on occasion is when you have

UPDATE blah

set ....

FROM

anotherBlah

where blah.id=anotherblah.id

Instead of

UPDATE blah

set ....

FROM...

In SQL Server - you'd simply add a JOIN to the FROM statement in your INSERT INTO.

Something like

Insert into #tmpTable(fieldlist)

SELECT fieldlist

from

tableA

Inner join Tableb on tableA.ID=tableB.id

WHERE

myCriteria=1

I haven't touched...

I think you issue is that you're not specifically mentioning the view you're updating in the FROM clause. That kind of stuff tends to be a timebomb of sorts,...

Then I'd flip the issue around. Use a .NET console app to create a properly delimited file (not XML) from the "native" XML, and the bulk load the new...