Guest User

Untitled

a guest
Jun 19th, 2018
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.68 KB | None | 0 0
  1. DECLARE @F_PARENTKEY INT,
  2.         @F5 FLOAT,
  3.         @F_TCKEY INT,
  4.         @F_KEY INT,
  5.         @RESULT INT
  6.  
  7. DECLARE @cur cursor
  8. SET @cur = cursor scroll
  9. FOR SELECT z.F_PARENTKEY,z.F8 AS F5,z.F_TCKEY
  10.     FROM TP_ZAG_F AS z
  11.     LEFT OUTER JOIN TP_ZAG_F AS f
  12.         ON  f.F_PARENTKEY=z.F_PARENTKEY
  13.             AND f.f_row=9
  14. WHERE   z.f_row =3
  15.         AND z.f8 IS NOT NULL
  16.         AND f.f5 IS NULL
  17.  
  18. OPEN @cur
  19. fetch NEXT FROM @cur INTO @F_PARENTKEY, @F5, @F_TCKEY
  20. while @@FETCH_STATUS = 0
  21. BEGIN
  22.     EXEC @F_KEY = [dbo].[TP_ZAG_KEY]
  23.     @RESULT = @RESULT output
  24.     INSERT INTO TP_ZAG_F (F_PARENTKEY,F_ROW,F5,F_TCKEY,F_KEY) VALUES (@F_PARENTKEY, 9, @F5, @F_TCKEY, @F_KEY)
  25.     fetch NEXT FROM @cur INTO @F_PARENTKEY, @F5, @F_TCKEY
  26. END
  27. close @cur
Add Comment
Please, Sign In to add comment