As the others said, I would do the conversion in the front end and then pass the datetime value to SQL Server

A quick search brought up this for example:

http://www.dotnetspider.com/resources/4500-Convert-string-DateTime.aspx

Good article. Well said.

Elimitate NULLs either in the WHERE condition of the query (SELECT .... WHERE email_address IS NOT NULL) or...

ALTER TABLE Customers

ADD CONSTRAINT LimitRule

CHECK (CustomerLimit <= (SELECT MAX(Limit)

...

Yes, right. I copied it out of my (home made) scratchpad and simplified it a bit for easier reading. Obviously this was...

I am using a SQL Scratchpad form for executing all SQL commands via ADO (much better SQL support than through the Access UI)

If you pass CREATE TABLE .... ; followed...

DATEADD(month, -1, CURRENT_TIMESTAMP) resp DATEADD(month, -2, CURRENT_TIMESTAMP) and then convert back to your year_month format.

If I understand correctly, you will need a calendar table which you can join to any DATE or DATETIME column and return the year_month portion accordingly

CREATE TABLE Calendar

(calendar_date DATE NOT...

It is a matter of taste but usually people are not expecting to find a comma at the beginning of the line in a normal text, so putting the comma...

Nice one! Why building a complicated database with lots of tables when we can jam everything into one table? 😉

Untestest

SELECT *

FROM

(SELECT RANK() OVER(PARTITION BY CustID...

You might want to look at the well known ISO 3166 standard for country codes and for locations at the UNECE Locodes which you can find here

http://www.unece.org/locode/

It is always a...

You are welcome! 🙂

First I thought, this question would possibly be too easy for the readers, but apparently this was not the case. Presently just 52 % correct answers, where I expected abt....

From a logical point of view the message

"Warning: Null value is eliminated by an aggregate or other SET operation"

is quite good as NULL might mean unknown, not applicable or optional...