USP_DATALIST_ACCOUNTINGELEMENTSECURITYGROUP_BYELEMENT

Data list showing all security groups for a given element.

Parameters

Parameter	Parameter Type	Mode	Description
@ACCOUNTINGELEMENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ACCOUNTINGELEMENTSECURITYGROUP_BYELEMENT
(
  @ACCOUNTINGELEMENTID uniqueidentifier
)
as
    set nocount on;

  select
    AESGE.ID,
    AESG.NAME,
    AESG.DESCRIPTION,
    AESG.ID as SECURITYGROUPID,
    AESGE.DATECHANGED
  from
    dbo.ACCOUNTINGELEMENTSECURITYGROUPELEMENT AESGE
    inner join dbo.ACCOUNTINGELEMENTSECURITYGROUP AESG
      on AESGE.ACCOUNTINGELEMENTSECURITYGROUPID = AESG.ID
  where
    AESGE.DATAELEMENTID = @ACCOUNTINGELEMENTID