hi Jeff,

I am now ok with this, storing the data like 1,2,3 was stupid.

I have just created a link table , so I do now have 3 tables instead of...

of course !!

I dont know what I was thinking then.

thank you.

thank you for your help

this script now works, I'll also look at the link.

hi, I get this error :

Msg 207, Level 16, State 1, Line 9

Invalid column name 'EventInfo'.

superb.

thank you, why does that work then ?

thats great thanks.

great use of rank() !!

thank you.

hi, this isn't a problem with installing on vista.

All I am trying to do is connect to an existing sql reporting server via a vista computer..

David, you're a frigging genius !

I'll have a play with this and let you know.

thank you so much !

Hi, both are nice suggestions.

 I like Davids idea.

Is there a way of actually looping through the locations automatically and populating the WHERE location = 'locationwanted' part .

locations can be...

Hi,

but how can I do that using T-SQL ?

I have over 300 different locations. I don't want to do it manually...