jeanangeo (12/27/2008)

---

I'm fairly sure I will look back at it in a few years and see a million areas where I could improve the performance but it's out the...

After some tests, ROW_NUMBER is still slow. I ran both queries on a real table and came up with 76% of the cost vs 24% of the cost when...

I really don't see any reason to be rude to someone who is attempting to help you, even if their suggestions in this particular case don't...

Jack Corbett (12/26/2008)

---

Seth,

The way I...

Just to tie up the loose ends, this solution should be correct, and handle all situations.

;WITH MA( Apprentice_id, Agreement_ID, [Start_Date], RN )

AS

(SELECTApprentice_ID,

Agreement_ID,

[Start_Date],

ROW_NUMBER() OVER (PARTITION BY Apprentice_ID ORDER BY [Start_Date] DESC)...

Not a problem, Jude, glad we could help.

I did figure out the issue with mine though, which is only an issue with multiple appointmentID's being the same. So, the...

A few things

1. To turn on actual execution plan, go to the Query option in the menu and select 'Include actual execution plan.'

Alternatively, hit CTRL + M.

2....

Q-Girl (12/26/2008)

---

Thanks Seth, that works too. Is there a performance benefit to doing it your way over Jack's? Just so you know, the code will be a sub-query inside of...

:hehe: Mornin Jack :hehe:

I had an almost identical post typed out, then decided to try to get used to the new 2005 stuff that I always ignore. ...

To know how to handle it, we need to know what agreement_id you want.

Do you want the start date of each? Add it to the group by.

Do you...

In a situation like this, I'd make a table like this instead:

Table:CodeGroups

CodeID

GroupID

IsExcluded

Store a groupID for every codeID. Then, you can write your queries just by linking through this table....

I've never liked using JOIN's in delete statements, but I think you'd have to do it like this:

CREATE TRIGGER [t_ptSchedule_TO_ptAppointmentsDELETE]

ON [dbo].[ptSchedule]

AFTER...

Greg Snidow (12/24/2008)

---

Jeff, I lost quite a few brain cells on this one, as it was just a bit over my head, and would be interested to see your...

To expand upon this (Jack is right that you don't need to delete).

What you were doing in your last trigger...

Yeah, I probably overuse left joins in situations like that. But he does allow NULL's (I still have a copy of that tabe definition from a past problem) in...