USP_DATALIST_SCHOOL

                CREATE procedure dbo.USP_DATALIST_SCHOOL
                as 

                    set NOCOUNT on;

                    select 
                        SCHOOL.ID,
                        CONSTITUENT.NAME,
                        SCHOOL.GENDER,
                        (SELECT STUFF((SELECT '; ' + dbo.GRADELEVEL.ABBREVIATION
                               FROM SCHOOLGRADELEVEL 
                                 INNER JOIN GRADELEVEL
                                   ON SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
                               WHERE SCHOOLGRADELEVEL.SCHOOLID = dbo.SCHOOL.ID
                               ORDER BY GRADELEVEL.SEQUENCE
                               FOR XML PATH('')),1, 2, '')) AS GRADELEVELS,
                        ORGANIZATIONDATA.PARENTCORPID as PARENTSCHOOLID    
                    from dbo.SCHOOL
                            inner join dbo.CONSTITUENT
                                    on dbo.SCHOOL.ID = dbo.CONSTITUENT.ID
                            left outer join dbo.ORGANIZATIONDATA
                                    on dbo.ORGANIZATIONDATA.ID = dbo.CONSTITUENT.ID