Hi everyone,
I am trying to select a subset of the results from the Master Inventory table (OITM) using the new SQL Server 2005 function ROW_NUMBER() through DI Server web service.
My query is:
SELECT Row, ItemName, ItemCode FROM (SELECT ROW_NUMBER() OVER (ORDER BY ItemCode ASC) AS Row, ItemName, ItemCode FROM OITM) AS lrn WHERE Row = 1
This works great when querying directly in SQL Server (for testing) and through the Query Generator in SAP SB1 but when I attempt to run this through DoQuery via the DI Server web service it is giving me 'General Error' with no more specifics.
Has anybody had any luck with this, or have a good way to successfully page results? Thanks for any help.
Message was edited by:
Cy Scott