That's pretty buggy - I just saw the behavior you're mentioning.  That's pretty sick.

The non-visual "parse" feature in the "new query" window doesn't seem...

Have you run that query directly on the progress server?  Meaning - is the error a Progress error (like - the amount of the Total is too large for the...

<post traumatic stress disorder disclaimer>

My eyes go buggy every time my ears hear the phrase "Lotus Approach".  It probably had something to do with having to field support calls on...

then it's not understanding that the <fkfield> you're talking about is supposed to be coming from the outer query.  force it with the table names in the sub-query.  If need...

Generically - assuming you can "see" the VLAN from machine off of the VLAN, then yes.  Of course - one of the big reasons to use VLAN's these days is...

Like Steve was pointing at, you should probably start with just simply drawing out your data "areas" (might be tables, might not be).  Don't specifically worry about specific data fields...

In order for this to work - the sub-query really would have to return only one record matching the outer query.  Have you double-checked that there are NO instances where...

select into assumes a new table (meaning table2 doesn't exist ebfore that statement.) No, it's not the same level of effort - that does make it easier (no existing records/page splits,...

Just go straight for the open license.  If you have the paperwork on file stating you have *paid* for the right number of licenses - microsoft isn't going to much...

I've run CONTIG against my own machine with MSDE running, and it defragments quite well even with the DB's in use.  I don't know how great it is against a...

Agreed.

Only thing that might make a tiny improvement would be to not force the execution plan to go out and find the fields names.  By not specifying the column names...

These guys describe it much better than I could:

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html

Garbage collection is about the same in every program.  You could let the regular process do it, but it is often...

yes, but don't forget the CROSS APPLY predicate.  That takes the contents of the XML field in each row and treats them as if they were multiple rows (which conceptually...

Look into doing that as a dynamic SQL statement which you would build on the fly  Doing it that way - you could parameterize the USE statement to point to...

When you create a link to a table from within Access - Access will often ask you what the primary key is (if it can't determine what it is on...