Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.
Posted
by sajad
on Stack Overflow
See other posts from Stack Overflow
or by sajad
Published on 2010-04-30T11:55:04Z
Indexed on
2010/04/30
11:57 UTC
Read the original article
Hit count: 196
i am trying to query from a temp table,and i keep getting the message
Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.
can somebody tell me wats the problem..is it due to convert.. plz help
The query is
select compid,2, convert(datetime, '01/01/' + CONVERT(char(4),cal_yr) ,101) ,0, Update_dt, th1, th2, th3_pc , Update_id, Update_dt,1 from #tmp_CTF
© Stack Overflow or respective owner
