Is it possible to define variables in List Manager?

I'm afraid multiple statements are prohibited in the SQL query editor; this is done as part of our effort to prevent "SQL injection attacks", which would allow malicious users to enter statements that might alter or delete data or objects from the database.

Hello Steven,

Thank you very much for your reply.

I tried to eleminate spaces in my query, but still I am running out of space in this Manual Edit text box..
May I know how to increase the field Text Limit
Thank you very much in advance!

I'm afraid it's not possible for you to increase the text limit in that edit box; it's hard-coded to allow a maximum of 1,020 characters.

Hello Steven,

Thank you very much for your reply.

I just found that the criteria is in table T_LIST and the criteria is defined as Varchar (4000). Is it ok for me just change the varchar(4000) to varchar(max)?

Thank you and good night ^_^

No, we do not support changes to production tables that you have not created yourself because these changes may be reversed in future database update scripts. Further, that won't affect the length of the query you can enter in List Manager because the limit is set in the client application, and I cannot guarantee that entering your query directly into that column by another means will work properly.

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