I am trying to insert data into a table based on a variable, but SQL Server is not recognising the table in the variable.
INSERT INTO @tableNameH
SELECT * FROM @tableName;
It this not supported in T-SQL?
I am trying to insert data into a table based on a variable, but SQL Server is not recognising the table in the variable.
INSERT INTO @tableNameH
SELECT * FROM @tableName;
It this not supported in T-SQL?