with uidlist as
(select a.orderuid,a.ordernumber,a.datein, count(a.datein) as counter
        from  ordertask a
        where (a.datein >= '2017-04-01') and (a.ordernumber > 10000 and a.ordernumber  10000 and ul.ordernumber



select a.orderuid,a.ordernumber
    ,convert(varchar,a.datein,101) as datein
    ,count(distinct a.datein) as num
From ordertask  a
where (a.datein >= '2017-04-01') and (a.ordernumber > 10000 and a.ordernumber



with uidlist as
(select s.uid,s.ordernumber, count(s.uid) as counter, cast(floor(cast(ot.DateIn as float)) as datetime) as ldate
              from service s join ordertask ot on ot.orderuid = s.uid
              where ot.datein > = '2017-04-01'
              group by s.uid,s.ordernumber, cast(floor(cast(ot.DateIn as float)) as datetime)),
uidfinal as (select count(uid) as counter, uid,ordernumber from uidlist group by uid,ordernumber having count(uid) = 1)
select ul.uid,ul.ordernumber
from uidfinal UL
order by ul.ordernumber;

select a.orderuid,a.ordernumber
    ,convert(varchar,a.datein,101) as datein
    ,count(distinct a.datein) as num
From ordertask  a
where (a.datein >= '2017-04-01') and (a.ordernumber > 10000 and a.ordernumber



with uidlist as
(select s.uid,s.ordernumber, count(s.uid) as counter, cast(floor(cast(ot.DateIn as float)) as datetime) as ldate
              from service s join ordertask ot on ot.orderuid = s.uid
              where ot.datein > = '2017-04-01'
              group by s.uid,s.ordernumber, cast(floor(cast(ot.DateIn as float)) as datetime)),
uidfinal as (select count(uid) as counter, uid,ordernumber from uidlist group by uid,ordernumber having count(uid) = 1)
select ul.uid,ul.ordernumber
from uidfinal UL
order by ul.ordernumber;

with uidlist as
(select s.uid,s.ordernumber, count(s.uid) as counter, cast(floor(cast(ot.DateIn as float)) as datetime) as ldate
              from service s join ordertask ot on ot.orderuid = s.uid
              where ot.datein > = '2017-04-01'
              group by s.uid,s.ordernumber, cast(floor(cast(ot.DateIn as float)) as datetime)),
uidfinal as (select count(uid) as counter, uid,ordernumber from uidlist group by uid,ordernumber having count(uid) = 1)
select ul.uid,ul.ordernumber
from uidfinal UL
order by ul.ordernumber;