How to avoid displaying rows with all zeros

Hi!

The table is as follows:

[Item Description] varchar,
Vasche datetime,
Imballo datetime,
Schiumatura datetime,
Alienato datetime,
[Prod_ Order No_] varchar

I run the following query:

DECLARE @tmpStartDate datetime
DECLARE @tmpEndDate datetime
SET @tmpStartDate = '2008-12-09'
SET @tmpEndDate = '2008-12-09'

SELECT [Item Description], [Prod_ Order No_],
SUM(CASE WHEN Vasche BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Vasche,
SUM(CASE WHEN Schiumatura BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN
1 ELSE 0 END) as Schiumatura,
SUM(CASE WHEN Imballo BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Imballo,
SUM(CASE WHEN Alienato BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Alienato
FROM [dbo].[Mondial Group s_r_l_$Production Cycle]
GROUP BY [Item Description], [Prod_ Order No_]

I need to modify it so that it will not display rows in cases when there're
all zeros in the produced row.

I was thinking on doing like bellow, but it won't work:
DECLARE @tmpStartDate datetime
DECLARE @tmpEndDate datetime
SET @tmpStartDate = '2008-12-09'
SET @tmpEndDate = '2008-12-09'

SELECT [Item Description], [Prod_ Order No_],
SUM(CASE WHEN Vasche BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Vasche,
SUM(CASE WHEN Schiumatura BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN
1 ELSE 0 END) as Schiumatura,
SUM(CASE WHEN Imballo BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Imballo,
SUM(CASE WHEN Alienato BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) as Alienato
FROM [dbo].[Mondial Group s_r_l_$Production Cycle]
HAVING
SUM(SUM(CASE WHEN Vasche BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) +
SUM(CASE WHEN Schiumatura BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN
1 ELSE 0 END) +
SUM(CASE WHEN Imballo BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END) +
SUM(CASE WHEN Alienato BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN 1
ELSE 0 END)) > 0
GROUP BY [Item Description], [Prod_ Order No_]

How can I obtain the desired result?

You can try something like

DECLARE @tmpStartDate datetime
DECLARE @tmpEndDate datetime
SET @tmpStartDate = '2008-12-09'
SET @tmpEndDate = '2008-12-09'

Select * from
(
SELECT [Item Description], [Prod_ Order No_],
SUM(CASE WHEN Vasche BETWEEN (@tmpStartDate) AND (@tmpEndDate+1) THEN
1
ELSE 0 END) as Vasche,
SUM(CASE WHEN Schiumatura BETWEEN (@tmpStartDate) AND (@tmpEndDate+1)
THEN
1 ELSE 0 END) as Schiumatura,
SUM(CASE WHEN Imballo BETWEEN (@tmpStartDate) AND (@tmpEndDate+1)
THEN 1
ELSE 0 END) as Imballo,
SUM(CASE WHEN Alienato BETWEEN (@tmpStartDate) AND (@tmpEndDate+1)
THEN 1
ELSE 0 END) as Alienato
FROM [dbo].[Mondial Group s_r_l_$Production Cycle]
GROUP BY [Item Description], [Prod_ Order No_]
)t

where
Vasche + Schiumatura + Imballo + Alienato <> 0