Thanks Grant, I will look into different filters. Good to know it is not possible for all slow queries, however when I have one, I should be able to focus...

Just validated; The Service has full rights on that map.

I am also able to execute the statement succesfully when using a sql login.

SQL Server Service Account has full rights on the folder / file.

That is also confirmed because it works from the SSMS on the server itself

• This reply was modified 2 years, 10 months ago by  Peter Kruis.

I now see I made a typo.

INNER JOIN MAPPING.dbo.[MAPPING_price_FACET] AS f ON p.price <= f.[Max] AND p.price <= f.[Min];

This part says: Give me the mapping there the price is lower...

• This reply was modified 4 years, 1 month ago by  Peter Kruis.

You're welcome.

I think my query does what you want. Let me know if you have checked and don hesitate if you have any questions about the query or syntax.

With your UPDATE you try to update your records in the table Mohawk_Prod. However you are asking to give create a query which returns the information the same as Access....

Thanks a lot! That indeed did the job!

Not sure, getting this results from a supplier, which I think get this data from MapQuest.

Hi Jonathan,

That indeed is a solution I can use, however I am curious why the ORDER BY CASE does not work, and when I add the CASE in the select...

I found this problem in multiple versions. The customer which it is made for is on an older version, however with the same syntax it also gave the strange result...

Thanks for the help, I will add a computed column.

Exacty! thanks!

That's correct.

Sorry, you are right. I ment changing the column names :unsure:

Good for this table, however i cannot change the tablename without changing the 'cross apply' part, so for my other table, i need to change the whole query, in stead...

Thanks for all the reply's

I will try to make the like faster.

the columns are not nullable, so the full scan needs to be done.

I will mark Jacob's answer as positive.