Skip to Content
0
Former Member
Feb 22, 2011 at 02:07 PM

Select last document part 2

31 Views

Hi

I recently had some assistance that gave me the following query

SELECT Top 1 T1.ItemCode, T1.Dscription, T0.DocDate,T1.Quantity,

T0.DocNum, T0.CardCode, T0.CardName

FROM dbo.OPOR T0

INNER JOIN dbo.POR1 T1 ON T0.DocEntry = T1.DocEntry

WHERE (T1.ItemCode ='[%0]' OR T1.Dscription = '[%1]'

Order By T0.DocDate DESC

However I would like to amend this so I could enter 4 or 5 different ItemCode or Dscription in the Selection Criteria, and it return the latest documents for each one.

Many thanks.

A