spGet_UserPages_AdditionalEditors

Parameters

Parameter Parameter Type Mode Description
@UserPageID int IN

Definition

Copy


  CREATE PROCEDURE [dbo].[spGet_UserPages_AdditionalEditors]
  @UserPageID int
  AS
  SELECT
  cu.FirstName,
  cu.LastName,
  cu.ID
  FROM
  dbo.UserPages up
  INNER JOIN dbo.UserPagesEditors upe
  ON upe.UserPagesID = up.ID
  INNER JOIN dbo.ClientUsers cu
  ON upe.ClientUsersID = cu.ID
  WHERE
  up.ID = @UserPageID