Well, if he is fishing he is using the wrong bait. 😛

Based on your original post, all you need to order by is the oldmachineId; ORDER BY oldmachineID DESC.

Unless I am missing something?

Just a little bit rude, don't you think??

Only working today and tomorrow this week, taking three days vacation next week so not working at all next week.

What type of processing are we talking about? If it is updating data in the database, keep it on the server. If it is processing for presentation, put...

Not only that, and it may just be me, but it looks like the logic for the first and last row of data look the same.

How about you show us what you have tried first. Maybe we'll what you are doing wrong and help you that way instead of just giving you the answer.

That isn't what you...

But how is it being used? How would you switch back?

You can restore a SQL Server 2005 backup to SQL Server 2008, but you can't go the other way.

Nothing wrong with VB.NET, but let's...

I'd talk to your system admin.

How are you using the DR Server?

vikas bindra (12/21/2009)

vikas bindra (12/21/2009)

Lynn Pettis (12/21/2009)

vikas bindra (12/21/2009)

declare @lastFriday datetime

SET @lastFriday = convert(datetime,convert(varchar(10),getdate() - (datepart(w,getdate())+1),121))

select

@lastFriday - 6

,@lastFriday - 5

,@lastFriday - 4

,@lastFriday - 3

,@lastFriday -...

If you run it, it is running as you. Check to make sure that the service the SQL Server Agaen is running under has proper permisions to the shared...

What would really help; table definitions, sample data, expected results based on sample data. The sample data should reflect the problem at hand, but shouldn't be more than 10...