DECLARE @reservNo   INT
SET     @reservNo = 5004001

IF OBJECT_ID('tempdb..#eventStartTimes') IS NOT NULL
   DROP TABLE #eventStartTimes

CREATE TABLE #eventStartTimes
(
    eventNo     INT,
    location    INT,
    [event]     INT,
    startDate   DATETIME
)

DECLARE @eventIndex INT
SET     @eventIndex = 0

DECLARE @tempString VARCHAR(MAX)
DECLARE @locatID    INT
DECLARE @schedID    INT
DECLARE @startDate  DATETIME

SET     @tempString = (SELECT r.save_info FROM resrvatn r WHERE reserv_no = @reservNo)

WHILE (PATINDEX('%<Event[_]%>%', @tempString) != '')
BEGIN
    SET     @tempString = SUBSTRING(@tempString, PATINDEX('%<Event[_]%>%', @tempString),
            LEN(@tempString)) -- Trim until next event
    SET     @tempString = SUBSTRING(@tempString, PATINDEX('%<callocatid>%', @tempString),
            LEN(@tempString)) -- Trim until location ID

    SET     @locatID = CAST(SUBSTRING(@tempString, LEN('<callocatid>') + 1,
                       PATINDEX('%</callocatid>%', @tempString) - LEN('</callocatid>'))
                       AS INT)

    SET     @tempString = SUBSTRING(@tempString, PATINDEX('%<calschedid>%', @tempString),
                          LEN(@tempString)) -- Trim until event ID

    SET     @schedID = CAST(SUBSTRING(@tempString, LEN('<calschedid>') + 1,
                       PATINDEX('%</calschedid>%', @tempString) - LEN('</calschedid>'))
                       AS INT)

    SET     @tempString = SUBSTRING(@tempString, PATINDEX('%<start[_]date>%', @tempString),
                          LEN(@tempString)) -- Trim until start_date

    SET     @startDate = CAST(SUBSTRING(@tempString, LEN('<start_date>') + 1,
                         PATINDEX('%</start[_]date>%', @tempString) - LEN('</start_date>'))
                         AS DATETIME)

    INSERT INTO #eventStartTimes
        SELECT  @eventIndex,
                @locatID,
                @schedID,
                @startDate

    SET     @eventIndex = @eventIndex + 1

END

SELECT * FROM #eventStartTimes