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 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 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]
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- 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. _
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 (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:
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.
**
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 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 Information transmitted by this e-mail is proprietary to Infinite Computer Solutions and / or its Customers and is intended for use only by the individual or the entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at [EMAIL PROTECTED] and delete this email from your records.
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 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]
