<p>If this is possible, please provide a sample query or two so I can see how it would work.  Both tables will be in the same database.</p>

<p>Thanks!</p>

Pseudo code:
```
```
insert into <target-table>
( <column-list> )
select <columns>
  from <source-table>
```
```