spImageCategories

            CREATE     Procedure [dbo].[spImageCategories]
            (
                @ClientSitesID int
            )
            AS
                select FolderName as Category, FolderID as CategoryID from dbo.SiteFolders 
                where ClientSitesID = @ClientSitesID AND Type = 2 AND deleted = 0
                order by FolderName