USP_DATAFORMTEMPLATE_EDITLOAD_PERSONALNOTESSETTINGS

        create procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PERSONALNOTESSETTINGS(
            @ID uniqueidentifier, -- should be SiteContent Guid
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
              @SITECONTENTID int = null output,
              @ONSUBMITPAGEID int = null output,
              @NOTETYPECODEIDS xml = null output
        )
        as
            set nocount on;

                    -- setting @DATALOADED because it's okay if the ID returns nothing
                    set @DATALOADED = 1
                    set @TSLONG = 0

            select
                @TSLONG = TSLONG,
                @SITECONTENTID = [SITECONTENTID],
            @ONSUBMITPAGEID = [ONSUBMITPAGEID],
            @NOTETYPECODEIDS = [NOTETYPECODEIDS]
            from 
            [dbo].[PERSONALNOTESSETTINGS] with (nolock)
            where 
            ID = @ID

            return 0;