Skip to Content
0
Former Member
Nov 19, 2012 at 07:37 AM

Percentage value in query

44 Views

hi

i need one column

SELECT T0.[DocNum], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[OpenQty] as 'Remaining Qty', (T1.[Quantity]-T1.[OpenQty]) as 'GRPO Qty' FROM [dbo].[OPOR] T0 INNER JOIN [dbo].[POR1] T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocNum] ='122000427'

For example

Purchase Qty GRPo qty Open Qty percentage

10000 7000 3000 ?

Percentage column need in above query