You could run a sql script like this
DELETE from calls where acctstatustype = 1
That would delete all the start records.
-----Original Message-----
From: Josh Hillman [SMTP:admin-maillist@talstar.com]
Sent: Monday, March 24, 1997 9:01 AM
To: emerald@emerald.iea.com
Subject: start and stop records
I've got over 36,400 start records in my Calls table (SQL) dating back to
Oct 28, 1996. Do the start records serve any purpose after the stop record
has been obtained for the same call? The stop records are pretty useful,
but I don't think I've ever used the start records for anything AFTER the
stop record has been obtained.
How can these start records be removed (if it's safe to do so)? I don't
want to kill any of the stop records yet.
Emerald 2.1.5
SQL 6.5 on NT 4.0
Ascend Max 4004 5.0A
Thanks,
Josh Hillman
hillman@talstar.com
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC3836.212B3340
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IhMRAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAGwAAAFJFOiBzdGFydCBhbmQg
c3RvcCByZWNvcmRzAGoJAQWAAwAOAAAAzQcDABgACQAfABIAAQAqAQEggAMADgAAAM0HAwAYAAkA
GwAhAAEANQEBCYABACEAAABCMjQ3RjQzOTI1QTREMDExQTI4QjYwOTUwMkMxMDYyNwDdBgEDkAYA
aAoAACEAAAALAAIAAQAAAAsAIwAAAAAAAwAmAAAAAAALACkAAAAAAAMALgAAAAAAAwA2AAAAAABA
ADkAoP1kLnk4vAEeAHAAAQAAABsAAABSRTogc3RhcnQgYW5kIHN0b3AgcmVjb3JkcwAAAgFxAAEA
AAAWAAAAAbw4eS3eOfRHs6QlEdCii2CVAsEGJwAAHgAeDAEAAAAFAAAAU01UUAAAAAAeAB8MAQAA
ABIAAABqb3NocEBuZXRjbmN0Lm5ldAAAAAMABhBSS1bXAwAHEAQDAAAeAAgQAQAAAGUAAABZT1VD
T1VMRFJVTkFTUUxTQ1JJUFRMSUtFVEhJU0RFTEVURUZST01DQUxMU1dIRVJFQUNDVFNUQVRVU1RZ
UEU9MVRIQVRXT1VMRERFTEVURUFMTFRIRVNUQVJUUkVDT1JEUy0tAAAAAAIBCRABAAAASwcAAEcH
AAAQEgAATFpGdWwFMl8DAAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JPAfcCpANj
AgBjaArAc4RldALRcHJxMgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU
+xH/EwtiE+EUUBOyGPQU0K8HEwKAApEI5jsJbzAa3/plDjA1HAodIRzfHekb9P8eEhx/IE8gDR+P
Hb8cDxBg/DI4Jdom8SavJ7kb9CfivyZPKh8p3SlfJ48rVDkOUB8upDABKCMwAAKCc3R56mwHkGgJ
4HQAABNQA/BQZGN0bAqxXDJYYZhkanUxcAUQZ2gFQjsWMgwBYwnAMmADMHNufGV4FzAHsAWwAMAC
c3OxAFBzYjIUUDFgYRPw9FxrCeBwC5AyPzKjCGDrMpALgGUxoHY5YAFAM5u/DDA0ZCgAN0AEoAuA
Zyfx6TTmYmEXEGQCIDWgNUbnMdAzkDuRIDExMw5QNp//N684vwBROfwAoDRuPH89hv8xJA/APo8/
n0CvDlA570MP20QfPbMzAoITEGM2YEuhkzOQPbB0aTmQIEQBEKhhdWwFQFAKwGEJwOBhcGggRgIh
NiQlQOhmaS0PkDgBQDkwUDPrRw8yo2ILIHIJUFJSFqDZUlJ3NCVBFwBwAdBNcn8zv0qfS6ZP0E6Q
BRACMC1DTzADYTogVG9XsFModWJqBZB0V7BEYeh0ZTo2JDZP/1EPUh//Uy9UOTHAPaMOIUuhOrYO
UJtVb1Z+UjmBFwEgSD2R+wSQNiQ3WW9af1uPXJ05Dy9dvw+QaXAI0GIKsHQ4/0n6D1RGEF+/YMZq
AGHQC1C8eS9PQFywCxFiRXM2JP8oAGM/ZE9lX1yvVE9rX2xv7211V9JXdFipOW+/Mz8DMB1pszlz
n3SveqBEb2P+dQeAAjAF0E8AGgF40ngw93hwcVEBgG5YMABgCfBNoO99AAIBNeBeUmUA8H0AMYCS
cB6AXHYIkHdrC4D+ZGtAgKIE8AdAEGEBQA4A73EiPYKCBQIQbwVCFyES8g1YwG0LUVjAIEc6XAJc
BeBPRkZJQ0WdhLBPASAN4H/wXEUAwPUDEC5LcHR90BcQeHA1Ie1ncngBQH8BbjHQGvCGlD1ONGMD
IBLzAIAFkGx2/0GhRtAOcDXgiSIBkAAgibL/gPF9QQHBiSEW4A9wAABG0PMM0AGQIC4aEokYDlCJ
0v9OcHjAik+LX4xvD8BG0AWBt44Pjx+QL2xrQEbQbI3P+5KPk5UpjJwlQJFvlk+ThPhiICgCkZdv
iWNZUJUf/5nfmu+b/4mQYxCdQoofnq//n7+MnCgAnU+iz6PfpO+JkP94AKHPp1+ob6l0CvkDMHgv
03k/es17WQhgIAWgTmCZNSBydQOgk+BzcQMgxwT1Z3BGoCB0aAQACoUfCoWuNK7/sA8FQHtEReBM
RVRFIANSsmAHQNpsBCB3h8KzAGO2IKtB5nSwoYBRID098LTvtf/btw4KhVQW4AVAd7KDAQD/MaCE
YbjRtCETgKtDssAFkvhkcy66r7u/vM/AzGdwf6wywa/CvwjBNPI1oBLyYuhrbWu/1F99gAMQWKHo
YX0tyVJPsNELgAdA5wXQB5BGUGdlyVPAu66W/2L9byDFD3C/cc9nP2hPaV+fam+x1MdWV3MMgiBK
E2AVTyBIAxBsA4JbU02oVFA6sHBtC4AthgK70MAxcEABkLjwq1EuBaD8bV3K/8wEbrvNP85Pz1//
cr+xXAwhx2UGYAIw1eQaIoXHdE0CIGRheSx9cTZyFtBFYDTiwC/wOTeQIDk6MA6QQU3Atj/geVfR
4X2EEASQB0BkQPXmlS4IkGHY0uRP4QFYJZ/hfb/UAHA1IDFwb3DAJv/ZL67SxM/F398vsePD3+1/
U+6Pt7NJJ03xZ4NBb3Nh8UywNiwUUOqGwDUg4a7RbXkgQ7jTAZExoOGo4FNRTCm+0FiwPcKpSzBj
a7QgbwqFT/JwxUVgOONjNi4gfOG/j7sEIBcQck3xAHD2wHAIcPpwE2JhAYD1Afp062cKhdsW4AQg
Ygnh9NBiAZDQ0bc1IH9x+mRhB4C4sz/6IP++MP07BCAKwBOAF3AXIDGAriDvQA8wTmAsCoVi0KBs
IEm+0BDgJwVAtDFu//ig9FNh4gKCNSD6f/+D+/HTBDI94EFGuEBSBXIKhe/rSf5v53C0fEjyMLix
7SDfBYETcfWs/rDAIW304TUgyChpZvZwdCf7cfywz7QR+lBLcLMgbykAoQO1fwMFbZB9UQ6BgOC/
Yfvyb/cNwP0dAcB5FyAKTfFP8l8Ptx2F8OazRWAuMS413xMvFD8VT7ez97Eg+gBW4IMPcDWwVCA0
LjADBW5Bs3B/AX1xeBvA0sA0dCA1G+BBEry+MQRgc/8C9gMF1kr+Btak2FoSvBK8viDJUyRfJW8m
f8rXIBam+8jCPcJM2CH6ICl42BL7k35y5w6tcMfWHKLIuMC2fQIALfAAAwAQEAAAAAADABEQAAAA
AAMAgBD/////QAAHMODnjqh4OLwBQAAIMODnjqh4OLwBCwAAgAggBgAAAAAAwAAAAAAAAEYAAAAA
A4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAIIAYAAAAAAMAAAAAA
AABGAAAAAFKFAAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC4wAAMA
JoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAAAAAAAEYAAAAADoUA
AAAAAAADADCACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYAAAAAAMAAAAAAAABG
AAAAABiFAAAAAAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4AQoAI
IAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAAAADAAAAAAAAARgAA
AAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcAAEJm
------ =_NextPart_000_01BC3836.212B3340--