12 lines
367 B
Transact-SQL
12 lines
367 B
Transact-SQL
ALTER 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.GroupId
|
|
INNER JOIN [dbo].[TestSetups] as C ON C.TestSetupId=B.TestSetupId WHERE A.StaticGroupId=@StaticGroupId
|
|
END
|
|
END |