I've used the data that you posted to mock-up a preliminary routine to solve this:

Alter Proc spInstructorAssignments_SS_Solution as

/*select * from InstructorSummary order by StudentId

select * from Assignment --Where StudentId=101

...

Hey, thanks for the plug, Jeff!

Paul White (5/11/2009)

---

At the risk of being...

Jeff Moden (5/11/2009)

---

BWAA-HAAA! According to what I see in Barry's fine code, they were, in fact, all the same...

CREATE TABLE [dbo].[WCI_IP_ST_AGENT_SKILL_GROUP_HH](

[DateTime] [datetime] NULL,

[EmpNumber] [varchar](32) NOT NULL,

[Skill Group] [varchar](32) NOT NULL,

[SkillGroupSkillTargetID] [int] NOT NULL,

[SkillTargetID] [int] NOT NULL,

[wcEmployeeId] [int] NOT NULL,

[wcTaskId] [int] NOT NULL,

[PeripheralID] [int] NOT NULL,

[wcCallsAnswered] [int] NULL,

[wcTalkTime] [int]...

Heh. Frankly,...

Jonathan Kehayias (5/11/2009)

---

Bob Hovious (5/11/2009)

---

Thanks, Steve.

I agree, Roy.

You are an unbeliever, Johnathan?

Glad to see you're thinking ahead, Alvin.

Hey Lynn, do you think we'll make 5K this...

Glad we could help.

It's OK, this problem interests me. 🙂

I would use something like thid to mak a stored procedure to purge the backup files:

drop table #DirOut

go

DECLARE @path VARCHAR(256) -- path for backup files

DECLARE @EarliestDate VARCHAR(20) -- purge all...

Glad I could help.

BU69 (5/11/2009)

---

From BOL (2008 version but I couldn't find it in 2005 but sure it's there!!!!!!):

"Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics causes queries to...

While you can do this, there is some question as to whether you should do it. The issue is that ofr most transactional methods, charges are "All Or Nothing"....

Hmm, I seem to recall that this issue in 2000 was if the ORDER BY contained an expression, instead of just a column.

By the way, if you want to reduce concurrency issues with this to a linked server, you should probably use a passthrough-type query using "EXEC linkedServer.master.dbo.sp_ExecuteSQL ...". That should...