/****** Скрипт для команды SelectTopNRows из среды SSMS ******/
set dateformat dmy
declare @sdate datetime
set @sdate='01/01/2012' -- дата до которой все записи будут удалены

delete from [BN_PATP].[dbo].[PATP_OrderControl] where id in (
select oc.id from [BN_PATP].[dbo].[PATP_OrderControl] as oc with(readcommitted, tablock)
inner join [BN_PATP].[dbo].[PATP_OrderDataDay] as ODD
with (index (ix1_patp_OrderDataDay))
on ODD.id=oc.Order_Data_day_id
where (ODD.[day_date]<@sdate)
)