USP_DATALIST_SITEFOLDERS

CREATE procedure dbo.USP_DATALIST_SITEFOLDERS(@TYPE smallint = 6) with execute as caller
as
    set nocount on;

    SELECT 0 as FOLDERID, 'Action Item Gallery' as FOLDERNAME
    UNION ALL
    select 
        FOLDERID, 
        FOLDERNAME
    from dbo.SITEFOLDERS
    WHERE TYPE = @Type and DELETED = 0
    order by FOLDERNAME