try using an CTE to assist .. see example

with mysession(date, session) as

(

select top 1 date, session from #rr where message <> 'error' order by date

)

select top 1 convert(varchar,date,2),session...

The was solved by the following but ugly solution.

1.) Create a table in the local database.

2.) Make the trigger dump the external number in that database (All users have read/write...

fyi... update for SP2

http://support.microsoft.com/kb/941450