Change null values to '0' in a SQL pivot

Question

Change null values to '0' in a SQL pivot

Navigation

#1 by (1 votes)

2

I have something more or less like that

select * from( selcect ...)as pt
pivot(
asc(valor) for desc in 
(
[Deporte y cultura],[Despensa],[Destajo - sueldo],
 [Destajos], etc ...)
) as pvt

So far so good, but I get many results as null from that pivot , could someone tell me how to change them to zero?

sql sql-server null pivot

asked by E.Rawrdríguez.Ophanim 19.09.2018 в 18:59

source

1 answer

Show Loading when loading url in mplayer class Error entering RStudio, r or to the application

score 1 · Accepted Answer

You can use the ISNULL function like this:

select 
    ISNULL([Deporte y cultura], 0),
    ISNULL([Despensa], 0),
    ISNULL([Destajo - sueldo], 0),
    ISNULL([Destajos], 0) 
from( selcect ...)as pt
pivot(
    asc(valor) for desc in 
    (
        [Deporte y cultura],
        [Despensa],
        [Destajo - sueldo],
        [Destajos],
        etc ...
    )
) as pvt

The same question here .