I need to clean all records from contour db which older than some date (2 month).

 

Who can help me to re-factor this

 

IF (OBJECT_ID('ContourRemoveRecords') IS NOT NULL)

  DROP PROCEDURE ContourRemoveRecords

GO

Create PROCEDURE [ContourRemoveRecords] 

    @date datetime = NULL

AS

BEGIN

       create table #RecordsFormsGuids (

    RecordId nvarchar(36)

)

create table #RecordsKeys (

    RecordId nvarchar(36)

)

INSERT INTO #RecordsFormsGuids

Select Id  FROM [dbo].[UFRecords] where Created < Convert(datetime, @date)

 

DELETE FROM  [dbo].[UFRecords] where Created < Convert(datetime, @date)

 

DELETE FROM [dbo].[UFRecordsXml] where Created < Convert(datetime, @date)

 

Insert INTo #RecordsKeys

SELECT [Key]

FROM [dbo].[UFRecordFields] Where Record in

(

Select * from #RecordsFormsGuids

)

 

DELETE FROM [dbo].[UFRecordFields] Where Record in

(

Select * from #RecordsFormsGuids

)

 

DELETE

  FROM [dbo].[UFRecordDataString] Where [Key] in 

  (

Select * from #RecordsKeys

  )

 

Drop Table #RecordsFormsGuids

 

Drop table #RecordsKeys

END