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