hi
i created view and am using that view in one sp to get sum..but for that i want to get only more than zero..some fields is 0 but i dont want that to display in my report..so can any one suggest me?
@CategoryID int=null
AS BEGIN
if @CategoryID is not null
Begin
SELECT
(SELECT dbo.udf_GetQty(invID)) Qty,
(SELECT dbo.udf_GetAverageCost(invID)) AvgCost,
(SELECT dbo.udf_GetTotalStockValue(invID)) TotalStockValue,
tblStockDetails.*,tblStockHeader.*,tblUnitMaster.*,tblInventoryMaster.*
FROM
tblStockDetails
INNER JOIN
tblStockHeader ON tblStockDetails.sdDID = tblStockHeader.shDID AND
tblStockDetails.sdDocType = tblStockHeader.shDocType
left outer join tblUnitMaster on tblStockDetails.sdUnitID=tblUnitMaster.unID
left outer join tblInventoryMaster on tblStockDetails.sdInventoryID=tblInventoryMaster.invID
WHERE
tblStockHeader.shIsDelete=0
ORDER BY tblStockHeader.shDocumentDateTime
this am using in my sp so Qty i want More than zero so how can i use this?
for Qty some fields are null so i dont want that zero values.i want more than zero values for Qty
thank you