>Sir while using SQLSERVER 2012, I have these codes
>
>
>

>SELECT hrs,Max(reading)as reading
>FROM   bin1
>WHERE (CONVERT(VARCHAR(10), date, 103) = CONVERT(VARCHAR(10), GETDATE(), 103))
> AND (hrs IS NOT NULL) and updown=0 and tik is null
>group by hrs
>union
>SELECT hrs,max(reading)as reading
>FROM   bin1_empty
>WHERE (CONVERT(VARCHAR(10), date, 103) = CONVERT(VARCHAR(10), GETDATE(), 103))
> AND (hrs IS NOT NULL)
>group by hrs
>order by hrs
>

>
>It display following result
>
>
>But I want to get this result
>
>
>Hours from 0 to 23
>Missed hours must have value 0
>
>Please


I wrote about this problem here: http://www.tomorrowssolutionsllc.com/Articles/Including%20missing%20data.pdf

Tamar