Test management SQL query to find out the test results associated with a suite

One of the customer wanted to know the sql query which he can use to find out the results associated with a suite. Nipun sent the following query: -


DECLARE @deletedSuiteId INT

SET @deletedSuiteId = 167 –Replace with appropriate suite Id


FROM tbl_testresult r

JOIN tbl_point p

ON r.PartitionId = p.PartitionId

AND r.TestPointId = p.PointId

JOIN tbl_suite s

ON s.PartitionId = p.PartitionId

AND s.SuiteId = p.SuiteId

WHERE s.PartitionId = 1

AND s.suiteId = @deletedSuiteId