Bob Hovious (4/28/2009)

---

Somewhere that man is getting well paid for...

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Not until you have worked it first. Just pay attention to your parens as you work through the where clause.

I'll have to agree with Gus on this, but it would help to see the current code to really make a determination.

Hugo Shebbeare (4/28/2009)

---

Hello, with respect to MOSS, I think you already know the best way to optimise it already - just split off your indexes onto another physical disk/spindle etc....

Could be open to interpretation, but this sure sounds like an inner join to me:

I have a question on how to join 2 tables that have a one-to-many relationship such...

GilaMonster (4/28/2009)

---

I might join you this time. For some reason some of the posts over the last few days have been getting to...

spatley (4/28/2009)

---

I like this example for the additional reason that it is explicit. Using techniques like between '2009-01-01' and 2009-01-02' to get dates that take place on the first hides...

tpepin (4/28/2009)

---

Andy DBA (4/28/2009)

---

I think suggestions for proper formatting and good comments are left out of many discussions and examples because the focus is more on performance (rightly so) and...

The desert is looking good again...

The White House window washer is back...

I started to reformat your code so I could read it better, and unfortunately you have some logic errors in WHERE clauses. I'm going to leave it as an...

A seat of the pants change I'd make would be the clustered index on this table:

CREATE TABLE [dbo].[tbl_ProviderCoverage](

[tpcID] [numeric](18, 0) IDENTITY(1,1) NOT NULL ,--PRIMARY KEY but non clustered

[tpcGCProviderID] [numeric](18,...

GSquared (4/28/2009)

---

Will something like this do what you need:

;with T2 as

(select row_number() over (partition by Table1Key order by EventDate desc) as Row,

Table1Key,

EventDate,

EventText

from dbo.Table2)

select *

from dbo.Table1

left outer join T2

on Table1.ID...

Just to add, don't hesitate to ask for help. Just be sure to give us all the information we need to be of help when the time comes.

tpepin (4/28/2009)

---

Peter's explaination has already convinced me that set operations would be better. In my case, it wasn't...