Is Query Analyzer different from SQL Server Management Studio?

Which leads to the next question. Who are Rafael Nadal and Roger Federer - not to mention James Franco? Guess I need to start reading the magazines in the supermarket...

You might check to see if IBM i Access is installed on the server (or wherever the package actually runs). Minimally, you'll need the DB provider installed.

W/D

Why don't we let T-SQL be the judge:

SELECT

'Test1' = CASE

WHEN DATEADD(day, -1, GETDATE()) = GETDATE() -1 THEN 'TRUE'

ELSE 'FALSE'

...

Your off-hand comment about naming the field "Gender" rather than "Sex" piqued my curiosity. Why? As I understand the words, sex means biological differences: chromosomes and sexual organs. Gender refers...