Looks to me you are looking at goverment regions where the Total_coal_mining_score <= 3 and based on that you want to know what regions have mortality issues related to one...

Thank you. I had not seen that thread and simply working based on SQL Serv OLTP side of the wall. I'll shut-up now. 😛

Reading your original query I am trying to understand what your goal is and the relationship between tables.

I only see one relationship

Indicators_for_regions_Both to Region_lookup on RTRIM(Region_lookup.String) = RTRIM(Indicators_for_regions_Both.Region)

But see no...

PW (12/3/2007)

---

True or False:

This query was captured as the SQL sent from MS Analysis Services ? As such you have no control over how the SQL is constructed and can't...

majorbloodnock (12/3/2007)

---

I swear to tell the truth, the half-truth and nothing like the...

California (12/2/2007)

---

First approach: I ran the SQL Query what Antares686 suggested and unfortunately this is taking way longer than my original query.I.E - 2 hours 40 minutes to complete where...

Going back thou here is an older article I wrote on the whole "sp_" thing

What is the search order for Procedures prefixed sp_?[/url]

But anyway, I have have to say without...

Yeah, at least I shaved time. But like I said there are all kinds of tweaks you can do to a query, some will have major impact, others may not...

Smirnof Ice for me or maybe it's big brother Smirnof Black, not a coffee or beer drinker.

The fun part is there are dozens and dozens of ways this query could be built here is another

SELECT DISTINCT

Accounts.UID

, Accounts.Fname + ' ' + Accounts.MI AS Fname

, Accounts.Lname

,...

After looking I cannot see anything glaring as I don't know enough however the first thing I would do is write this way and see if improves performance. But the...

The reality is this still boils down to personal preference however consider the impact of...

Sorry had a typo and the edit feature of the site never works from here

IF OBJECT_ID('tempdb..#DatabaseUsers') is not null

drop table #DatabaseUsers

create table #DatabaseUsers(DatabaseName sysname not null,DatabaseUserName sysname not...

Sorry I am working to much today, here is what the example should read

...

INSERT INTO #DatabaseUsers EXEC sp_MSforeachdb...

Ex. from your other post I just gave

EXEC INTO #DatabaseUsers sp_MSforeachdb