Building an Intranet with ASP.NET

Question

Hi, My work has given me the task with building them an intranet. I'm pretty new to ASP.NET and .NET in general, so I was wondering if anyone knew of technologies or any books I should look at that might help me along with this project. I would prefer using C# if possible. Thanks for any help, Drew

Answer 1

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

Answer 2

Thanks Ankit... that was I missing out.