01-26-2021 10:00 AM
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
04-27-2023 08:12 AM
Hi, have you found a way to do this and use this variable in execution