// description of your code here

update orders set statusid = 1,currentqueueid = 1, ntuser = null,checkedout = null where orderid = 19111067

// description of your code here

select
        convert(varchar(6),n.notedate) as [date],count(*) as cnt
into
        #temp
from
        orders o inner join 
        orderdetail od on o.orderid = od.orderid inner join
        ordernotes n on o.orderid = n.orderid
where
        od.jurisdictionid = 3152 and
        od.serviceid in (3,4,12,13,15,18) and
        (n.noteid = 129 and n.notedate > '4/1/2006 12:01 AM')
group by
        convert(varchar(6),n.notedate)
order by
        convert(varchar(6),n.notedate)

select * from #temp
compute sum(cnt)
drop table #temp