Click here to Skip to main content
Click here to Skip to main content
Search within:



Articles » Database » Database » General » Downloads
 
Comments & Discussions

JOIN Instead of Repeating a Subquery

By , 2 Feb 2011
 
No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of use and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

About the Author

 AspDotNetDev
Web Developer
United States United States
Member
  • Managing Your JavaScript Library in ASP.NET (if you work with ASP.net and you don't read that, you are dead to me).
  • Graduated summa cum laude with a BS in Computer Science.
  • Wrote some articles and some tips.
  • DDR ("New high score? What does that mean? Did I break it?"), ping pong, and volleyball enthusiast.
  • Software I have donated to (you should too):
About Article
Rather than use multiple subqueries to extract TOP 1 data, this shows you how to use a single TOP 1 JOIN.
Type Tip/Trick
Licence CPOL
First Posted 21 Mar 2010
Views 8,119
Bookmarked 10 times
Top News

Old Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)

Get the Insider News free each morning.
Related Videos
Windows 8: 2D Brushes Part 3
Splitting and Joining Strings
Best Practices to tune up T-SQL and SP
Controlling the XML output when using the FOR XML AUTO statement in SQL Server
JOIN Instead of Repeating a Subquery
Paging of Large Resultsets in ASP.NET
Understanding “Set based” and “Procedural” approaches in SQL
SQL:Target a SubQuery
SQL Server Indexed Views - Speed Up Your Select Queries: Part 1
SQL Joins and Subqueries
Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)
Efficiency of Subqueries and OR conditions in SQL
A scripted SQL query generation framework with IDE: SQLpp (v1.4)
LINQ Challenges and SQL Server Compact Edition
Inside Recursive CTEs
Concatenate Field Values in One String Using CTE in SQL Server
An introduction to LINQ for db4o
Repeater within Gridview in C# ASP.NET 2.0
SQL Server Performance Impacted by New Features
Common Table Expressions(CTE) in SQL SERVER 2008
Windows NT Win32 Perl Programming: The Standard Extensions - Chapter 7: Data Access
Calculating simple running totals in SQL Server
Permalink | Advertise | Privacy | Mobile
Web02 | 2.6.130523.1 | Last Updated 3 Feb 2011
Article Copyright 2010 by AspDotNetDev
Everything else Copyright © CodeProject, 1999-2013
Terms of Use
Layout: fixed | fluid