I'm getting a message: invalid syntax near ")" and
can't figure it out.

DECLARE @temp1 table (
    korg_id char(20),
    Mentor_path int,
    Proceed_Review int,
    Snippet_number int,
    Under_reviewer int,
    Incoming int,
    Assigned_to_Client int,
    Rejected_First int,
    Aw_Conditions int,
    )

    insert into @temp1

The trailing comma.

This:
Aw_Conditions int,

Should be this:
Aw_Conditions int



Woody Z
http://www.learntoprogramnow.com
How to use a forum to help solve problems