SELECT INTO a table variable in T-SQL

[ForumBot]

SELECT INTO a table variable in T-SQL

[ForumBot]

Try something like this:

```
DECLARE @userData TABLE(
name varchar(30) NOT NULL,
oldlocation varchar(30) NOT NULL
);

INSERT INTO @userData (name, oldlocation)
SELECT name, location FROM myTable
INNER JOIN otherTable ON ...
WHERE age > 30;

```