USP_DATALIST_USERSETTINGSINFORMATIONLIBRARYHIERARCHY

CREATE procedure dbo.USP_DATALIST_USERSETTINGSINFORMATIONLIBRARYHIERARCHY
(
    @SOURCEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

    select [ISCOLLAPSED],
           [SELECTEDFOLDERID]
    from dbo.[USERSETTINGSINFORMATIONLIBRARYHIERARCHY]
    where [SOURCEID] = @SOURCEID
        and [APPUSERID] = @CURRENTAPPUSERID