โ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