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: 278

Filed under:
|

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

Related posts about sql-server

Related posts about Microsoft