A phrase that makes me slighlty crazy and want to kill everyone in my office is "It is what it is"

Of Course it is what it is has anything ever...

Something like this should work nicely

Select

t.CustId

,t.PersonId

,t.startdate

,t.Enddate

,t.Name

from

(

Select

CustId

,PersonId

,startdate

,Enddate

,Name

,ROW_NUMBER() OVER(PARTITION BY PersonId ORDER BY Enddate DESC) as rownum

from

table1

) as t

where

t.rownum=1

I might suggest reposting this thread with the scripts as an attachment. The Sample data scipt you posed is too large and causes the browser to lock up. ...

I am eating pop tarts at this very moment. Of course I have never claimed to be normal in any sense of the word.

IT is 75% oppinoin and 25% fact. The reboot/Boot debate has been going on for more reasons than anyone can remember. Though the points behind the debates have...

I have actually written a couple of utility apps in the past that I would consider as close to bug free as you can get but that is largely becuase...

without an order by it is likely doing an order based on the index. since you had to reinsert records the index is now out order most likely. ...

There are a lot of moving parts to this script. The case statements with in the sum will cause a heavier io cost but having 15 of them will...

I recently was working on doing something similiar. We had a system that was written by someone who was in love with functions and used them for everything. ...

SELECT FE.GAAPAccountingPeriod, FE.RiskHistoryKey, FE.ReserveGroupKey, FE.FinancialsKey, FE.SettlementCurrencyKey, FE.GAAPInceptedDateKey,

...

Select

case

when LEN({View_Report_LABELS.case_number}) = 15

then LEFT(RIGHT({View_Report_LABELS.case_number},9),2)

else

RIGHT({View_Report_LABELS.case_number},2)

end

This is one of those DBs that make you want to bang you head on the wall. I do the isnull becuase there are records out there that are...

The report is for all outstanding balances. The people who designed this DB took normalization to the extreme this unfortunatley means that a simple matter of a balance is...

Here is the plan and the table stats

Ticket Table

Rows 1764750

Payment to fine

Rows 2447146

not sure if this helps or not but just an observation. I have in the past run across things like this and when I look at the code page...