begin

if object_id ('t.1' , 'U') is not null
drop table t.1;

select 
  CGR.gr_id  as client_id,
  CO.order_pk  as check_id,
  NORD.ndk as ndk_number,
  NORD.ndk_type  as ndk_type,
  L.location_id as shop_code,
  NORD.delivery_date_fact as fact_delivery_date,
  NORD.order_delivery_fk   as delivery_type,
  getdate() as date_load,
  @sessionid as session_id
into t.1
from t.2 NORD
  inner join t.3 on NORD.NDK = NDK.ndk_id
  inner join
  (select CLIENT_PK, ORDER_PK 
	 from  t.4
		) CO 	on CO.ORDER_PK = NORD.ORDER_PK
  inner join
	(select t.5 
T)   CGR		on CGR.CLIENT_PK = CO.CLIENT_PK
  left join t.6 L 	on L.LOCATION_PK = NORD.LOCATION_id and getdate() between l.valid_from and l.valid_to
where @sessionid > NORD.session_id

inner join t.3 NDK on NORD.NDK = NDK.ndk_id

select
 grndk.gr_id as client_id,
 NC.check_pk as check_id,
 --NC.createddatetime as payment_date,
 RL.location_id as shop_code,
 RL.ref_city_name as shop_city,
 NC.ndk as ndk_number,
 NC.ndk_cardtype as ndk_type,
 NC.transdate as payment_date,
 NC.transtime as payment_time,
 '0' as analysis_phone_flg,
 getdate() as date_load,
 @sessionid as session_id
 into t.1 
 from t.2 NC
 join t.3 ndk on ndk.ndk_id = nc.ndk
 join (
	select NC.gr_id gr_id, CCN.ndk_pk ndk_pk
	from t.4 NC
	join t.5 CCN on NC.client_pk = CCN.client_pk
	group by NC.gr_id, CCN.ndk_pk)  grndk             on grndk.ndk_pk = nc.ndk_fk
left join t.6 RL on RL.location_pk = NC.location_fk and getdate() between RL.valid_from and RL.valid_to
where @sessionid > NC.session_id