|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/27/2008 5:16:43 PM
Posts: 7,
Visits: 8
|
|
Hi,
How pass string like 'va', 'vb', 'vc' as one input?
Say the code like this
create 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);
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 3/27/2008 5:16:43 PM
Posts: 7,
Visits: 8
|
|
what are the input_type and how-to-pass there?
Thanks a ton.
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/4/2008 3:57:27 AM
Posts: 5,
Visits: 43
|
|
use 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.
|
|
|
|