Dear Experts,
How can I use datetime value in SQL 2000 Stored Procedure EXEC(@sqlStatement)?
I have this Error Message :
Running [dbo].[InventoryTest] ( @whereClause = ProjectNo=N'7812', @startdate = 01/01/10, @enddate = 09/09/10 ).
Syntax error converting datetime from character string.
No rows affected.
(0 row(s) returned)
@RETURN_VALUE =
Finished running [dbo].[InventoryTest].
from Stored Procedure Codes:
ALTER PROCEDURE dbo.InventoryTest
(
@whereClause nvarchar(4000),
@startdate datetime,
@enddate datetime
)
AS
DECLARE @sqlStatement nvarchar(4000)
SET @sqlStatement = '
SELECT GroupID, ProjectNo, ProductID, ShipDate, BO, USPS, Transfer, FF, Allocated, DM, SM, UPS, Process, Mailed, Received, Adjust, Spoilage
FROM (SELECT GroupID, [Project #] AS ProjectNo, [Product #] AS ProductID, ShipDate, BO, USPS, Transfer, FF, Allocated, DM, SM, UPS, Process, Mailed,
0 AS Received, 0 AS Adjust, 0 AS Spoilage
FROM vw_OrderDetails) AS Q2
WHERE (ShipDate < ' + @startdate + ')'
EXEC(@sqlStatement)
RETURN
Open in new window