dates
1 TopicSetting Date in Stored Procedure
I have a stored procedure that looks for orders within a date period. How do I set the date within the stored procedure? Here is my code. Thank you!! USE [TMWSUITE] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE Proc [dbo].[DawgAlert_Completed_Order_Status] AS SELECT orderheader.ord_number ,orderheader.ord_billto ,orderheader.ord_status ,orderheader.ord_origin_earliestdate ,orderheader.ord_origin_latestdate ,orderheader.ord_dest_earliestdate ,orderheader.ord_dest_latestdate ,orderheader.ord_trailer ,orderheader.ord_totalmiles ,stops.stp_city ,stops.stp_state ,stops.stp_schdtearliest ,stops.stp_schdtlatest ,stops.stp_status ,stops.stp_number ,stops.stp_sequence ,stops.stp_arrivaldate ,stops.stp_departuredate ,stops.cmd_code ,stops.cmp_name ,orderheader.ord_refnum ,orderheader.ord_description ,trailerprofile.trl_number ,trailerprofile.trl_type3 ,city.cty_nmstct ,orderheader.ord_completiondate FROM orderheader INNER JOIN stops ON orderheader.ord_hdrnumber = stops.ord_hdrnumber LEFT OUTER JOIN company ON orderheader.ord_company = company.cmp_id INNER JOIN trailerprofile ON orderheader.ord_trailer = trailerprofile.trl_number INNER JOIN city ON stops.stp_city = city.cty_code WHERE stops.stp_departure_status = 'DNE' AND orderheader.ord_status='CMP' AND (orderheader.ord_completiondate >= @LoadDate) AND (orderheader.ord_completiondate <= @EndDate) AND (orderheader.ord_billto = @billto)Solved1.8KViews0likes1Comment
