Thanks again Luke! - Copy/paste code to a new report and deploy seemed to work fine.

I'll bear in mind the other points you mentioned, right now I need to...

Incidentally, what does seem very odd is I have 6 identical parameters, all have been configured in the same way, even looking at the code in the report they are...

Thanks Luke. That makes perfect sense and seems to be working as I expected it 🙂

Rob.

Thanks for the reply Daniel. As I said I'm just getting started with reported services. It's not mission critical that it's the correct width because it gets exported to Excel,...

Thanks Lowell, I was asking this on behalf of a colleague so I shall pass this on to him 🙂

Brilliant, thanks Paul. You're correct, I am creating comma delimited strings. Initially using functions and coalesce, now giving this FOR XML thing a whirl. I'll check out the article 🙂

I'd resided myself to this idea, however, a colleague introduced me to a new technique of using FOR XML PATH and STUFF as a sub query around my main select....

I thought somebody might suggest something like that. For this particular problem I've over simplified the tables involved, and some of them don't even exist yet - so think of...

@Lynn, I tried your method, which worked fine on the small sample you gave, however, when I try it on my table I get :

Msg 1014, Level 15,...

I did wonder if the words cursor would lead to criticism! - I'll read through the other replies above and give them a go when I get a chance.

It's only...

I've been playing around with this, and come up with this, which seems to work:

DECLARE loop_cursor CURSOR

FOR

SELECT id, type FROM tblA WHERE id < 100

OPEN loop_cursor

DECLARE @id...

Thanks for the comments guys. I had spoken to a colleague before coming back on here - his advice was that a lot of the sub queries I was using...

See attached for the execution plan.

I know it's the sub queries killing it, but that's always how I've done this kind of thing.

Any help appreciated!

Lowell (6/1/2009)

---

Rob SQL2008 has an actual CPU governor for that situation...preventing any one query frome ating all resources...it's not in 2005.

a 20 minute query is unusual, unless you are threshing...

We're on 2005 at the moment, but plan to move to 2008 at some point.

I know what's slowing the query down - it's some beasty sub queries that churn...