declare @d varchar(19), @attribut varchar(10)
set @d = SWITCHOFFSET(?, '-03:00'); set @attribut = ?
select COUNT(i.serialkey) as oper
, case when i.SOURCETYPE = 'ntrPickDetailUpdate' then 'Отгрузка' 
when i.SOURCETYPE = 'ntrReceiptDetailAdd' then 'Приёмка' 
when i.SOURCETYPE = 'ntrAdjustmentDetailUnreceive' then 'Отмена приёмки'
when i.SOURCETYPE = 'PICKING' then 'Отбор'
when i.SOURCETYPE in ('NSPRFPA02', 'RFPUTAWAYTASK') then 'Размещение' 
when i.SOURCETYPE in ('NSPRFRL01', 'RFMOVETASK', 'RFREPLENISHMENTTASKFINAL') then 'Перемещение'
when i.SOURCETYPE = 'nspRFTRP01' then 'Пополнение' 
when i.SOURCETYPE = 'TaskReasonMove' then 'Перемещение в LOST' 
when i.SOURCETYPE = 'RFMoveFlowThrough' then 'Перемещение отобр. товара'
when i.SOURCETYPE = 'Console Move' then 'Перемещение через рабочую станцию'
else i.SOURCETYPE end as descr 
into #t1
from wmwhse1.ITRN I
inner join scprdd1.dbo.e_sso_user u on i.EDITWHO = u.sso_user_name
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where convert (nvarchar(19), i.EDITDATE, 120) between @d and (? +' '+'20:59:59') 
and (i.EDITWHO like 'tv%' or i.EDITWHO like 'stvp%' or i.EDITWHO like 'mst%' or i.editwho in ('rsa', 'abn', 'cai')) 
and i.TOLOC <> 'INTRANSIT' 
and not (FROMLOC = 'pickto' and TOLOC = 'pickto' and FROMID <> TOID) and i.SOURCETYPE <> 'SHORTPICK'
and i.editwho not like 'tvo%' and ua.sso_user_attribute_value like @attribut  
group by i.SOURCETYPE

UNION

select COUNT(i.serialkey) as oper
, case
when i.SOURCETYPE = 'ntrPickDetailUpdate' then 'Отгрузка' 
when i.SOURCETYPE = 'ntrReceiptDetailAdd' then 'Приёмка' 
when i.SOURCETYPE = 'PICKING' then 'Переупаковка'
else i.SOURCETYPE end as descr
from wmwhse1.ITRN I
inner join scprdd1.dbo.e_sso_user u on i.EDITWHO = u.sso_user_name
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where convert (nvarchar(19), i.EDITDATE, 120) between @d and (? +' '+'20:59:59') and (i.EDITWHO like 'tv%' or i.EDITWHO like 'stvp%' or i.EDITWHO like 'mst%' or i.editwho in ('rsa', 'abn', 'cai')) 
and i.TOLOC <> 'INTRANSIT' 
and (FROMLOC = 'pickto' and TOLOC = 'pickto' and FROMID <> TOID)
and i.editwho not like 'tvo%' and ua.sso_user_attribute_value like @attribut
group by i.SOURCETYPE

UNION

select COUNT(rh.SERIALKEY) as qty_task, 'Приёмка ТМ' as descr
from wmwhse1.RECEIPTDETAILSTATUSHISTORY rh (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = rh.ADDWHO
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where RECEIPTKEY in (select distinct RECEIPTKEY 
from wmwhse1.RECEIPTDETAILSTATUSHISTORY 
where STATUS in ('-1'))
and status = '0' and convert(nvarchar(19), rh.ADDDATE, 120)  between @d and ?+' '+'20:59:59' and ua.sso_user_attribute_value like @attribut

UNION

select  COUNT(*) as pick_QTY, 'Отбор из хранения ТВР' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where EXTERNORDERKEY like 'TBP%' and convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-HRANST', 'Z-BARELL', 'Z-HISTORAG', 'Z-HRANSTHI', 'HR-OIL', 'Z-HRANC', 'CROSS'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_MEZONIN, 'Отбор из Мезонина' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where /*EXTERNORDERKEY like 'TBP%' and*/ convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('M-BOX', 'Z-M OUN', '	Z-M1', 'Z-M2', 'Z-MKOMP', 'Z-OTBXDMEL'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_AO_hran, 'Отбор из хранения А(О)' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where EXTERNORDERKEY like 'A%' and convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-HRANST', 'Z-BARELL', 'Z-HISTORAG', 'Z-HRANSTHI', 'HR-OIL', 'Z-HRANC', 'CROSS'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_TBP, 'Отбор ТВР' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where EXTERNORDERKEY like 'TBP%' and convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-OTBORST', 'Z-TEMP', 'Z-OTBSTHI', 'Z-OIL', 'OTB-MEDIUM', 'Z-KOMP', 'Z-CROSS', 'CROSSNAPL', 'Z-STEKLA'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_AO, 'Отбор А(О)' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where EXTERNORDERKEY like 'A%' and convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-OTBORST', 'Z-TEMP', 'Z-OTBSTHI', 'Z-OIL', 'OTB-MEDIUM', 'Z-KOMP', 'Z-CROSS', 'CROSSNAPL', 'Z-STEKLA'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_obresh, 'Отбор обрешёток' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-SHTAB1', 'Z-MEGA', 'Z-SHTAB5', 'Z-SHTAB4', 'Z-SHTAB3', 'Z-SHTAB2'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_bumper, 'Отбор бамперов, Кладовка' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-KLAD', 'Z-KLAD-B', 'Z-HROTBAMP', 'Z-HRANSTKR'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut
UNION
select  COUNT(*) as pick_glush, 'Отбор глушителей' as pick_type
from wmwhse1.TASKDETAIL td (nolock)
inner join scprdd1.dbo.e_sso_user u on u.sso_user_name = td.USERKEY
left join scprdd1.dbo.e_sso_user_attribute ua on u.e_sso_user_id=ua.sso_user_id
where td.ORDERKEY in (select ORDERKEY from wmwhse1.ORDERS where convert (nvarchar(19), EDITDATE, 120) between @d and (? +' '+'20:59:59'))
and td.FROMLOC in (select loc from wmwhse1.LOC where PUTAWAYZONE in ('Z-GLUSH'))
and (td.USERKEY like 'tv%' or td.USERKEY like 'stvp%' or td.USERKEY like 'mst%' or td.USERKEY in ('rsa', 'abn', 'cai')) and td.USERKEY not like 'tvo%' and ua.sso_user_attribute_value like @attribut

select SUM(CAST((case when descr = 'Приёмка ТМ' then oper/1.923 when descr = 'Переупаковка' then oper/2.308 when descr like 'Отбор%' then oper
		when descr = 'Перемещение' then oper/0.962 when descr = 'Размещение' then oper/0.846 when descr = 'Приёмка' then oper/1.154
		when descr = 'Перемещение отобр. товара' then oper/2.307
		else oper end) as decimal(8,2)))  as oper_ipnv
, descr, SUM(oper) as oper
from #t1
group by descr

drop table #t1