You must Sign In to post a response.

24 Sep 2016 00:00

Joined:	09/05/2012
Level:	Silver
Points:	158

Points:	5

How to display orderno with its quantity

I HAVE order table
OrdersNo RevisionNo Quantity
O-1 0 2
O-1 1 3
O-2 0 5

The above data i need to get at PurchaseOrder screeN like below
O-1 1 3
O-2 0 5

AND IF WE CREATE PURCHASE ORDER OF ORDERNO O-1 FOR 1 QAUNTITY
THEN DATA SHOULD DISPLAY LIKE BELOW
O-1 1 2
O-2 0 5

#767950

24 Sep 2016 05:05

Joined:	09/05/2012
Level:	Silver
Points:	158

Points:	1

Select distinct a.orderno (a.qty-isnull(sum(b.qty),0)) from orders as a left outer join purchase as b on a.orderno=b.orderno group by a.orderno, a.qty

#767954

26 Sep 2016 02:33

Joined:	03/05/2013
Level:	Gold
Points:	15822

Points:	2

Hi,

Use below query


select OrderNo, Max(RevisionNo), Quantity
from  purchaseorder
where yourconditions
Group By OrderNo, Quantity

Hope this helps you..

--------------------------------------------------------------------------------
Give respect to your work, Instead of trying to impress your boss.

N@veen
Blog : http://naveens-dotnet.blogspot.in/

Submit New Thread

Return to Return to Discussion Forum

How to display orderno with its quantity

About dotnetspider.com

Quick Links

General

Services