Try w/o parenthesis.
INSERT INTO studemo SELECT * FROM cisstudemo
>Hello group,
>
>I would like to add all of the rows from cisstudemo a temporary table into the permanent table studemo. This was an example INSERT INTO studemo ( SELECT * FROM cisstudemo) that gives me an error
>Server: Msg 156, Level 15, State 1, Line 1
>Incorrect syntax near the keyword 'SELECT'.
>Server: Msg 170, Level 15, State 1, Line 1
>Line 1: Incorrect syntax near ')'.
>How do I best accomplish my goal?
>
>Jim
--sb--