Why will this not work?

[DarrinT]

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 BETWEEN DelDateA AND DelDateB

 

[DarrinT]

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'