You're most likely looking for a group by statement along the lines of:

select 

   PERSONKEYIDS.FullName AS 'Sales Manager Name',

   Timesheets.SMID,

   LastDate = max(Timesheets.[date])

from

  AGENT_TEAM_FACT

  left...

Ilan -

I see what's happening, unexpected but it makes sense once you see it.  When you are setting @StartTime to @Today (which is the date - 3 days) + '16:00'...

Alan -

You may want to double check your logic unless you truly want records added more than 30 days ago, to the exact hour, minute and second to go into...

As far as getting only the top 1 record that matches, unless somebody else has a better idea, you're going to need a subquery for each of the line items...

Regardless of the question, it's a pretty good guess that the answer is 42

Check the job scheduler - probably have an older maintenance plan still on the schedule.

Joe

No kidding, there are a few things that I just know I'm going to be hearing about until the day I die - and others will be reminded of my...

What about stored procedures, etc?  Do they need to be moved as well or left alone on the development box?

Joe

How much data (e.g. 10GB) and how many rows are you moving on a weekly basis?  Across what type of network (100Mb/Sec, 1Gb/Sec?)  Are you moving the complete contents of...

Once upon a time when I (many moons ago) - went in to replace a failed drive in a large RAID 5 array... I was in a big hurry, eyeballed the array and...

Steve -

Can you check on the "URL above"?  I couldn't find it anywhere in your post.  Thanks for offering us this opportunity, our children are the future. 

Joe

P.S. $20 bucks is literally...

Assuming reboots/minimal off hours downtime isn't a big deal the biggest question would be the amount of data that you need to move from server A to server B. 

Moving...

Why in the world can't you schedule some off hours maintenance/down time?  Some sort of SLA?

Joe

A little more information on the SQL Trace - run the trace for a while, then save the results to a table so that you can get a good look...