microsoft sql server management studio Incorrect syntax near '|'
Posted
by
user3679099
on Stack Overflow
See other posts from Stack Overflow
or by user3679099
Published on 2014-05-27T09:22:17Z
Indexed on
2014/05/27
9:24 UTC
Read the original article
Hit count: 273
sql-server
|Microsoft
SELECT IPD.Task_grp "Task Group", TASK.STARTW "Starting Area", TASK.ENDW "Destination Area", IPD.Nxt_Work_Grp,IPD.Nxt_Work_Area "Drop Area", IPD.Prty "Priority", IPD.Stat_Code "Status" FROM int_path_defn IPD, (SELECT start_curr_work_grp || start_curr_work_area StartW, start_dest_work_grp ||start_dest_work_area EndW FROM task_hdr WHERE task_id='332800') TASK WHERE IPD.CURR_WORK_GRP || IPD.Curr_Work_Area=TASK.StartW AND IPD.Dest_Work_Grp || IPD.Dest_Work_Area=TASK.ENDW
I am getting Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '|'.
Please help what could be the wrong. same query executed successfully in oracle sql developer
© Stack Overflow or respective owner