pcsoft.us.windevCopyright 2026, PC SOFT12 Dec 2015 15:52:00 Z11 Dec 2015 19:52:00 ZHere is a question for SQL experts in this group. After much googling, I came up with a SQL Server query that gives the data I need. I have to sum multiple rows in one table for only the most recent posting date. So I tried to Reverse Engineer the Query and get the following: https://www.dropbox.com/s/gnoxhuon38pbq0m/SQL_InvValue.png?dl=0 I need to add selection parameters so I created another query that uses this query and a manually entered join linking on ID. However, that does not work so far. It runs the internal query and then does not do the join with or without parameters specified so the results window just goes away. So the questions are: How can I redo the SQL code so that it will reverse engineer? Or how can I add parameters to the SQL code for other fields in the PART table? Or how can I do the equivalent of the MAX(PostingDate) to get the most recent Inventory_Balance entries for a Part_ID in the query editor and then sum the fields so I end up with only one row per Part_ID? Any suggestions would be greatly appreciated.?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55458/read.awp12 Dec 2015 15:52:00 ZHi Paulo, It appears you are absolutely correct. I have to build my WHERE clause in the string instead of using parameters, b…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55458/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55458/read.awpReverse Engineering of an SQL Server query errors.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55457/read.awp12 Dec 2015 12:43:00 ZHi Jeff, the helpfile noted at Sub-query: Limits: •The ORDER BY statement is not allowed in the sub-queries. •The sub-qu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55457/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55457/read.awpReverse Engineering of an SQL Server query errors.guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55454/read.awp11 Dec 2015 20:13:00 ZIn some situations, normally with several sub-selects or specific db sintax or commands you can't use the query editor. In this…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55454/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/55453-reverse-engineering-sql-server-query-errors-55454/read.awpReverse Engineering of an SQL Server query errors.