Forum Discussion
1 Reply
- diptipatel_fmNew Contributor
Hi, have you found a way to do this and use this variable in execution
I would like to execute the 2 set variable statements before executing the select * from viewname. This view internally uses VAR1 and VAR2 variables.
set VAR1 = ‘ABC’;
set VAR2 = ‘XYZ’;
Select * from dbname.schemaname.viewname ;
Is there anyway to set variables before executing select statement
Hi, have you found a way to do this and use this variable in execution