spLoadRecord_EventCalendar
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN |
Definition
Copy
CREATE PROCEDURE [dbo].[spLoadRecord_EventCalendar]
(
@PKID int
)
AS
set nocount on
select
ec.ID, ec.Name, ec.CreateDate, ec.SiteContentID, ec.PersonalPageDataID, ec.DefaultDisplayMode, ec.ManagerRoles,
ct.RealmTypeId
from dbo.EventCalendar ec
left join dbo.sitecontent sc on ec.sitecontentid = sc.id
left join dbo.contenttypes ct on sc.contenttypesid = ct.id
where ec.ID = @PKID
RETURN