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
© Ajarn Mark Caldwell
Theme by PiyoDesign. Valid XHTML & CSS.