SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Results (
    ParameterId UNIQUEIDENTIFIER,
    QualitativeResult VARCHAR(100),
    Passed INT,
    NotrResultId UNIQUEIDENTIFIER
)
INSERT Results
VALUES
    ('CD0EEEFC-A2F9-447C-A9B6-4931C83D8EAC', '',     1, '32945339-3D85-406F-8B6D-438199A0DA9E'),
    ('CD0EEEFC-A2F9-447C-A9B6-4931C83D8EAC', '',     1, '68C91962-1B43-4F26-AB78-40BA062B6319'),
    ('CD0EEEFC-A2F9-447C-A9B6-4931C83D8EAC', '1/15', 0, '68C91962-1B43-4F26-AB78-40BA062B6319'),
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '',     0, 'C83B6EF5-0004-4D6D-BD9A-6338407D3086'),
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '',     1, 'C83B6EF5-0004-4D6D-BD9A-6338407D3086'),
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '6/15', 0, 'C83B6EF5-0004-4D6D-BD9A-6338407D3086'),
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '',     1, '8C5F48C6-A2FB-419C-A318-032D97AE8F45'),
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '1/15', 0, '8C5F48C6-A2FB-419C-A318-032D97AE8F45')

CREATE TABLE NotrResult (
    Id UNIQUEIDENTIFIER,
    NotrId INT
)
INSERT NotrResult
VALUES
    ('32945339-3D85-406F-8B6D-438199A0DA9E', 1), -- Eliminated duplicates
    ('68C91962-1B43-4F26-AB78-40BA062B6319', 2),
    ('C83B6EF5-0004-4D6D-BD9A-6338407D3086', 3),
    ('8C5F48C6-A2FB-419C-A318-032D97AE8F45', 4)

CREATE TABLE vNOTR (
    ClientName VARCHAR(100),
    NotrId INT,                     -- Added column (values copied from NotrResult)
    SupplierName VARCHAR(100),
    FacilityName VARCHAR(100),
    ProductLineName VARCHAR(100),
    Qualification VARCHAR(100),
    DateCompleted DATETIME
)
INSERT vNOTR
VALUES
    ('Sb', 1, 'Pl', 'St', '12oz', '', '2021-12-14 13:30:00.000'), -- Eliminated duplicates
    ('Sb', 2, 'Pl', 'Dt', '12oz', '', '2021-12-14 13:35:00.000'),
    ('Sb', 3, 'Dc', 'Fb', '12oz', '', '2021-12-15 10:10:00.000'),
    ('Sb', 4, 'Dc', 'Ds', '12oz', '', '2021-12-14 13:45:00.000')

CREATE TABLE Parameter (
    Id UNIQUEIDENTIFIER,
    Name VARCHAR(100),
    ParameterNumber INT,
    Repeated INT
)
INSERT Parameter
VALUES   
    ('CD0EEEFC-A2F9-447C-A9B6-4931C83D8EAC', '45t', 5006, 15), -- Eliminated duplicates
    ('BA8DDBA0-71B0-4B7E-9B40-CAC20439EF96', '45t', 5006, 15)

18 rows affected

-- After eliminating duplicate source data, the final DISTINCT is unnecessary.
WITH CTE_Unfiltered AS (
    SELECT
        b.NotrId AS NOTR
        ,c.DateCompleted AS Month
        ,c.ClientName AS Client
        ,c.SupplierName AS Supplier
        ,c.FacilityName AS Facility
        ,d.ParameterNumber AS PN
        ,d.Name AS [Parameter Name]
        ,a.QualitativeResult AS Performance
        ,a.Passed
        ,a.ParameterId
    	,ROW_NUMBER() OVER (
            PARTITION BY b.NotrId
            ORDER BY CASE WHEN a.QualitativeResult > '' THEN 0 ELSE 1 END
            ) AS RowNum
    FROM dbo.Results AS a
    JOIN dbo.NotrResult AS b
        ON a.NotrResultId = b.Id
    JOIN dbo.vNOTR AS c
        ON b.NotrId = c.NotrId
        AND c.DateCompleted IS NOT NULL
    JOIN dbo.Parameter AS d
        ON a.ParameterId = d.Id
    WHERE c.ClientName LIKE ('Sb')
    AND d.ParameterNumber IN('5006')
    AND c.ProductLineName LIKE ('%12%')
    AND c.ProductLineName NOT LIKE ('%Lid%')
    AND c.Qualification = ''
)
SELECT
	NOTR
	,Month
	,Client
	,Supplier
	,Facility
	,PN
	,[Parameter Name]
	,Performance
	,Passed
	,ParameterId
FROM CTE_Unfiltered
WHERE (Performance > '' OR RowNum = 1)
ORDER BY PN

NOTR	Month	Client	Supplier	Facility	PN	Parameter Name	Performance	Passed	ParameterId
1	2021-12-14 13:30:00.000	Sb	Pl	St	5006	45t		1	cd0eeefc-a2f9-447c-a9b6-4931c83d8eac
2	2021-12-14 13:35:00.000	Sb	Pl	Dt	5006	45t	1/15	0	cd0eeefc-a2f9-447c-a9b6-4931c83d8eac
3	2021-12-15 10:10:00.000	Sb	Dc	Fb	5006	45t	6/15	0	ba8ddba0-71b0-4b7e-9b40-cac20439ef96
4	2021-12-14 13:45:00.000	Sb	Dc	Ds	5006	45t	1/15	0	ba8ddba0-71b0-4b7e-9b40-cac20439ef96