I had to shut off the escalations because our system was hung. There were over 36,000 records. Yesterday there were over 500,000 records. I did know there was a multi thread delete. Is this in Oracle?
Thanks so much. I have been struggling with this all day. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brian Goralczyk Sent: Thursday, August 15, 2013 5:47 PM To: [email protected] Subject: Re: SQL Query ** Do NOT use an escalation. It will review all the rows. Unless you are running it on a different table that doesn't have a lot of rows and doing a delete from that. You want to make sure you do a multi thread delete and not a single thread delete. What DB are you using? If you are using Oracle I could give you an sample sql statement that would delete what you need fairly painlessly. Brian Goralczyk Brian Goralczyk Phone 574-643-1144 Email [email protected] On Thu, Aug 15, 2013 at 11:31 AM, Kathy Morris <[email protected]> wrote: ** We are not using the client because it was hanging, and I tried the escalation to delete the entries however it hung. Thanks From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Grooms, Frederick W Sent: Thursday, August 15, 2013 10:36 AM To: [email protected] Subject: Re: SQL Query ** Is there any reason you can't remove them using the client? You would have to do a compound query and do the B and H table(s) first before deleting from the T table i.e. Select C1 >From B350 Where C1 in (Select C1 from T350 Where C8 = 'Reconciliation' ) Select ENTRYID >From B350C536870923 Where ENTRYID in (Select C1 from T350 Where C8 = 'Reconciliation' ) Select ENTRYID >From H350 Where ENTRYID in (Select C1 from T350 Where C8 = 'Reconciliation' ) Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kathy Morris Sent: Thursday, August 15, 2013 9:26 AM To: [email protected] Subject: SQL Query ** Hi, I am trying to remove specific records from a table (T350). If I run a SQL query on a Remedy form that has a T-table (T350) with a B-table (B350) attachments, Am I going to be able to delete the data in both tables? My query: Select C8 from T350 Where C8 = 'Reconciliation' My concern is. how am I going to delete the records in the B-table that are associated with the records from the T table? The Column C8 does not exist in the B350 table so I cannot write. Select C8 from B350 Where C8 = 'Reconciliation' ----- C8 does not exist in the B table. _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

