Let me emphasize that the number of rows returned is the same and the counts match in the GROUP BY example, the DISTINCT example, and in the temp table example.  Its the...

I get similar funny results using Enterprise Manager to run the query from the Open -> Query menu option.  OSQL too.

I tried removing the order by clauses and that made no...

Thanks for the feedback so far.  I'll try to clarify the situation.

We are running SQL Server 2000 Enterprise Edition SP3.  I used Query Analyzer to run these queries.

The original GROUP BY...

That may be a good QOD. 

There are headers in each file.  One can guess that once a file was written as a backup set with one member then the headers...

Be sure to include the USE <db> command in each script or set your default database for each window before running the scripts.

Using Visual Studio 2002/2003 is even better.   You...

There also is some contradictory documentation on the number of actions, etc.  This page specifically states that no more than five sql batches can be run.  Maybe the other actions...

Wow!  That is quite unexpected.  Can anyone explain the logic or history of designing the function this way?

Is there any way to properly determine the length of a string?  There are...

An excellent article that meets its stated goal.  The explanations are well stated and allow for other points of view and discussion.

I especially appreciate the pointers to the knowledge base...

The question said that you "you did not specify the correct mail server". 

In order to change that, you'll have to change RSReportServer.config. 

Is there some reason to change RSWebApplication.config? 

If...

MSDN seems to indicate that rsreportserver.config is the file that contains this setting.   See:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_configserver_v1_4bzl.asp

It appears that rswebapplication.config just tells Report Services that there is an e-mail extension installed but it...

The article is a good summary, but the fact that it covers SQL 2005 leaves me wondering how relevant it is. 

Come back in nine months and it may be more...

That previous post is correct.  The AFTER trigger executes only after the entire SQL statement has executed.  The INSTEAD OF trigger executes instead of the SQL statement.  SQL Server triggers are...

Of course, SET DATEFORMAT could also be used to change the default date format. I don't know what else changes when SET LANGUAGE is used.

I would have liked to have seen a performance comparison against a more logical approach using a function that didn't return a list but the figures for a given day...