13 lines
365 B
Plaintext
13 lines
365 B
Plaintext
|
CREATE PROCEDURE [dbo].[sp_GroupsAndTestGet]
|
||
|
|
@StaticGroupId int = null
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
|
||
|
|
BEGIN
|
||
|
|
SELECT C.TestSetupId, C.TestSetupName, A.Id
|
||
|
|
FROM [dbo].Groups AS A INNER JOIN [dbo].TestSetupGroups AS B on A.Id = B.Id
|
||
|
|
INNER JOIN [dbo].[TestSetups] as C ON C.TestSetupId=B.TestSetupId WHERE A.StaticGroupId=@StaticGroupId
|
||
|
|
END
|
||
|
|
END
|