That problem sure looks like your content has grown to the point where searches by word are now taking too long, given the capacity you're paying for. You're...

That doesn't seem practical. I'd be asking why you're getting data in PDF format, when the vast majority of software programs out there have other output options. ...

I don't see why it couldn't be done, but it might peform like an absolute dog, due to either network latency and/or just the sheer number of rows it generates....

There isn't quite enough information here on which to base a complete answer. Are categories unique to specific users, or shared among all users? If...

The method remains the same. One still needs to identify whether or not a given record in Tbl1 has a "match" in Tbl2 or not, and if not,...

Forget homework. This problem, AS STATED, is simply not possible to solve. The problem is how to determine that any two given records are a matched...

I'd like to see the exact code you used to create the database. No need for any application code - only the specific statements needed to create the...

Oops... Looks like I messed up the quote of Jeff's post... my bad...

Steve

(aka smunson)

:w00t::w00t::w00t:

Jeff,

Thanks for the validation. Barry did kind of get back at what I was saying - there's really only one reason for this kind of problem - someone...

Don't be so surprised that you get called out for leaving ALL of us hanging about what to do with your post. What, exactly, were you expecting? ...

First, you were in way too much of a hurry for an answer, and second, you provided rather scant details on which to base an answer. Thus I...

I wish I could be more help, but I don't have Crystal Reports to test with. Any chance that your ID in SQL Server doesn't have CONNECT...

Jeff,

I think there's an inherent problem with "slapping a label on it", which does little more than both condone AND support the very worst way to go about things. ...

Jeff,

After 30 years of having to find ways to get data in or out of computer systems for almost every conceivable purpose, what I've found is that in every single...

My guess is he's tied the BorrowerParentID as a reference to the ParentID, and required that the ParentID field not be null, which effectively prevents you from entering any data...