BEGIN

DECLARE @removekey INT
Set @removekey = 20049
select * from [HLDWDataVA].[dbo].[ExamWorkflow] where ProviderKey=@removekey
select * from [HLDWDataVA].[dbo].[Exam] where SigningRadiologistKey=@removekey order by CalendarDateKey desc
select * from [HLDWDataVA].[dbo].[FTE] where ProviderKey=@removekey
select * from [HLDWDataVA].[dbo].[ProviderDutySchedule] where ProviderKey=@removekey order by DutyStartDateKey desc
select * from [HLDWDataVA].[dbo].[Provider] where ProviderKey=@removekey

DECLARE @goodkey INT
Set @goodkey = 6051

select * from [HLDWDataVA].[dbo].[Exam] where SigningRadiologistKey=@goodkey
select * from [HLDWDataVA].[dbo].[ExamWorkflow] where ProviderKey=@goodkey
select * from [HLDWDataVA].[dbo].[FTE] where ProviderKey=@goodkey
select * from [HLDWDataVA].[dbo].[ProviderDutySchedule] where ProviderKey=@goodkey
select * from [HLDWDataVA].[dbo].[Provider] where ProviderKey=@goodkey


DECLARE @updateremovekey INT
DECLARE @updatergoodkey INT
Set @updateremovekey = 20049
Set @updatergoodkey = 6051

UPDATE [HLDWDataVA].[dbo].[ExamWorkflow]
   SET [ProviderKey] = @updatergoodkey
 WHERE ProviderKey=@updateremovekey

UPDATE [HLDWDataVA].[dbo].[Exam]
   SET SigningRadiologistKey = @updatergoodkey
 WHERE SigningRadiologistKey=@updateremovekey
END


DECLARE @checkconfirmremovekey INT
Set @checkconfirmremovekey = 20049
select * from [HLDWDataVA].[dbo].[FTE] where ProviderKey=@checkconfirmremovekey
select * from [HLDWDataVA].[dbo].[FTEDrillThru] where ProviderKey=@checkconfirmremovekey
select * from [HLDWDataVA].[dbo].[ProviderDutySchedule] where ProviderKey = @checkconfirmremovekey
select * from [HLDWDataVA].[dbo].[Provider] where ProviderKey = @checkconfirmremovekey


DECLARE @confirmremovekey INT
Set @confirmremovekey = 20049
Delete from [HLDWDataVA].[dbo].[FTE] where ProviderKey=@confirmremovekey
Delete from [HLDWDataVA].[dbo].[FTEDrillThru] where ProviderKey=@confirmremovekey
Delete from [HLDWDataVA].[dbo].[ProviderDutySchedule] where ProviderKey = @confirmremovekey
Delete from [HLDWDataVA].[dbo].[Provider] where ProviderKey = @confirmremovekey







---------
miscellaneous debug scripts

SELECT TOP 1000 [Id]
      ,[CalendarDateKey]
      ,[CalendarDate]
      ,[DutyStartHour]
      ,[CalendarTime]
      ,[CalendarDateTime]
      ,[DutyStartDateTime]
      ,[DutyEndDateTime]
      ,[ProviderKey]
      ,[SigningRadiologistName]
      ,[SigningRadiologistType]
      ,[SigningRadiologistDutyLocation]
  FROM [HLDWDataVA].[dbo].[FTEDrillThru] where SigningRadiologistName like '%Bartolotta%' order by CalendarDateKey desc
  ----------
/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [ProviderKey]
      ,[ProviderId]
      ,[NPIProviderId]
      ,[FirstName]
      ,[MiddleName]
      ,[LastName]
      ,[Title]
      ,[StartDateTime]
      ,[EndDateTime]
      ,[TypeCode]
      ,[Speciality]
      ,[AcademicQualification]
      ,[ProfessionalOrganization]
      ,[BoardApproval]
      ,[Email]
      ,[Role]
      ,[CreatedOn]
      ,[LastUpdatedOn]
      ,[FullName]
      ,[NTPRadiologist]
      ,[NTPRadiologistType]
      ,[ProviderType]
      ,[JobTitle]
      ,[DutyLocation]
  FROM [HLDWDataVA].[dbo].[Provider] where LastName like '%Bartolo%'
----------

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Id]
      ,[MetaDataId]
      ,[DataType]
      ,[DisplayText]
      ,[DisplayOrder]
      ,[SqlFilter]
      ,[Value]
      ,[KeyValue]
      ,[Available]
      ,[CreatedOn]
  FROM [HLDWDataVA].[dbo].[MetaDataValue] where Value like '%Ba%'
  
delete from [HLDWDataVA].[dbo].[MetaDataValue] where Id='36657'

---