I tested this solution and it worked. I'm still trying to find a more polished way of achieving the results, though.

=Replace("Valore Punti (" & FormatCurrency(0, nothing) &...

• This reply was modified 2 years, 1 month ago by  ricky969.

the index on the temp table helped. what also helped tremendously was to use the switchboard approached mentioned above. Now user without restrictions can join to dbo.Member and get the...

Unfortunately there's no clustered index on the MemberID which is of a type uniqueidentifier

I did notice that if I disable the filtering and join straight to the dbo.Member table (so...

If I determine that I need to filter the members, I make a call to a tablevalue function and insert those records in a temp table

In my test environment, without...