SOLVED

Setting Date in Stored Procedure

Steel Contributor

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)

1 Reply
best response confirmed by Tim Hunter (Steel Contributor)
Solution

@Tim Hunter 

DECLARE @LoadDate DATE='2019-11-05'

1 best response

Accepted Solutions
best response confirmed by Tim Hunter (Steel Contributor)
Solution

@Tim Hunter 

DECLARE @LoadDate DATE='2019-11-05'

View solution in original post