After looking at all the posts this seems the best code:

declare @i int, @j-2 int, @k int

set @k = 1

while @k <...

Thank you all for the help! This is what I did based on the first reply. First I created a table with a three character column then ran...

Not sure if this will work:

delete from table t1

where Statdate != (select max(Statdate) from table t2 where t1.ServerName = t2.ServerName)

Thank you all!!!

Thank you.

Thankd you.

Thank you.

Thank you!

Next question. I want to build a dts package that will run a .cmd file I have on the hard drive. What's the best way to do...

Thanks Frank, we are going to try the first option.