
Serious help needed w/ huge complex DB
Okay, this thing is getting way out of my league. I had this huge
production data/scheduling DB dropped in my lap for
rejuvination/modification, and it has gradually become a patchwork of
temporary fixes, etc. I'm sure you're all familiar with this.
Anyway, I'm having all kinds of problems w/ this one report excluding
particular groups, and I've had a lot of difficulty tracking down what the
conditions are that make it happen. At first, it was whenever one
particular field was null, but I believe I fixed that, and now it seems
like this report randomly leaves some groups off the report. I think that
this db is far too complex (unnecessarily so, I'll freely admit) to explain
what the possibilities are. I've been adding queries and procedures for
about a year to fix these things that come up, and now it's just crazy.
I can send either the full size db (about 20 megs) or a skeletal structure
only thing to anyone, with a much more detailed description of what's going
on to anyone willing to lend a helping hand with this. I also have a toll
free number if anyone has the time to talk in person. I REALLY need help
with this thing, and any effort would be GREATLY appreciated. This group
has been an invaluable source of help for me thus far, and I hope one or
some of you guys will have the time or patience to help me out.
Thanks in advance.
Jesse Scott
800-221-1356 X4430