with cte(extcode) as
(select '90031'
union
select '90011'
union
select '90139'
union
select '90025'
union 
select '90150'
)
select pp.extcode,cast(prday as DATE),SUM(weight),COUNT(weight) 
from proc_packs pp with (nolock)
join cte c on pp.extcode=c.extcode
where 1=1
and site=1
and station=109
and rtype=1

and prday between '20141101' and GETDATE() -- Plan1



--and prday between '20151101' and GETDATE() -- Plan2
--and prday between '20151120' and GETDATE() -- Plan3



group by prday,pp.extcode
order by extcode,prday

cкачать