I do a new a clean windows 7 pro install, not a upgrade from vista.

I do all upgrades from microsoft.

I only install norton internet scurity 2010.

No other sotware is installed.

Summary_arciga_20100121_152341

Overall...

Mark, thanks....

It works...

I use SQL 2005...

--===== Create the test table with

CREATE TABLE [dbo].[transactions](

[city] [int] NULL,

[customer] [int] NULL,

[int] NULL,

[payment] [real] NULL

) ON [PRIMARY]

INSERT INTO transaction (city, customer, code, payment)

SELECT '10','2599','253','96.66' UNION ALL

SELECT '13','2088','253','164.17' UNION...

thanks ....

Hi Dinakar Nethi,

Thanks for your response, it works, but now i have another similar problem.

How do I renumberig my ID_X column...