CREATE TABLE #tblBlocks
 
        (
        TemplateID int,
        BlockID int,
        FieldID int,
        BaseStage bit
        )
 
GO
 

INSERT INTO #tblBlocks (TemplateID, BlockID, FieldID, BaseStage)
SELECT 1, 1, 1, 0 UNION ALL
SELECT 1, 1, 2, 0 UNION ALL
SELECT 1, 1, 3, 0 UNION ALL
SELECT 1, 2, 4, 0 UNION ALL
SELECT 1, 2, 5, 1 UNION ALL
SELECT 1, 2, 6, 0
 
GO

--SELECT * FROM #tblBlocks

DROP TABLE #tblBlocks

SELECT b.* 
FROM #tblBlocks b
WHERE NOT EXISTS (
	SELECT 1 
	FROM #tblBlocks bi 
	WHERE bi.BlockID = b.BlockID 
	AND bi.BaseStage = 1)

CREATE TABLE #tblBlocks
 
        (
        BlockID int,
        FieldID int,
        BaseStage bit
        )
 
GO
 

INSERT INTO #tblBlocks (BlockID, FieldID, BaseStage)
SELECT 1, 1, 0 UNION ALL
SELECT 1, 2, 0 UNION ALL
SELECT 1, 3, 0 UNION ALL
SELECT 2, 4, 0 UNION ALL
SELECT 2, 5, 1 UNION ALL
SELECT 2, 6, 0
 
GO

SELECT
    *
FROM
    #tblBlocks tb1
WHERE
    NOT EXISTS(SELECT
                    1
               FROM
                    #tblBlocks tb2
               WHERE
                    tb2.BlockID = tb1.BlockID AND
                    tb2.BaseStage = 1);
go
--SELECT * FROM #tblBlocks

DROP TABLE #tblBlocks
go

CREATE TABLE #tblBlocks
 
        (
        TemplateID int,
        BlockID int,
        FieldID int,
        BaseStage bit
        )
 
GO
 

INSERT INTO #tblBlocks (TemplateID, BlockID, FieldID, BaseStage)
SELECT 1, 1, 1, 0 UNION ALL
SELECT 1, 1, 2, 0 UNION ALL
SELECT 1, 1, 3, 0 UNION ALL
SELECT 1, 2, 4, 0 UNION ALL
SELECT 1, 2, 5, 1 UNION ALL
SELECT 1, 2, 6, 0
 
GO

--SELECT * FROM #tblBlocks

DROP TABLE #tblBlocks

CREATE TABLE #tblBlocks
 
        (
        BlockID int,
        FieldID int,
        BaseStage bit
        )
 
GO
 

INSERT INTO #tblBlocks (BlockID, FieldID, BaseStage)
SELECT 1, 1, 0 UNION ALL
SELECT 1, 2, 0 UNION ALL
SELECT 1, 3, 0 UNION ALL
SELECT 2, 4, 0 UNION ALL
SELECT 2, 5, 1 UNION ALL
SELECT 2, 6, 0 UNION ALL
SELECT 3, 7, 1 UNION ALL
SELECT 3, 8, 1 UNION ALL
SELECT 3, 9, 1
 
GO

SELECT
    *
FROM
    #tblBlocks tb1
WHERE
    NOT EXISTS(SELECT
                    1
               FROM
                    #tblBlocks tb2
               WHERE
                    tb2.BlockID = tb1.BlockID AND
                    tb2.BaseStage = 0);
go
--SELECT * FROM #tblBlocks

DROP TABLE #tblBlocks
go

CREATE TABLE #tblTemplates
 
        (
        TemplateID int,
        TemplateName varchar(50)
        )
 
GO

INSERT INTO #tblTemplates (TemplateID, TemplateName)
SELECT 1, 'Template 1' UNION ALL
SELECT 2, 'Template 2'
 
GO


CREATE TABLE #tblBlocks
 
        (
        TemplateID int,
        BlockID int,
        FieldID int,
        BaseStage bit
        )
 
GO
 

INSERT INTO #tblBlocks (TemplateID, BlockID, FieldID, BaseStage)
SELECT 1, 1, 1, 0 UNION ALL
SELECT 1, 1, 2, 0 UNION ALL
SELECT 1, 1, 3, 0 UNION ALL
SELECT 1, 2, 4, 0 UNION ALL
SELECT 1, 2, 5, 1 UNION ALL
SELECT 1, 2, 6, 0 UNION ALL
SELECT 2, 1, 7, 1 UNION ALL
SELECT 2, 1, 8, 0 UNION ALL
SELECT 2, 1, 9, 0 UNION ALL
SELECT 2, 2, 10, 1 UNION ALL
SELECT 2, 2, 11, 0 UNION ALL
SELECT 2, 2, 12, 0

GO

SELECT Distinct #tblTemplates.TemplateName FROM #tblTemplates
INNER JOIN #tblBlocks ON #tblTemplates.TemplateID = #tblBlocks.TemplateID -- plus some more code to satisfy the condition below

DROP TABLE #tblBlocks
DROP TABLE #tblTemplates

SELECT BlockID
FROM #tblBlocks
GROUP BY BlockID
HAVING MAX(CASE WHEN BaseStage = 1 THEN 1 ELSE 0 END) = 0