|The Message text:
This email was created by [your name] who thought you would be interested in the following Article:
"JOIN Instead of Repeating a Subquery"
As an alternate, I would like to share the following query using the previous table definition using RANK:DECLARE @FirstTable table(FirstName varchar(20))DECLARE @SecondTable table (ID int, FirstName varchar(20), LastName varchar(20), FirstNameHashCode varchar(20), ...
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!