Is it possible to define variables in List Manager?

HI Vicky,

Good day.

I think you can use function and view to achieve what you try to do.

you put the DECLARE part in a function and hide the logic into a view.

create function dbo.myfunction

return datetime

as

begin

DECLARE @the_date datetime
SET @the_date = getdate()

return @the_date

end

-----==== this part can be put in a view

SELECT DISTINCT a.customer_no
    FROM T_CUSTOMER a
        WHERE  a.create_dt <= dbo.myfunction()

-----=====

 and  a.inactive = 1
        AND a.cust_type = 1 

have fun

Ben

Hello Ben, Brian, and Steven,
Your advice is very helpful
Thank you very much!
Vicky

Hello Ben, Brian, and Steven,
Your advice is very helpful
Thank you very much!
Vicky