Erland,

Query Notifications look like they would do the job alright but it
would mean writing each new piece of data to a table, querying it, and
then pulling the result back into my program. If this is the only
solution then I would probably be better dealing with the data-stream
within the program as speed is a huge factor and recording the data is
a secondary concern. My main question was whether there is specific
functionality within SQL Server to deal with real time analysis of data
streams?

Thanks,

Paul.