8 lines
281 B
Plaintext
8 lines
281 B
Plaintext
|
CREATE PROCEDURE [dbo].[sp_GroupsWithSensorsGet]
|
||
|
|
@List as dbo.IDList READONLY
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
SET NOCOUNT ON;
|
||
|
|
SELECT B.Id, B.DisplayName FROM [Channels] as A INNER JOIN [Groups] as B on A.GroupId=B.Id WHERE A.[SensorId] in (SELECT [ID] FROM @List) AND B.Embedded <> 1;
|
||
|
|
END;
|