InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 00:14:13 GMT20http://www.sqlservercentral.com/Forums/Topic1428470-392-1.aspxWow that was quick, and also solved the problem. Much appreciated!!!!!!Fri, 08 Mar 2013 03:14:46 GMTalex 64682http://www.sqlservercentral.com/Forums/Topic1428470-392-1.aspxMismatched brackets in the inner WHERE clause. Opened here and not closed (AccountNumber IN ('PARISH') This is syntactically valid[code="sql"]SELECT ToBeActionedBy , COUNT(ToBeActionedBy) AS ActionCountFROM ( SELECT ( SELECT TOP (1) ToBeActionedBy FROM dbo.PStatus AS PStatus_1 WHERE POID = dbo.POrder.ID ORDER BY ID DESC ) AS ToBeActionedBy FROM dbo.POrder INNER JOIN dbo.Address ON dbo.POrder.Company_Name = dbo.Address.Company_Name WHERE AccountNumber IN ('PARISH') AND dbo.Address.ID IN (11743, 11899) AND Complete = 0 ) AS AWHERE ToBeActionedBy IS NOT NULLGROUP BY ToBeActionedBy[/code]Fri, 08 Mar 2013 03:07:20 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1428470-392-1.aspxHi,I'm getting a syntax error on the following query designed to return the newest status from a one to many relationship based on a dynamic list of IDs passed via an IN statement. The inner query runs fine on its own, as does the entire query when the IN statement is removed. The error I keep getting is "Error in list of values in IN clause. Unable to parse query text." Any assistance with this would be greatly appreciated.SELECT ToBeActionedBy, COUNT(ToBeActionedBy) AS ActionCount FROM (SELECT (SELECT TOP (1) ToBeActionedBy FROM dbo.PStatus AS PStatus_1 WHERE (POID = dbo.POrder.ID) ORDER BY ID DESC) AS ToBeActionedBy FROM dbo.POrder INNER JOIN dbo.Address ON dbo.POrder.Company_Name = dbo.Address.Company_Name WHERE (AccountNumber IN ('PARISH') AND (dbo.Address.ID IN (11743,11899)) AND (Complete = 0)) AS A WHERE (ToBeActionedBy Is Not NULL) GROUP BY ToBeActionedByFri, 08 Mar 2013 02:59:31 GMTalex 64682