cbrammer1219 (6/14/2014)
Tell me about it I have told them before any projects are started the data needs cleaned up, these tables don't even have Pk or fk, they b Ave me joining on tables with no relation at all and I try to tell them they are reporting incorrectly. They won't listen. You should see the customer and contact tables, there is no data validation when input to the database. It's a nightmare. ...
The thing I learned SQL on was CDRs so I feel your pain on this. Have they provided you with a Record Layout that you could share? I think it's really important because you missed the data in the file that starts at character 165. I also think that the record layout would contain more information about what the infamous Col05 contains so that we could pull off the perfect split for you. It would also help us define what the PK needs to be so that you can check for duplicate calls, which AT&T and most of the other "Biggees" are nortorious for providing.
--Jeff Moden
Change is inevitable... Change for the better is not.