Can you post the (sanitised as needed) definition of the TVF which returns the MemberIds to which the user has access?

How is the list of members which a user is permitted to see defined?

Does the members table have a clustered index on MemberId (or whatever you have chosen to call...

I see no 'nested loops' here. What do you mean? Looping in T-SQL would require the use of something like WHILE ...

Are you happy that this query may occasionally return...

... but is this command trying to execute SecureZip on the server and the error is saying the application is not installed on the SQL Server?

Precisely this.

I stated that your sample data did not include EmpId 480.

That statement was correct now and remains...

not supported by Microsoft and against licensing rules to install a Client only application on a server.

I found the following text here:

Besides the technical problems, you must also consider...

Hello everyone,

I am currently looking for a way to create Excel reports that include formulae (probably also Pivot tables and other stuff) from Reporting Services. Searching the web and...

Is there a reason for you thinking that tempdb is the best place for your new table? Why not put it into an existing User database instead? Or create a...

I do not know the answer, but out of interest, under what circumstances do you choose to use global temp tables in preference to 'normal' session-scoped temp tables?

Does drive E: exist on the SQL Server machine, or is it a mapped drive?

It will be difficult for anyone here to help you, based on this limited amount of information & the fact that we have no knowledge of what this RAD tool...

Welcome, but please note that this is a SQL Server forum, not an MS Access forum.

Having said that, if you are doing this coding totally within Access, it should be...

Hi, We've been looking to pull the text from a table in a vendor DB that stores in RTF format. I found a solution on a site but am...

Blimey, I think I need to stop posting and see a doctor! For some reason, I thought that there was a need to maintain the original file extension.

It's not pretty, or fast, but it works:

SELECT
    dat.pth
,   path2 = STUFF(dat.pth, calc.pos2, calc.pos1 - calc.pos2, 'this')
FROM
(
    VALUES ('temp/a/g.txt')
...