Started off making this harder than it was. here is the code I came up (also note how I set everything up, as this is how you should post...

Duplicate post. Please don't post in multiple forums. You just fragment responses to your request for help that may result in duplicate work by others.

Please post replies here.

What kind of error messages are you getting? It would help if you would provide the entire error message(s).

This isn't the article I was thinking about, but it would definately be one worth reading for your project as well:

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx.

Going to say it again, you are going to need a rolling window partitioning for what you are trying to accomplish. Based on what I am seeing you want...

jim.rasmussen (8/14/2009)

---

Here is my proc

DECLARE

@HMY AS INT,

@STARTDATE AS DATETIME

SELECT

@HMY = HMY,

@STARTDATE = DTSTART

FROM

MM2WODET

WHERE

DTFINISH IS NULL AND

DTSTART IS NOT NULL AND

HPERSON = @USERHMY

IF @HMY > 0

UPDATE MM2WODET SET

DTFINISH =...

Deleted -- Gus's answer was more accurate.

Jeff Moden (8/14/2009)

---

From WikiPedia.com...

A crore (Hindi: ?????) (often abbreviated cr) is a...

Integer math. change the 60 to...

You need to lookup SAVE TRANSACTION in BOL (Books Online) You need to create a TRANSACTION SAVE point in the nested transactions if you want to be able to...

Not sure what is going on with your system either. i just started up a job on my system that has multiple data flow tasks running in parallel, and...

Interesting, I just checked on my x64 development server and there is an x64 version of DTExec and an x86 version of DTExec on the system.

Looks like you may need to implement a sliding window on the table and write a few maintenace routines to implement what you are looking to accomplish. Not sure...

jrw39 (8/14/2009)

---

I'm having problems with this query which should set a flag based on if then then else from access 07. I've converted it to CASE WHEN but I'm...

Here is some code to help you get started. Hopefully the article I had published on sswug.org will be republished here on SSC sometime in September.