Yashwant

BEGIN TRAN
USE [f4923a18-eb00-4844-b97f-be2b8bc5112e]

DECLARE @VisitTemplateId uniqueidentifier;
SET @VisitTemplateId='17C78398-902B-48A2-AC4A-694131CBCA23'

DELETE FROM InstanceDataItems WHERE FormInstanceDataId IN (SELECT Id FROM FormInstanceData WHERE FormInstanceId IN (SELECT Id FROM FormInstances WHERE VisitId IN (SELECT Id FROM [dbo].[Visits]
WHERE VisitTemplateId=@VisitTemplateId)))

DELETE FROM FormInstanceData WHERE FormInstanceId IN (SELECT Id FROM FormInstances WHERE VisitId IN (SELECT Id FROM [dbo].[Visits]
WHERE VisitTemplateId=@VisitTemplateId))

DELETE FROM FormInstances WHERE VisitId IN (SELECT Id FROM [dbo].[Visits]
WHERE VisitTemplateId=@VisitTemplateId)

DELETE FROM [dbo].[ValidationOverrides] WHERE VisitId IN (SELECT Id FROM [dbo].[Visits]
WHERE VisitTemplateId=@VisitTemplateId)

DELETE FROM [dbo].[AuditTrailEntries] WHERE objected  IN (SELECT Id FROM [dbo].[Visits]
WHERE VisitTemplateId=@VisitTemplateId)


DELETE FROM [dbo].[Visits] WHERE VisitTemplateId=@VisitTemplateId

DELETE FROM [dbo].[VisitTemplateRole] WHERE VisitTemplateId=@VisitTemplateId

DELETE FROM [dbo].[VisitTemplate] WHERE Id=@VisitTemplateId

Rollback