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 bgoralc...@gmail.com On Thu, Aug 15, 2013 at 11:31 AM, Kathy Morris <kathymorris...@aol.com>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: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > > *Sent:* Thursday, August 15, 2013 10:36 AM > *To:* arslist@ARSLIST.ORG > *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:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] *On Behalf Of *Kathy > Morris > *Sent:* Thursday, August 15, 2013 9:26 AM > *To:* arslist@ARSLIST.ORG > *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_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
