declare @anumber nvarchar(25) = '600-021614--393'
select * from FillerOrder where AccessionNumber = @anumber
select * from Exam where AccessionNumber = @anumber
select * from tmp_Worklist where AccessionNumber = @anumber
select * from CaseNotes where ProcedureKey = 1197608 -- examkey
select * from ExamWorkflow where FillerOrderKey = 1200193 -- fokey
select * from ExamFlat where AccessionNumber = @anumber

delete from FillerOrder where AccessionNumber = @anumber
delete  from Exam where AccessionNumber = @anumber
delete  from tmp_Worklist where AccessionNumber = @anumber
delete from CaseNotes where ProcedureKey = 1197608 -- examkey
delete from ExamWorkflow where FillerOrderKey = 1200193 -- fokey
delete from ExamFlat where AccessionNumber = @anumber