SQL Queries Advice for any programming language

NOT NOT NOT an ASP.net group go to
[AspNetAnyQuestionIsOk]
if you have ASP.net questions

This list is to discuss primarily the SQL Query you are activating in your code including easy, medium, hard SQL Queries:

• "Select ..."
• "Insert Into"
• "Delete ..."
• "Update ...."
• joins, Actions, DDL, Aggregate, Multi-Table, Cubes, OLAP, etc.

and is NOT NOT NOT really about debugging or including the ASP, ASP.net, ColdFusion, VB, C# or whatever code that calls ro consumes that query.

GENERALLY we want to see the SQL statement only, not all the surrounding programming code since we don't want to become a code-debugging lists - there are plenty of those.

To paraphrase Joe Friday from Dragnet
"Just the SQL Please"

If possible we don't talk about Stored Procedures or Packages because they are DBMS specific (SQLserver and Oracle respectively) but if they are the most efficient way to get results we will discuss them.
We are not really an Oracle, SQLserver or Informix, etc. specific support list so as questions drift from SQLqueries into issues peculiar to only those specific database platforms, we suggest those questions occur on DBMS specific lists not these.