kaushal_shah26 (8/1/2012)

---

Hi Guys,

I have a table like this

Id----------Type--------ConditionId-------isActive------SortOrder

1001-------860----------2----------------1------------1

1002-------860----------3----------------1------------0

1003-------860----------5----------------1------------Null

1004-------860----------1----------------0------------Null

1005-------860----------4----------------0------------Null

There are 3 conditions which are active. Out of those 3 conditions, 2 have sortorder value (1 and 0).

I need to write a script whereI need to update the record where condition is active but sortOrder is null (In the case above, it's conditionId 5).

I need to update the sortOrder with the next value of the maximum sortOrder for the type where isactive is 1.

so, in the case above, after the update, Id = 1003 should look lik this

1003-------860----------5----------------1------------2

I have been trying combination of queries but more I tried, more confused I got.

I would appreciate if you guys can guide me to resolve this matter.

Thanks.