I have a table to be updated having 3 columns ext_JobGroupCd,ext_JobCd,ext_OrderIngroup
When ever some body called a SP with ext_JobGroupCd,ext_JobCd,new_orderInGroup then the ext_orderInGroup of ext_JobGroupCd,ext_JobCd should be changed to new_orderInGroup and accordingly ext_OrderIngroup of other ext_JobCd s of each ext_JobGroupCd should be altered.
ie : Each ext_JobGroupCd has multiple ext_JobCd and are rated from 1 to n as ext_OrderIngroup
where n is number of ext_JobCd exists in ext_JobGroupCd
When I execute the beløow script I am not able to get result due to some problem can some body help asap
WITH RECURSIVE UPDATE_JOBINGROUP
SELECT ext_JobGroupCd,ext_JobCd,ext_OrderInGroup,3 AS new_OrderInGroup FROM D_EdwTmp.ext_SaJobInJobGroup
where ext_ActiveRowInd='Y' and ext_JobGroupCd='TableLoadedTasks' and ext_JobCd='RunFlush'
SELECT A.ext_JobGroupCd,A.ext_JobCd,A.ext_OrderInGroup,B.new_OrderInGroup+1FROM UPDATE_JOBINGROUP B
WHERE A.ext_OrderInGroup>3 AND A. ext_ActiveRowInd='Y' and A.ext_JobGroupCd='TableLoadedTasks'
SEL ext_JobGroupCd, ext_JobCd, ext_OrderInGroup, new_OrderInGroup FROM UPDATE_JOBINGROUP