Sorry for not had post all that info.

What i want to accomplish is this:

SELECT X.* FROM

(

SELECT MP.*, RNum=ROW_NUMBER() OVER (PARTITION BY MP.ModuleCode ORDER BY MP.UserGroup)

FROM...

noeld (4/29/2009)

---

jpdlp (4/29/2009)

---

Example:

In the table [article table] , the column [article stock] is 5

subscriber 1 sells 1 unit and updates [article stock] to 4

subscriber 2 sells 2 units and...

Nice article.

And if the conflict was on the [Unit Stock] ?

Example:

In the article table, article X's article stock is 5

subscriber 1 sold 1 unit and updated article stock to 4

subscriber...