Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @F_PARENTKEY INT,
- @F5 FLOAT,
- @F_TCKEY INT,
- @F_KEY INT,
- @RESULT INT
- DECLARE @cur cursor
- SET @cur = cursor scroll
- FOR SELECT z.F_PARENTKEY,z.F8 AS F5,z.F_TCKEY
- FROM TP_ZAG_F AS z
- LEFT OUTER JOIN TP_ZAG_F AS f
- ON f.F_PARENTKEY=z.F_PARENTKEY
- AND f.f_row=9
- WHERE z.f_row =3
- AND z.f8 IS NOT NULL
- AND f.f5 IS NULL
- OPEN @cur
- fetch NEXT FROM @cur INTO @F_PARENTKEY, @F5, @F_TCKEY
- while @@FETCH_STATUS = 0
- BEGIN
- EXEC @F_KEY = [dbo].[TP_ZAG_KEY]
- @RESULT = @RESULT output
- INSERT INTO TP_ZAG_F (F_PARENTKEY,F_ROW,F5,F_TCKEY,F_KEY) VALUES (@F_PARENTKEY, 9, @F5, @F_TCKEY, @F_KEY)
- fetch NEXT FROM @cur INTO @F_PARENTKEY, @F5, @F_TCKEY
- END
- close @cur
Add Comment
Please, Sign In to add comment