Getting syntax error when trying to use OPENQUERY
I am trying to do a query via ODBC to our ERP database. The documentation guide suggests that we use OPENQUERY to send the query. Here is my example query SELECT Q.Part_No, Q.[Description], Q.Part_Type FROM OPENQUERY ( LINKEDSERVER, ' SELECT P.Part_No, P.[Description], P.Part_Type FROM LINKEDSERVER...Part_V_Part AS P WHE...