USP_LOCATIONAVAILABILITY_GETLOCATIONINFO

create procedure dbo.USP_LOCATIONAVAILABILITY_GETLOCATIONINFO
(
    @LOCATIONS xml = null
)
as
begin
    declare @LOCATIONLIST as table 
    (
        ID uniqueidentifier
    );

    insert into @LOCATIONLIST 
    select
        T.c.value('(ID)[1]','uniqueidentifier') as 'ID'
    from @LOCATIONS.nodes('/LOCATIONS/ITEM') T(c)

    select
        el.ID,
        el.NAME,
        el.CAPACITY
    from dbo.EVENTLOCATION el
        inner join @LOCATIONLIST ll on el.ID = ll.ID
end