That worked well
Thanks
Jim
>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