Ah yes I forgot the @
Should have been like --
DECLARE @DelDateA datetime
DECLARE @DelDateB datetime
SET @DelDateA = '3/9/04'
SET @DelDateB = '3/15/04'
I get the following Server MSG
"'datetime' is not a recognized CURSOR option."
When I do this
USE Archive
DECLARE DelDateA datetime
DECLARE DelDateB datetime
SET DelDateA = '3/9/04'
SET DelDateB = '3/15/04'
SELECT O.OrderID
INTO #PF_CRFMLData
FROM PF_Orders O (NOLOCK)
WHERE O.DeliveryDate...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.