If is null then 0

Goran Bibic

8y1.4kSQL

Code working fine, just need to replace last line 6 to be:

IF IS null then 0

Some help

select x1.naziv, x1.Nabavka, x2.Prodaja, x1.Nabavka-x2.Prodaja as 'Stanje' from (select naziv, sum(kolicina) as Nabavka from
( select naziv as naziv, convert(float, kolicina) as kolicina from ulazni_racun_roba_roba union all select naziv as naziv, convert(float, kolicina) as kolicina from mp_ulazni_racun_ostalo_roba ) a
group by naziv) x1 left join ( select roba, sum(kolicina) as Prodaja from
( select roba, convert(float, kolicina) as kolicina from mp_racun_roba union all select roba, convert(float, kolicina) as kolicina from mp_faktura_roba ) b
group by roba ) x2 on x1.naziv = x2.roba
where x2.roba is not null

2 Replies

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

Vincent Maverick Durano8y ago
Accepted answer
I'm not sure if I follow you correctly, but if you are trying to select a field change change null to zero (0) then you do something like this:
SELECT ISNULL(YourField, 0 ) FROM YourTableName
Or you could use the Coalesce function like:
SELECT COALESCE(YourField, 0 ) FROM YourTableName
Jignesh Kumar8y ago
Your question is not clear. Could you please provide more detail on this.

If you want to use isnull in where clause then your condition is not null will not work. Then you have to change that cndition as well.