Since each of the '<>' is an event, that would be ideal.

Like my post indicated I just need the event and the Alarm Time.

And thank you for your assistance.

Here is a subset of the test data that would/could be in a row for 2TA:

<> 03/14/2012 12:24:37 KB_SYMPTOM: CRITICAL ALARM EVENT MESSAGE: Wed 14 Mar, 2012 19:24:27 - ...

Like I mentioned, it just parses the column/variable @TA and stores the data in another table.

Here is the logic for the SP.

procedure FRACAS_TicketVsEvent

(

@ID varchar(50),

@Region varchar(100),

@Site varchar(100),

@ta varchar(8000)

)

as

declare @test-2 varchar(8000)

declare...