The "Track Name Changes" option has been known to slow down Access as well.  You can turn it off under the Options Menu | Current Database.

The short answer to this is no.  You cannot directly import the EDI file into SQL.  EDI is hierarchical, more similar to XML than it is to SQL; EDI requires...

If you write out the truth table you'll see what is going on:

Color     Country    Color<>'Black'    Country<>'USA'
Red ...

Instead of:

select [col1], [col2] from Customer

where BranchId = CASE when @BranchId IS NULL THEN BranchId else @BranchId end

I usually go with

select [col1], [col2] from Customer

where (@BranchID is NULL OR...

IceDread,

I'm not sure what you're disputing here. Are you saying that the fields I listed are not different, or that the article and comments do...

The essay and the comments conflate too many things.

Computer Science is not programming, is not Computer Engineering, is not IT.

Computer Science is the field of mathematical analysis of algorithms, languages,...

I want to put a slightly different slant on my answer.

From the point of view of "value to the company" OF THE SALARY, a salesperson who is out in the...

I prefer AS for aliasing because I think there is a semantic difference between = and AS. = implies an assignment--copying a value into a new place, while AS...

It appears that this will not work in January:

If your AsOfDate = '2011-01-02' you will return 'December 2011' instead of 'December 2010'.

When I am doing something like this, I try...

I think that obfuscation of data is useful to prevent inadvertant disclosure. Most of the time I don't need, or want, to know the "real" data. I just...

I have to transfer data from Access 97, where Memo field uses Double-byte encoding. If you are using recent versions of Access, then your Memo field must be using Unicode,...

Use the 3rd parameter of CHARINDEX to ensure that the </t2> you are finding is AFTER the <t2> that you find.

e.g.

CHARINDEX('</t2>',stringtosearch,CHARINDEX('<t2>',stringtosearch))

--

JimFive

I would like to...

Access Memo fields are equivalent to SQL nText data type. If I were doing this manually, I would bring it in to an nText and then copy the data...

I want to preface this by saying that I've not looked at this problem before and I'm sure the below is well known, but it is a fun little problem.

...