Help for this page

Select Code to Download

Select or download this

select 
    distinct today.customer
...
and yesterday.date     = getdate() -1
and yesterday.billing  = 0
and today.billing     != 0