SELECT TOP (1000) [Id]
      ,[ProjectId]
      ,[IterationId]
      ,[ControlId]
      ,[ControlValue]
DELETE FROM [MinuteData].[dbo].[CfgtrProjectProperties]

-- Declare a variable for the target project name
DECLARE @TargetProjectName NVARCHAR(100);
SET @TargetProjectName = 'Example 2';

-- Step 1: Display the records you want to delete
SELECT p.[Id], p.[ProjectId], p.[IterationId], p.[ControlId], p.[ControlValue]
FROM [MinuteData].[dbo].[CfgtrProjectProperties] p
JOIN [MinuteData].[dbo].[CfgtrProjectNumbers] n
    ON p.[ProjectId] = n.[Id]
WHERE n.[ProjectName] = @TargetProjectName;

-- Step 2: Delete after verification
DELETE p
FROM [MinuteData].[dbo].[CfgtrProjectProperties] p
JOIN [MinuteData].[dbo].[CfgtrProjectNumbers] n
    ON p.[ProjectId] = n.[Id]
WHERE n.[ProjectName] = @TargetProjectName;

-- Step 3: Verify the deletion
SELECT * FROM [MinuteData].[dbo].[CfgtrProjectProperties] p
WHERE p.ProjectId IN (SELECT n.Id 
                      FROM [MinuteData].[dbo].[CfgtrProjectNumbers] n 
                      WHERE n.[ProjectName] = @TargetProjectName);