just because i said i would, here are the stats for the alternative formulations of the query you wrote for me. Option 3 wins (also had the unintended benefit of...

thanks very much; i'll do that.

GilaMonster (8/17/2011)

---

DTS still works in SQL 2008. May not in the next version...

They're not openable in BIDs, download the DTS designer from the resource pack site and you can open...

call me schtummie, but i was...

i think i found the elephant in the livingroom...

i am embarrassed to say that in looking at the following i feel like a dunce...there's no excuse for these except that...

ChrisM@Work (8/15/2011)

---

Should be quite a bit faster...

not only were these absolutely...

Holy Good Night...that sure is a lot more readable!

I am not sure if the distinct is necessary or not.

Thank you for your work

drew

thank you for the additional reading, i will do it over the weekend.

drew

Great article, thanks for it.

http://sqlinthewild.co.za/index.php/2010/09/14/one-wide-index-or-multiple-narrow-indexes/

i will create the ci with effective date, term date and include dx1.

The example values would be 200906 201006 (year to year June 2009 through June 2010)

I will read the cite.

My speculation was founded (again on the misapprehension?) that including the date and diagnoses ranges would make the index the most selective it could be.

<<Yeah, that much I got...

Are the columns datetime or something else?

Are the parameters datetime or something else?

What are those start and end dates? Date with no time? Date with...

<<If you need help there I can refformat that whole proc in 10 seconds for you... just let me know.

Do you still need help with this problem (tuning wise)? >>

I...

Hello Gail;

@start and @enddates are collected by ccr0_BuildApproach and passed to each called sproc

exec sp_ccr2_encounter_table_ageAndsex @start_dt = @start_dt_master, @end_dt = @end_dt_master, @anchor_dt = @anchor_dt_master

then they are used in the called...