Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause?
Here are links to a two part article that I wrote last year for SQLTeam on the subject of Upgrading from SQL Server 7 to 2000.
Emerald City Domains
RSS