spGetFolders

                CREATE procedure dbo.spGetFolders
                    @ClientSitesID int,
                    @Type smallint
                as
                    set nocount on;

                    select 
                        FolderTypeId, 
                        FolderTypeName
                    from dbo.SiteFolderTypes
                    where FolderTypeId = @type;

                    select 
                        FolderTypeId, 
                        FolderTypeName,  
                        FolderID, 
                        FolderName, 
                        ParentFolderID, 
                        Sequence, 
                        ClientSitesID,
                        Guid, 
                        OwnerID
                    from 
                        dbo.SiteFolderTypes 
                        inner join dbo.SiteFolders on FolderTypeId = type
                    where 
                        ClientSitesID = @ClientSitesID
                        AND FolderTypeId = @Type
                        AND deleted=0
                    order by 
                        ParentFolderId, 
                        FolderName;
                        --Sequence TRW 10-09-07 Sequence is not being used.