If I understood the question correctly, no, you don't create any structure in the Access. You just create an empty Access database, and instead of creating tables in it, you only...

This is one of possible structures for similar purposes (simplified). It is based on the condition, that every question has a predefined set of answers (no "explain in your own...

As far as I can understand it, you have a player (person.ID) and club. The query should find all matches of this club in which the certain player has played,...

Looks very similar as a copy of Access table when pasted into a wrongly formatted Excel sheet (number instead of date). Didn't try it, but I think the same would...

Can you call a function? If yes, just put all the logic of finding the limits from-to for each chunk of data into a function and call it in the...

I would suggest to use CREATE TABLE statement followed by INSERT INTO instead of SELECT INTO. However, if you don't want to do that, there is one way to allow nulls...

The restore process is quite well manageable in SQL Server, so that really none of the options is too complicated. I merely wanted to point out the fact, that it...

We are making a full backup every night, and transaction log backups every hour during night and every 15 minutes during day. Both file and log backups are stored for a week...

Is OrderDate a datetime column or is it character (char, varchar) datatype?

If it is datetime, then try David's suggestion (you should always use this unambiguous format to avoid problems...

We've had a very similar post here recently (about aliases when updating), but I'm not so sure this is the reason. You should use aliases once you start with it, but sometimes (especially...

Yes, this is one of the things you can not do in SQL. However, I wouldn't say that it shows its weakness - it merely shows that SQL works differently than Basic...

Dimitri,

not sure how you mean that... but COALESCE is principally identical with ISNULL in that it replaces NULL value with some other. COALESCE allows several parameters while ISNULL only 2, but...

Hi Mick,

"I've tested the variable and it seems to be growing in length, it has a lot of spaces adding to the end of the variable"

Do you know why your...

I have only a few minutes so I can't test it, but something along these lines should work. You create the "full" rowset (without missing records) using cross join, use it...

Hello,

you didn't mention whether you are working in QA or launch the scripts some other way... maybe your SQL fails, but you don't see the error message? If you run SELECT...