I have a linked server set up and I can query the tables
just fine. Here is an example of my syntax
(PART_NO,CONTRACT) AS DEMAND_SHOP_ORDERS
the name of the procedure is 'SHOP_API' and the name of
the function within the procedure is Get_QTY_DEMAND.
I am trying to call this function to retrieve the value
that this function gives.
I get an error saying the I have too many prefixes.