Ground Control | Tier 1

Question

How to use Table variable into SQL query instead of sheetname

Forum|Forum|3 years ago
March 15, 2023
1 reply
149 views

Example is -- select * from [Sheet1$$];

I want to use Table Variable instead of Sheet1

I tried to using --- select * from [Table variable$$];

It is not working , can anyone suggest solution

Navigator | Tier 3

@ap442

Declare a new variable which will contains the sheet name and use it into the select query as below

HTH

Regards