InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 19:04:30 GMT20http://www.teradata.com/teradataforum/Topic11054-1-1.aspxuse varchar(255), and format the all the variables into one string passed to macro.Do you want to consturct a dynamic query? Store procedure can achieve the goal.Sat, 29 Mar 2008 09:45:44 GMTJianhttp://www.teradata.com/teradataforum/Topic11054-1-1.aspxwhat are the input_type and how-to-pass there?Thanks a ton.Wed, 26 Mar 2008 16:53:11 GMTgeorgexuhttp://www.teradata.com/teradataforum/Topic11054-1-1.aspxHi,How pass string like 'va', 'vb', 'vc' as one input?Say the code like thiscreate macro macro_name (input_name input_type) as ( select columns from table_x where table_x.column_y in (:inputname) group by 1,2 order by 1,2;)execute macro_name (how-to-pass);Wed, 26 Mar 2008 16:34:04 GMTgeorgexu