I am writing a query which is aggregating some data from one database into a separate database.<BR><BR>Basically, I have a query which returns 3 columns and I have a query that returns 1 column ...

SQL Basics I: Data Queries—covers database terminology and the four basic query types. SQL Basics: SELECT statement options —covers the SELECT statement in detail and explains aggregate functions.

That's great for speeding up processing the next time that query shows up because the plan for the query can simply be pulled from the cache. However, there are any number of queries in any ...