Advertisement
Hippolito

Untitled

Jul 20th, 2020
1,169
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.79 KB | None | 0 0
  1. DECLARE  @Farm         VARCHAR(100),
  2.          @Serial       VARCHAR(100),
  3.          @1StDayPart   DATETIME
  4.  
  5. DECLARE MyCursor CURSOR FOR
  6.  
  7. SELECT   DISTINCT
  8.          [Farm],
  9.          [Серия],
  10.          MIN([serv_date]) AS [serv_date]
  11. FROM     [dbo].[Pigs_PartyAnimals_FC]
  12. GROUP BY [Farm],
  13.          [Серия]
  14. ORDER BY [serv_date] ASC
  15.  
  16. OPEN MyCursor
  17.  
  18. FETCH NEXT FROM MyCursor
  19. INTO  @Farm, @Serial, @1StDayPart
  20.  
  21. WHILE @@FETCH_STATUS = 0
  22.  
  23. BEGIN        
  24.  
  25. EXEC [dbo].[Load_Plan] @Farm, @Serial, @1StDayPart
  26.  
  27. --SELECT @Farm, @Serial, @1StDayPart
  28.  
  29. FETCH NEXT FROM MyCursor
  30. INTO  @Farm, @Serial, @1StDayPart
  31.  
  32. END
  33. CLOSE       MyCursor
  34. DEALLOCATE  MyCursor
  35.  
  36.  
  37. /*
  38. EXEC [dbo].[Load_Plan] '000000002', 'Ч1.2020.16.01', '2020-04-15 00:00:00.000'
  39. EXEC [dbo].[Load_Plan] '000000002', 'Ч1.2020.17.01', '2020-04-22 00:00:00.000'
  40. */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement