Hi,
We are trying to delete data from 3 forms. RE: Job Runs RE: Job Events Application Pending Our team Project Manager wants to run a history report on the data that was in Job Runs to measure how long reconciliation jobs are running (instead of adding another 10 Gig of Memory). To prepare to truncate the table, I exported the data in from RE: Job Runs directly from Oracle to .csv file, however the Run Start Time exported as "1,354,455,451" . Application Pending cannot be completely deleted. Not sure of the impact of deleting all the data in RE: Job Events.. We do need some history. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Downing, Ryan Sent: Thursday, August 15, 2013 11:03 AM To: arslist@ARSLIST.ORG Subject: Re: SQL Query ** 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] On Behalf Of Pargeter, Christie :CO IS Sent: Thursday, August 15, 2013 10:36 AM To: 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 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_ _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"