Oh, and I forgot. Always, always make sure you are on Access 97 SR2. Prior to that there was a memory allocation bug, which sooner or later let you run...

There are 6 other steps to this function that run through 'Do Loops'.  The first 'Do Loop' works fine and makes all the updates, but everything after that comes...

There is a whole bunch of information on this topics available in BOL. Too much to post here. I would start at 'space allocation' in BOL and work through the...

Okay, but in most cases you run into problems when trying to JOIN on datetimes that still have the time portion.

...but it isn't better in any other professional area. Only more or less interesting

create table rr(s varchar(1) null)

varchar(1) ???

This is only an example, right? If not, you should change it to char.

In EM that should be easy. Simply right-click on the server in question, edit the properties of that registered server and uncheck the 'Show system databases and system objects' option....

No problem!

Although it does seem so, I'm not totally against the use of dynamic sql. There are cases with very complex searches where you are better off with dynamic sql,...

Yes, that's another big issue!

Float and real are imprecise data types. That's their nature. I think they are relicts from the times times where storage space was a huge issue....

So, is there still aproblem or it is solved as you say you can execute the query?

hey, hey, this is a reply using Mozilla Firefox (I like the name Firebird more)

No nice emoticons, but therefore much faster.

Strike!

You should always try to convince your company to pay for you.

...after all they do profit from your expanded and proven...

Instead of the ol' EDIT how about vi!!! 

Aah, glad you've mentioned the one and only true editor around

Still trying to get...

Do you have any suggestions that could help me learn more about these issues? 

First of all try not to mimic some kind of Excel Pivot table stuff in SQL Server. You...

Hey noeld, that's my reference link

Actually, although both URL are the same you'd better use this one http://www.sommarskog.se/dynamic_sql.html

It's easier to remember...