Did you try the ESEUtil program that comes with exchange?

http://blogs.technet.com/askperf/archive/2007/05/08/slow-large-file-copy-issues.aspx

Had already done that.

No difference.

5.23852944873328E-32

Hey Jeff,

I just tried both examples (in 2005, not 2000) and everything matched up perfectly to the hard-coded values. Why is that?

Does your program check the database itself for rows that may have been inserted previously?

If it "can't happen", I am guessing not.

That being said, what triggers the VB code to...

I wasn't sure if assumption C was correct and that you had checked the database itself and there are no duplicates there but I went back and added a second...

All true.

To answer his question, though, if:

A. Data is only transfered to the database via the program and

B. Logic of...

There may well be a better way but I just thought I would, finally, get a chance to play around with something I saw, recently, in another post:

set nocount on

create...

As to why it's happening... no.

I would try the code I put above to nullify @@DATEFIRST

These all return the same value in the second field:

set datefirst 1

select datepart(dw, getdate()), ...

Something like this should work (change your table and field names, as necessary):

SELECT s.*, p.ProductName, t.TotalSales --Might as well include the group total

FROM SalesLineItem AS s

INNER JOIN (

...

Check the DATEFIRST variable of the server you deployed it to.

WHERE

DatePart(WeekDay,[Date]) = 6 -- 6 may not really be Friday

Be careful, something may...

If need be, I guess I can move things to a stored proc and maybe cobble some validation on the back-end to be returned through the dataset and then group...

Are you sure you need a military time conversion?

Will datediff( minute , @startdate , @enddate ) give you what you need?

You can do:

Select

Case

When ActionType in ('TMA','TMB','TMC') Then 12345

When ActionType in ('TMD','TME','TMF') Then 54321

Else 0

End

I only briefly scanned your post but SELECT INTO only works for the first loop through. That command is used to build a table, on the fly, where the table...