declare @var1 varchar(max) declare @var2 varchar(max) declare cur CURSOR LOCAL for select av0_style,av0_code from sl.dbo.av0_style AS s where s.av0_not_to_sale = 0 open cur fetch next from cur into @var1, @var2 while @@FETCH_STATUS = 0 BEGIN --exec your_stored_procedure @var1, @var2 print(@var1) fetch next from cur into @var1, @var2 END close cur deallocate cur

http://www.jakobbeyer.de/mssql-execute-stored-procedures-in-a-loop

use sl declare @av0_style varchar(50) declare @av0_code varchar(15) declare @av0_gauge varchar(6) declare @av0_length varchar(10) declare @av0_ball_size varchar(10) declare @av0_part_color varchar(10) declare @av0_color_1 varchar(10) declare @av0_color_2 varchar(10) declare cur CURSOR LOCAL for select av0_style ,av0_code ,iif(av0_gauge != '',av0_gauge,NULL) AS av0_gauge ,iif(av0_length != '',av0_length,NULL) AS av0_length ,iif(av0_ball_size != '',av0_ball_size,NULL) AS av0_ball_size ,iif(av0_part_color != '',av0_part_color,NULL) AS av0_part_color ,iif(av0_color_1 != '',av0_color_1,NULL) AS av0_color_1 ,iif(av0_color_2 != '',av0_color_2,NULL) AS av0_color_2 from sl.dbo.av0_style AS s where s.av0_not_to_sale = 0 open cur fetch next from cur into @av0_style ,@av0_code ,@av0_gauge ,@av0_length ,@av0_ball_size ,@av0_part_color ,@av0_color_1 ,@av0_color_2 while @@FETCH_STATUS = 0 BEGIN --exec your_stored_procedure @var1, @var2 exec sl.dbo.GetPricePerPL @av0_style ,@av0_code ,@av0_gauge ,@av0_length ,@av0_ball_size ,@av0_part_color ,@av0_color_1 ,@av0_color_2 fetch next from cur into @av0_style ,@av0_code ,@av0_gauge ,@av0_length ,@av0_ball_size ,@av0_part_color ,@av0_color_1 ,@av0_color_2 END close cur deallocate cur 04.06.18

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024