asked
loop through stored procedures with input and output parameters
Hi, I am looking for a script for look through stored procedures with input and output parameters. I use the follow script to manually input 'processdate' and get the 'date id' as output. Everytime, I just change the @ProcessDate to process. Does anyone have a better way to write a loop to run this SP and set the @ProcessDate from '2017-04-30' to '2017-08-31'? Appreciate it!! Delare @ProcessDate datetime, @Date_ID int select @ProcessDate = '2017-04-29' exec casp_Dim_Date @ProcessDate, @Date_ID output
A While loop will be the way to go DECLARE @ProcessDate DATE = '2017-04-30', @Date_ID int WHILE @ProcessDate
17 People are following this question.
