Query updation

[Former Member]

hi all,

SELECT T0.[Quantity] + (T0.[Quantity]/10), T0.[ItemCode] FROM RDR1 T0 INNER JOIN ORDR T1 ON T0.DocEntry = T1.DocEntry WHERE T1.[DocNum] =[%0]

This query select particular sales order and then item is selected one by one in this order, after every selection we have to again run this query but my client want to select item by pressing ctrl button so that item can be selected at one time.so please provide me updated query.

thanks and regards

rahul

[reno1 · Accepted solution]

Hi Rahul,

You can use between condition i where clause so as to select a range of items.

Again here you may not be able to select in random the items required, they will be in sequential order only.

SELECT T0.Quantity + (T0.Quantity/10), T0.ItemCode FROM RDR1 T0 INNER JOIN ORDR T1 ON T0.DocEntry = T1.DocEntry WHERE T1.DocNum  between [%0] and [%1]

Hope this solves ur issue!!!

Regards

Reno

[Former Member]

One way you can try is in this way:

SELECT T0.Quantity * 1.1 AS 'QTY', T0.ItemCode

FROM DBO.RDR1 T0 INNER JOIN DBO.ORDR T1 ON T0.DocEntry = T1.DocEntry

WHERE T1.DocNum LIKE '[%0\]%'

It is all depending on the pattern you try to query. If no pattern, you have to check one by one.

Thanks,

Gordon