Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @Farm VARCHAR(100),
- @Serial VARCHAR(100),
- @1StDayPart DATETIME
- DECLARE MyCursor CURSOR FOR
- SELECT DISTINCT
- [Farm],
- [Серия],
- MIN([serv_date]) AS [serv_date]
- FROM [dbo].[Pigs_PartyAnimals_FC]
- GROUP BY [Farm],
- [Серия]
- ORDER BY [serv_date] ASC
- OPEN MyCursor
- FETCH NEXT FROM MyCursor
- INTO @Farm, @Serial, @1StDayPart
- WHILE @@FETCH_STATUS = 0
- BEGIN
- EXEC [dbo].[Load_Plan] @Farm, @Serial, @1StDayPart
- --SELECT @Farm, @Serial, @1StDayPart
- FETCH NEXT FROM MyCursor
- INTO @Farm, @Serial, @1StDayPart
- END
- CLOSE MyCursor
- DEALLOCATE MyCursor
- /*
- EXEC [dbo].[Load_Plan] '000000002', 'Ч1.2020.16.01', '2020-04-15 00:00:00.000'
- EXEC [dbo].[Load_Plan] '000000002', 'Ч1.2020.17.01', '2020-04-22 00:00:00.000'
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement