Msg 102, Level 15, State 1, Line 1 Incorrect syntax near ' '.
- by sajad
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