Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle cursor convert into sql server coding

Status
Not open for further replies.

luk4u

IS-IT--Management
May 15, 2003
2
IN
DECLARE
v_counter NUMBER := 1;
BEGIN

FOR i IN (SELECT DISTINCT empno
FROM emp)
LOOP

FOR i IN (SELECT DISTINCT deptno
FROM emp >
WHERE empno = i.empno)
LOOP
FOR k IN (SELECT amt
FROM emp
WHERE empno = i.empno
AND deptno = j.deptno
ORDER BY amt DESC)
LOOP
IF v_counter > 25 THEN
v_counter := 1;
GOTO k;
ELSE
INSERT INTO emp VALUES (i.empno, j.deptno, k.deptno);
COMMIT;
v_counter := v_counter + 1;
END IF;
END LOOP;

END LOOP;

FOR l IN (SELECT DISTINCT deptno
FROM emp
WHERE empno = i.empno)
LOOP
FOR m IN (SELECT amt
FROM emp
WHERE empno = i.empno
AND deptno = l.deptno
ORDER BY price DESC)
LOOP
IF v_counter > 25 THEN
v_counter := 1;
GOTO m_loop;
ELSE
INSERT INTO emp VALUES (i.empno, l.deptno, m.deptno);
COMMIT;
v_counter := v_counter + 1;
END IF;
END LOOP;
END LOOP;

END LOOP;

END;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top