spECardTemplateCategories

                create procedure dbo.spECardTemplateCategories (@ClientSitesID int) as
                    set nocount on;
                    select 
                        FolderName as Category, 
                        FolderID as CategoryID from dbo.SiteFolders 
                    where 
                        Type = 3
                        and deleted = 0
                        and ClientSitesID = @ClientSitesID 
                    order by 
                        FolderName;