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 (Paz)
Consultant for AXA,
HCL Australia Services Pty. Ltd.
Off : +61-3-9618-4085
Mob : +61-0411-354-838
"senthil.s" <[EMAIL PROTECTED]>
24/07/2006 03:56 PM
Please respond to "Struts Users Mailing List"
To: <[email protected]>
cc:
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
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.comThis email and any files transmitted with it are
confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the system manager.
Please note that any views or opinions presented in this email are solely
those of the author and do not necessarily represent those of IC Infotech.
Finally, the recipient should check this email and any attachments for the
presence of viruses. IC Infotech accepts no liability for any damage
caused by any virus transmitted by this mail.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
*********************************************************************************
Important Note
This email (including any attachments) contains information which is
confidential and may be subject to legal privilege. If you are not
the intended recipient you must not use, distribute or copy this
email. If you have received this email in error please notify the
sender immediately and delete this email. Any views expressed in this
email are not necessarily the views of AXA. Thank you.
**********************************************************************************
