For a simple example, I have the following column in a table, Table_A:
Var123
ABC
EFG
KLM
XYZ
Is there a way to insert these into a macro variable that ends up looking like this? 'ABC','EFG','KLM','XYZ' Reason: I am running a program through a SQL pass through where I can't join to other tables in Work, like Table_A. I can still call macro variables inside of the SQL pass through, so I thought inserting that column into a macro variable would be a clever solution. The only thing I can think of is running the program through a loop for each unique result in that column "Var123", but in my actual data there are a few thousand rows, so I'm not sure that's efficient. If something better exists, I would love to hear about it! "select distinct trim(Var123) into :MCVR from work.Table_A;" works in and of itself, but it seems to just put the first row. I can do a count distinct into a macro variable, and then use that count variable to insert into :MCVR1 - :MCVR&COUNT but that would just leave me with the option of looping the variable &COUNT many times in the SQL passthrough program, right? The end goal is, within the SQL passthrough program, to use a where expression like, "where tablevariable in (&MCVR)"
... View more