Hi One of the ideas ... Create a stored procedure in the database that will be triggered everytime a row is deleted, checks the rowid and rearranges the records based on which row is deleted. Though I am not sure about what performance impact this will have.
Thanks Tejas -----Original Message----- From: senthil.s [mailto:[EMAIL PROTECTED] Sent: Monday, July 24, 2006 11:26 AM To: user@struts.apache.org Subject: Give me a solution Hi all I have a table of records in SQL Server with UniqueID (unique ID enabled with increment of 1 starting from 1 for each record, now I have 100 records in that having Unique ID 1 - 100 now I want to delete records (only 10 records in the middle) having Unique id 50 - 59 and I want the remaining records (say 60... 100) has to rearrange themself (say 50... 90 as Unique ID) Thank You Senthil.S http://www.patni.com World-Wide Partnerships. World-Class Solutions. _____________________________________________________________________ This e-mail message may contain proprietary, confidential or legally privileged information for the sole use of the person or entity to whom this message was originally addressed. Any review, e-transmission dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error kindly delete this e-mail from your records. If it appears that this mail has been forwarded to you without proper authority, please notify us immediately at [EMAIL PROTECTED] and delete this mail. _____________________________________________________________________
