Reported as spam.

Reported as spam.

Reported as spam.

Generally when working with DATETIME data, you want to use half-open ranges.  That is, you want one end of the range to include the endpoint and the other end of...

First, I said you should post CONSUMABLE data.  An Excel file is not consumable.  You should reread the first link in my signature.  Furthermore, people are hesitant to open Excel files...

This is actually a fairly easy number to calculate.  It's a variation on n choose k.  The first digit can be any digit except zero.  The remaining digits (k) can...

First, if you want to find missing foreign key values, you need to start with the source of your data, not the target of your data.

SELECT...

We can't tell you what is wrong with your query if you don't provide your query.  You should also post data in a CONSUMABLE format.  That is, post a script that...

Reported as spam.

It's pretty much what it says.  Your table has a foreign key constraint and your insert is violating that foreign key constraint. You have one or more records where the...