USP_DATALIST_EVENTLOCATIONS

                CREATE procedure dbo.USP_DATALIST_EVENTLOCATIONS
                as
                    set nocount on;

                    select
                        EVENTLOCATION.ID,
                        EVENTLOCATION.NAME,                        
                        EVENTLOCATION.PHONENUMBER,
                        EVENTLOCATION.CAPACITY,
                        EVENTLOCATION.ADDRESSBLOCK,
                        EVENTLOCATION.CITY,
                        (select STATE.ABBREVIATION from dbo.STATE where STATE.ID = EVENTLOCATION.STATEID),
                        EVENTLOCATION.POSTCODE,
                        (select count(*) from dbo.EVENTLOCATIONROOM where EVENTLOCATIONROOM.EVENTLOCATIONID = EVENTLOCATION.ID)
                    from
                        dbo.EVENTLOCATION
                    order by
                        EVENTLOCATION.NAME;