Re: Give me a solution

"Give me a solution" Ha! That's rich. On 7/24/06, senthil.s <[EMAIL PROTECTED]> wrote: 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

RE: Give me a solution

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-

Re: Give me a solution

Wrong forum post. Eventhough please find a simple solution 1. Create a Staging table. 2. Copy the records from 60-100 in master table into the staging table. 3. Delete the records from 50. 4. Copy back the records from Staging table into the master table. Thanks and regards, Pazhanikanthan. P (

RE: Give me a solution

I believe this is not a struts based question. You need to post this in SQL Server forums. Anil. 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 tabl