If Cursors need to be used, I'm ok with that. Unfortunately, I dont have any experience using Cursors.

It's confirm sir

dwain.c (4/26/2012)

---

idyana,

As I promised, I am willing to take another shot at this but before I do, what I'm going to need from you is an exact expected results set...

Lynn Pettis (4/26/2012)

---

Please realize that we are volunteers and help when we can. While you are waiting, please feel free to continue working on your...

Really looking for help

Sir, your query still not cover the requirement as following,

What I want to do?

1. Each data in applyProgram need to be processed based on the data in programQuota

2. Each data...

tq Gail

Hi Gail,

There are four isolation levels:

1. READ UNCOMMITTED

2. READ COMMITTED

3. REPEATABLE READ

4. SERIALIZABLE

which one is suitable and the best?

Jeff Moden (10/30/2011)

---

BWAAA-HAAA!!! Oh, not to worry... I got all the rest of it. 🙂 I just wanted to know what the "MatrixNo" was. Basically, it's just...

Kindest Mr Jeff Moden,

Sorry for the weaknesses. I try to re-explain as above

My table and data as following,

declare @t1 table

(idx int identity, programID int, quota int, dtVersion timestamp);

/*programID is unique*/

insert...

tq to all

tq sir.

it's work and your solution really great. but, how to prevent another transaction is updated the myRunnNum till I'm finish?

Sir Welsh Corgi,

I cannot...

To Mr The Dixie Flatline & Mr Welsh Corgi,

Thanks for your technical info. Let me digest it. Will get back to you ASAP