Question: I want to accomplish something of the following:

```
Select DISTINCT(tableA.column) INTO tableB.column FROM tableA

```

The goal would be to select a distinct data set and then insert that data into a specific column of a new table.

Answer: 
You're pretty much there.

```
SELECT DISTINCT column INTO tableB FROM tableA

```

It's going to insert into whatever column(s) are specified in the select list, so you would need to alias your select values if you need to insert into columns of `tableB` that aren't in `tableA`.

[SELECT INTO](http://www.w3schools.com/Sql/sql_select_into.asp)
Try the following...

```
INSERT INTO tableB (column)
Select DISTINCT(tableA.column)
FROM tableA

```