Thanks.

I thought it would but just wanted to check. Makes sense.

/Kenneth: Yeah thanks mate. That's exactly what I ended up doing (shame because it means code duplication and then making a minor change to one copy - never ideal).

Thanks for...

Shame. I was hoping to be forced into upgrading to 2005.

Thanks anyway I'll have to redo it some other way

This does work (sort of). If the "role" is "Manager" then I get the right results.

The problem is, if the "role" is "Administrator" then I want no filtering at all...

Yeah sorry. This is what I have (names changes to hopefully make it simpler):

1. The 1st stored proc (called "Summary") calls the 2nd stored proc (called "Safe") using "INSERT INTO #Temp exec...

*BUMP*

Just back from a weeks holiday. Hmmm. No replies yet. Shame.

Any ideas greatly appreciated. I'd really like some sort of discussion otherwise I'll have to take a best guess approach...

Thanks for the replys people.

I'm now marginally wiser.

Hi again,

I thought I'd dump my research here to help any poor souls stuck with the same problem as me.

I looks like it can be done but gets a bit...

Chance,

Thanks for you reply. I'm primarily a .NET programmer (and your right it could be done the way you're suggesting) but I'm still really interested to know how (if) SQL Server...

Thanks Remi.

Is there a way to do it so I don't have to manually (in code) define the temporary table?