Could it be that the Email column in DB1 is shorter than the email address you're checking and it's being truncated?

Most years I take a long June weekend at the Download festival in Donington (the home of heavy rock), relaxing, drinking beer and listening to music amongst like-minded people. In...

It's a good point, however, that a company's financial periods don't necessarily align exactly with months. In some companies there is a period 13, for example.

It's not just size & resolution that matter. A few years back our department started using a WinForms product for development and, if so configured, it could allow the user...

"One size fits all" could work if it applies in both directions. We are currently in the process of replacing a bespoke system with a package. The bespoke system allows...

I agree with the use of stored procedures for all the reasons mentioned in the article and, because I was on the standards committee, managed to get this included in...

As you now know the application is hitting a timeout, you could set the timeout on the SQL command to a higher value than the default (30 seconds). In C#...

From what I remember (it's been a while), C# treats all SQL date datatypes as its own DateTime type and you have to specify the display format in the data...

I'm doing a major implementation of cross-platform changes this evening - tempting fate?

Depending on the product used for the presentation layer, you may find the column names will be prettified automatically. We use DevExpress and it separates the words in a CamelCase...

As an aside, I'm pretty sure you won't want the amount to be FLOAT as this will not give exact results in calculations.

One other thing to be aware of is that EXCEPT eliminates duplicates.