Perfect, thank you! Thought it might be something like that but couldn't get it right.

Cheers!

Ah! Excellent! Thanks! That should get me on the right tracks!

Hi, the pages are all in one file for each set so I don't need to worry about multiple files. It's the shredding where I'm falling over slightly..

I can pull...

OK. OK. So I got it.

If I print the area_id from the SP, it obviously caches the last result of the output.

The select statement returns nothing in it's first pass,...

Hi! Sorry I totally missed the etiquettes post.. Yeah testing the table function is totally killing the server! But at least it's working..

There's a few tables involved so it'll take...

Hmm. Well, haven't worked it out so if anyone has an idea I'd still be interested to know...

However I've gotten around the problem by sticking the SP Code into...