Prev: Sql Server hang when deleting many records
Next: Temp table creation
From: Adrian Miller on 31 Jan 2010 08:49
Hi,

I have data for some days of a month. I'd like to have values for every day.
So I created an outer join against a table with holds a dataset for every
day of a year. The result shows null values for all days where I have no
values. Is there a way to have an other value then Null?

Thanks for any advice
Adrian

--
Adrian Miller


From: Uri Dimant on 31 Jan 2010 08:56
Hi
What values? Take a look at COALESCE function in the BOL




"Adrian Miller" <adrian.miller(a)hotmail.com> wrote in message
news:O1pjXwnoKHA.5696(a)TK2MSFTNGP04.phx.gbl...
> Hi,
>
> I have data for some days of a month. I'd like to have values for every
> day. So I created an outer join against a table with holds a dataset for
> every day of a year. The result shows null values for all days where I
> have no values. Is there a way to have an other value then Null?
>
> Thanks for any advice
> Adrian
>
> --
> Adrian Miller
>


From: Jay on 31 Jan 2010 12:22
If you have trouble understanding COALESCE, look up ISNULL.

"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:eMepD1noKHA.4648(a)TK2MSFTNGP06.phx.gbl...
> Hi
> What values? Take a look at COALESCE function in the BOL
>
>
>
>
> "Adrian Miller" <adrian.miller(a)hotmail.com> wrote in message
> news:O1pjXwnoKHA.5696(a)TK2MSFTNGP04.phx.gbl...
>> Hi,
>>
>> I have data for some days of a month. I'd like to have values for every
>> day. So I created an outer join against a table with holds a dataset for
>> every day of a year. The result shows null values for all days where I
>> have no values. Is there a way to have an other value then Null?
>>
>> Thanks for any advice
>> Adrian
>>
>> --
>> Adrian Miller
>>
>
>


 | 
Pages: 1
Prev: Sql Server hang when deleting many records
Next: Temp table creation