Oh definitely, the far preferred method would be to use the Select sum(fieldname) from table. The point of this whole thing is far greater than that.

The code above is...

Wasn't sure if you wanted the indexes at all. Here they are

CREATE CLUSTERED INDEX [SITE_C_1] ON [dbo].[SITE]([Site_Addr_St_Name], [Site_Addr_St_Num], [Site_Addr_St_Suff], [Site_Addr_St_Post_Dir]) ON [FILEGROUP4]

GO

CREATE UNIQUE ...

Matt I totally understand what you are saying. Actually what I am going to do next is an average of several runs against the data to get a better...

Ok, so for the fun of it I tried to add a Primary Key Clustered in my in memory table. The difference is substantial

New times for the while loop:

100...

Good point on the SQL 2000 vs SQL 2005. My first attempt was against 2005. I tried again against a sql 2000 database and came out with very...

Don't have time to go through all 15 pages of posts, but I fail to see where this is quicker on larger datasets.

For instance I just performed a similar operation...