RecursiveCTE

Pass the dates as parameters to the procedure: CREATE Proc [dbo].[DawgAlert_Completed_Order_Status] (@LoadDate datetime, @EndDate datetime, @billto varchar(100)) You may call the procedure with parameters: exec [dbo].[DawgAlert_Completed_Order_Status] '2019/01/01','2019/01/02','bill to address' For more info: https://docs.microsoft.com/en-us/sql/relational-databases/stored-procedures/create-a-stored-procedure?view=sql-server-ver15