Sum of cast statement

Abdu Rafeeq

14y3.2k

i selects a sum of value between two dates, I know
in that date there is no value in the table
,But one blank row select in this case

my query is

sum(cast( AcidingIssueTestRtn.testPiece as decimal(18,3))) as Weight

How to avoid?
I not need blank row

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sushta Guthnar14y ago
Noone has been asking type database of you. Oracles has different fnctn calling itself NVL(field, value) useing SQL Server it is calling itself isnull(value,value)

This is those question rupees I am laughing incredibly

Snortling outsides,

Shusta
0
Prabhu Raja14y ago
Hi,

You can Also Use IS NULL or IS NOT NULL To Select Rows from Table.

SELECT
sum(cast( AcidingIssueTestRtn.testPiece as decimal(18,3))) as Weight

FROM AcidingIssueTestRtn

where AcidingIssueTestRtn.testPiece IS NOT NULL

0
Jignesh Trivedi14y ago
Hi,

As per my knowledge,
sum is aggregate functions in sql and aggregate functions always return as value either null or any value.

so cannot remove that row but
try following solution.

select * from ( select isnull(sum(cast( AcidingIssueTestRtn.testPiece as decimal(18,3))),0) as Weight
from table
)A
where A.Weight is not null

hope this help..
0
Pravin Ghadge14y ago
Try Aarti Solution if u want to show 0 value in place of blank row.

But if u don't want 0 or blank row then it can't be possible because.
Sum is Aggregate function. which will give value or null/blank(if no record is there).
0
Aarti14y ago

Hi,
Try with below script

isnull(sum(cast( AcidingIssueTestRtn.testPiece as decimal(18,3))),0) as Weight
0