Only way that could happen is if group_sec doesn't exist...  what do you get when you run the following?

SELECT COUNT(Group_Sec) FROM TestTable

They do the same thing where I work and it drives me nuts... what's the purpose of an archive?  Right... to move infrequently used data out of the way for...

Using a cursor to do a simple "UPSERT"??  You an Oracle programmer, Simon?

Real answer is... don't use a partitioned view.  SQL Server can handle huge tables.

Here's the schema you posted...

CREATE TABLE [dbo].[IISlog] (

 [date] [datetime] NULL ,

 [time] [datetime] NULL ,

 [c-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [cs-username] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [s-ip] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS...

I still want Brian to tell us what the EXE does and how many rows per call it's going to handle.

I'm thinking in the SQL side but could probably also be done on the ASP side.  In either case (sorry about the pun), financial calculations should probably not have general...

Yep... you're correct... require a particular format.  I recommend TAB delimited files so that quotes and commas can be included as part of the data, if the customer desires.

And, I'm...

How'z that work Peter... sounds interesting but also sounds like it might be a cursor and I'm thinking I know you better than that...

[EDIT] Oh...

What does the EXE do?

Macro that executes on load and reexecutes every 10 seconds should do it

Dinendra,

First, don't even think cursor... especially not for this size table...

The following is fully programmable...

You need to use some CASE statements, at the very least.  Accounting functions are way too important to trust defaults.

Even if the perfect indexes were present, it's not likely they'd be used because of the calculations on columns in the WHERE clause... there's even a UDF in there...

"Hopefully this...

You might also want ot learn how to use OSO-11179 naming rules

Yep... especially when it comes to...