[dbo].[MssWebGetSectionPreferences]
CREATE PROCEDURE [dbo].[MssWebGetSectionPreferences]
@inSysUserId int
AS
begin
set nocount on
select
MssWebSection.SectionKey,
IsExpanded = MssWebSectionPreference.IsExpanded
from MssWebSectionPreference
inner join MssWebSection on MssWebSectionPreference.MssWebSectionFid = MssWebSection.MssWebSectionId
where MssWebSectionPreference.SysUserFid = @inSysUserId
end
GO
GRANT EXECUTE ON [dbo].[MssWebGetSectionPreferences] TO [MssExec]
GO
