Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I am trying to create a SQL stored procedure with a date range parameter to be used in a Sage Intelligence report. One old procedure uses the following:
CREATE PROCEDURE [dbo].[TJWEEK]
-- Add the parameters for the stored procedure here
@S_Date…