如何从创建的视图获得大于零？ [英] how to get more than zero from created view?

问题描述

hi
i创建了一个视图，我在一个sp中使用该视图来获取总和..但是我只想获得超过零..有些字段是0但我不希望它显示在我的报告中..那么任何人都可以建议我吗？

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
--@DateFrom datetime=null,
--@DateTo datetime=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

这个在我的sp中使用我想要多于零，所以我怎么能用这个呢？

为数量一些字段为空所以我不想要零值。我想要数量超过零值



谢谢

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

推荐答案

1。
如果获取空值，则使用isnull（）函数

例如

1. if getting null values then use isnull() function
e.g.

select isnull(fldnm,0) --this will give 0 if value is null

2.

如果不想要有qty = 0的行，那么使用where条件过滤记录



快乐编码！

：）

2.
if not want rows which having qty = 0 then filter records using where condition

Happy Coding!
:)

这篇关于如何从创建的视图获得大于零？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！