hi
i am using query as below
select * from tbaadxx.gaxx where acct_opn_date='&dt' and acid='AA12'
union all
select * from tbaadxx.gaxx where acct_opn_date='&dt' and acid='AA12'
for result I have to replace variable '&dt' twice as I have declared it twice the value is same .
any work around to replace &dt with single replace ?
I have to use many union all .. say moe than 20
Please help