@CategoryID select (SELECT dbo.udf_GetQtyOnHand(invID)) QtyOnHand,tblInventoryMaster.*,tblUnitMaster.*,tblNonStockDetails.* from tblNonStockDetails left outer join tblInventoryMaster on tblNonStockDetails.nsdInventoryID=tblInventoryMaster.invID left outer join tblUnitMaster on tblInventoryMaster.invBaseUnitID=tblUnitMaster.unID where tblInventoryMaster.invCategoryID in (select * from tblInventoryCategory where invcatNodeID=@CategoryID order by ISNULL (NULLIF(invcatParentNodeID,0),invcatNodeID),invcatParentNodeID,invcatNodeID) and tblNonStockDetails.nsdDocType='MR1' end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)