which classes are used in asp.net
i am currently learning desktop/ console app programming with c#
i am curious to know when you write asp.net web pages do you still use the same classes
that you use in writing desktop apps
eg using system
using threading
etc
or is it that when you write asp.net web pages you are only allowed to use a certain category of classes.
thnx
Answers (2)
0
Hi Anoop,
Please try this SQL and let me know if it works for you
- declare @storeid bigint
- set @storeid=19
- select I.NameOfStores, I.ReferenceNo, SUM(Inwards.InwardQty) InwardQty, SUM(ISNULL(Issued.IssuedQty,0)) IssuedQty, SUM((ISNULL(Inwards.InwardQty,0)-ISNULL(Issued.IssuedQty,0)))as Balance
- from InventoryInwards as I
- LEFT JOIN
- (select ReferenceNo, nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty
- from InventoryInwards where StoreID=@storeid
- group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores
- and i.ReferenceNo=Inwards.ReferenceNo
-
- left JOIN
- (select nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty
- from InventoryIssued where StoreID=@storeid
- group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores
-
-
-
- where i.StoreID = @storeid
- group by I.NameOfStores, I.ReferenceNo, I.Unit
Accepted 0
Thanks Ankit... that was I missing out.