I have created a DTS package in EM, in which I have been trying to optimize the SQL, by passing a variable. I get an "invalid pointer" error.
Does anyone know how to solve this?
Below is the script.
Any help would be greatly appreciated!
TB

declare @dc datetime
select @dc = dateadd(hour,-0,convert(char(10),getdate(),101))
select distinct (customer_key)
,email
,ship_first_name
,ship_last_name
,bill_first_name
,bill_last_name
,date_created
,date_modified
from customer
where date_created >= @dc
or date_modified >= @dc