If you're importing from an .MDB file, use the Jet 4.0, not the ACCDB nightmare. The Jet one actually works.

Check the server collation value. It could be case-sensitive.

http://blog.sqlauthority.com/2007/04/30/case-sensitive-sql-query-search/

http://stackoverflow.com/questions/14270993/case-sensitive-variable-names-in-sql-server

Christopher Adamson's Star Schema: The Complete Reference is really good. It's database agnostic, but he does a really good job of explaining concepts like Slowly Changing Dimensions and how to...

IBM's version (for want of a better word) of SSIS.

Eric,

I go to the user group meetings the vast majority of the time. Hard to argue with free training where you can ask questions. =)

Maybe my problem is that talent...

Apologies for baiting a troll, but one thing that would scare me about using Access/Jet for any important database is data security. I worked in healthcare for a while,...

John,

Good point. The hard part for me is the "can't get a job without experience, can't get experience without a job" conundrum.

I did write one not terribly complex database...

I think this is the answer:

https://social.msdn.microsoft.com/forums/sqlserver/en-US/138fc2df-ff40-42a5-adc1-1b3f728737c2/sql-query-permutations-without-repetition

what database engine are you writing against? HeidiSQL?

"If i try to run it against the database server using Heidi sql."

Is this a SQL Server database?

If you're using SQL Server, I would look here... just because it's a...

Exercise your Google-Fu.

Here[/url]'s one.

If you google it, you'll find more answers than you can shake a stick at.

Maybe start here:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

and maybe this:

http://spaghettidba.com/?s=how+to+post

Look at your question from our perspective. How are we to test any of it? Without data, we can't. If you set up the...

Got some table definitions and some fake data? (Fake if it's confidential... representative is fine). And expected output?

Why do you want to use cursors for this? "Cursor" is a dirty word around here. You could probably do all this with either aggregate or window functions.

If your goal is to show all the sales from the latest sale date, then no.