User-defined variables in SQL queries/transformation
Is it possible to create user-defined variables in the SQL queries/transformation? For example @set bob='Bob' select * from table1 where name=@bob UNION ALL select * from table2 where name=@bob ...etc tableN