Hi ChrisM

Replies below

1.Clients with “disciplines” filtered by geography using the geography parameter. This query should reference client, client address and geography tables plus those required to identify "disciplines". If any...

Hi Guys

Here is a zipped up bak (SQL Server 2008 R2) file filed with sample data and the proc. It is 17 meg so too large to post here and...

Good for you SS Coach and Chris M.

You will have to give me a few days to get the sample database together as I will need to remove any hint...

Hi Jason

No views, just tables and 1 function (geotreedownwithID)

So is anyone accepting the challenge?

Regards

David

Hi All

Surprised this thread was still going when logged in this morning. ChrisM - I didn't realise people were actually offering to optimise my query, but if that is the...

Hi Drew

I am a human and I disagree. I find it much easier to follow when the clauses are with the table joins.

To each their own...

Regards

David

Hi Guys

I have figured this out. My theory is that adding the extra table somehow screwed up SQL Servers execution plan so badly no amount of indexing etc was going...

Hi Alex

thanks for the reply.

Are you saying SQL cannot handle 3 way joins? Are you also saying that a where clause is more efficient than a a join on clause?

Sorry...

Hi Guys

thanks for the replies.

@Phil - found it. Fast and Slow query plans are now attached, hopefully someone smarter than me can discern something useful from them.

@jayanth -...

Hi Roy,

Thanks for the reply. One problem - how to I edit (or view) a system view in 2005?

Selecting from that view returns no records.

Regards

David

You can use the windows synchronize tool to synchronize your pull subscription. It is under programs -> accessories -> Synchronize

Regards

David