Table: <Table_Max id="1" note="some note1" date="2006-07-07T19:39:46" ID_NEW="1"/><Table_Max id="2" note="somenote2" date="2006-07-07T19:37:46" ID_NEW="1"/><Table_Max id="3" note="somenote3" date="2006-07-08T19:35:46" ID_NEW="2"/><Table_Max id="4" note="somenote4 select distinct id_new into #temp from Table_Max DECLARE ac CURSOR FOR SELECT * from #temp OPEN ac -- Perform the first fetch and store the values in variables. -- Note: The variables are in the same order as the columns -- in the SELECT statement. DECLARE @id int FETCH NEXT FROM ac INTO @id -- Check @@FETCH_STATUS to see if there are any more rows to fetch. WHILE @@FETCH_STATUS = 0 BEGIN declare @maxP as datetime set @maxP = ( select MAX([date]) from Table_Max where id_new = @id) -- Concatenate and display the current values in the variables. declare @note as nvarchar(4000) set @note = ( select note from Table_Max where id_new = @id and [date] = @maxP) PRINT 'Last modified: ' + cast(@maxP as nvarchar(4000))+ ' for ID = ' + cast(@id as nvarchar(4000)) + ' NOTE = ' + @note -- This is executed as long as the previous fetch succeeds. FETCH NEXT FROM ac INTO @id END CLOSE ac DEALLOCATE ac GO

So...What's the question??? -SN

http://www.cisco-cert.com/Windows_XP_General/620974-Windows-XP-4GB-RAM-showing-2GB-RAM