Probably due to you not using an ISO standard for your dates.

Depending on the connection SQL will interpret dates differently, take '09/13/2012' is now in MDY format that works,...

Based on your original code and if you only ever have parts and labor then the below should work.

Not tested due to not having the DDL of the tables and...

What do you need the output to be

EquipID Location Cycles DateTimeStamp LaborAmount PartsAmount TotalAmount

JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 2237.5 27791.85 30029.35

EquipID Location Cycles DateTimeStamp TotalAmount

JRH-681 Daytona 2079347 2012-01-17 06:36:22.897 30029.35

Some other good things to read up on

Poor Performing SQL Part 1 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

Poor Performing SQL Part 2 - http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Stairway to SQL Server Indexes - http://www.sqlservercentral.com/stairway/72399/

Gail's articles - http://www.sqlservercentral.com/Authors/Articles/Gail_Shaw/148127/ -...

Performance tuning is a huge topic, is there something specific that is causing the majority of the problems or is it more of a general how do I troubleshoot this...

Its the beginning of the CTE construct, and acts much like a derived table.

Using Common Table Expressions

Wow a whole 43 minutes and a second between bumping the thread. Please remember we are all unpaid volunteers here and post within our spare time, so please be...

What is the reasoning on using BCP?

But if you have the format file and the data in a csv format, all you need to do is build a BCP command...

By default when importing from CSV XLS etc the source columns in the excel connection are set to 50 characters, you need to go in and change this to the...

The error relates to truncation so your trying to insert CHAR(100) into CHAR(50) for example, find the maximum size of the data in the column detailed and then increase the...

It should run as NT AUTHORITY\NetworkService by default not NT AUTHORITY\LocalService. The two accounts have slightly different permissions.

When the fault happens is there any fault with DNS or AD...

By default the browser runs under NetworkService so unsure if changing it other may have some adverse effects or not. One to investigate further.

Uou need to capture then 1 second apart then minus the figures, as the counter value is cumulative.

Are you running the browser as a domain account or as network service?

dispicable