Can You see it, I cant see any problem.

-- =============================================
-- Create temp table
-- =============================================
CREATE TABLE #temp_table_get_work_requ (
LOG_PK int
LOG_REQUESTOR varchar(25)
LOG_REQ_PHONE int
LOG_CHAR_60_1 varchar(60)
LOG_CHAR_30_4 varchar(30)
LOG_CN_FK int
LOG_REQUEST varchar(2000)
LOG_STATUS varchar(45)
LOG_TYPE varchar(45)
LOG_FU_FK int
LOG_FB_PK int
LOG_LT_FK int
LOG_CREATE_DATE datetime
)

Garry Dawkins

You missed the ,

Each of the column definition clauses in your CREATE TABLE statement must be separated from each other by a comma...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com