Kathy, Unless you need to keep the records in this form.....perform a truncate on the T H and B tables
If it is the RE:Job Runs form the records on only for reference....nothing else.. Regards, Ryan. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Thursday, August 15, 2013 10:43 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Query ** ** Our performance is so poor right now that we are doing this directly thru SQL. I did not do a query on C1, I queried C8. Is there something that need to do with C1? We are trying to stabilize things because a lot of records are created in the table and it's degrading performance right now. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]<mailto:[mailto:arslist@ARSLIST.ORG]> On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, August 15, 2013 10:36 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: SQL Query ** Don't forget your H350 table too. But the C1 from T350 if I remember right is the C1 from H350 & B350. Also, can't you do this with an escalation or filter? If you do this with workflow the system will get all the sub tables for you. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Kathy Morris Sent: Thursday, August 15, 2013 7:26 AM To: arslist@ARSLIST.ORG<mailto: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_ _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"