use [DB_DMS]

select * from DMS.R_Companies_Dealers where companycode = 'D10381' and divisioncode = '201'

select * from DMS.M_SpecialPrices where companycode = 'D10381'
select * from DMS.M_DealerPrices where companycode = 'D10381'

select * from [tjtoky-sq14v\ism].sysif.sysif.I058_病院特価マスタ where 特価専用代理店コード = 'D10381'
select * from [tjtoky-sq14v\ism].sysif.sysif.I058_代理店特価マスタ where 特価専用代理店コード = 'D10381'



delete from [tjtoky-sq14v\ism].sysif.sysif.I058_病院特価マスタ
delete from [tjtoky-sq14v\ism].sysif.sysif.I058_代理店特価マスタ


select * from DMS.W_DeleteSpecialPrices
select * from DMS.W_DeleteDealerPrices


update DMS.M_SpecialPrices 
set SelloutSystemTransferFlag = '1'
where companycode = 'D10381'

update DMS.M_DealerPrices 
set SelloutSystemTransferFlag = '1'
where companycode = 'D10381'

select * from [DMS].[W_I058_DealerPrices]
delete from [DMS].[W_I058_DealerPrices]
delete from [DMS].[W_I058_SpecialPrices]

--select [DivisionCode],[DiscountType],[CompanyCode],[HospitalCode],[StartDate],[EndDate],[ProductCode],
--	[LegacySystemTransferFlag],[LegacySystemTransferDatetime],[SelloutSystemTransferFlag],[SelloutSystemTransferDatetime]
--from DMS.M_SpecialPrices where companycode = 'D10381'
--select [DivisionCode],[CompanyCode],[StartDate],[EndDate],[ProductCode],[BusinessSystemTransferdFlag],[BusinessSystemTransferdDatetime],
--	[LegacySystemTransferFlag],[LegacySystemTransferDatetime],[SelloutSystemTransferFlag],[SelloutSystemTransferDatetime]
--from DMS.M_DealerPrices where companycode = 'D10381'


--update DMS.M_SpecialPrices
--set SelloutSYstemTransferFlag = '0'
--,   SelloutSYstemTransferDatetime = LegacySystemTransferDatetime
--where DivisionCode = '201' and CompanyCode = 'D10381'