I can keep track of each load with a LoadId.

I work for a call center and we track employees time. An employee can be on the phone, or waiting for...

Thank you so much Paul. Your function did excatly what I needed. One thing though, I noticed you are hardcoding the following:

This.LoadId - 1

The issue I have with this is...

Thank you so much for your help. I'll try it.

VB.net

Isn't the snapshot isolation level used in SQL Server 2005? I am working with 2000.

mngong - What exactly is the snapshot isolation level and where would I change that?

One more thing I forgot to add.... These are the variables being passed:

@sStatusAll (0 If not selected, 1 if selected)

@sStatusPending (0 If not selected, 1 if selected)

@sStatusInReview (0 If not...

The problem is that the sSIM value is not null, it is an empty string. Is there any string function that can convert an empty string to a NULL so...

Excuse me if I sound stupid, but I'm not a big expert on this subject.

I am using the following statements to reduce the log:

BACKUP LOG [dbname] WITH TRUNCATE_ONLY

DBCC SHRINKFILE...

They are both on the server.

The projectId doesn't matter because this is a staging table all of the records have the same projectid.

The link isn't working.

kmlakov - I didn't understand your post. Can you please retype it?

If I type what works in the command prompt:

C:\>"c:\program files\winzip\wzzip.exe" c:\test\at0123.zip

into query analyzer:

DECLARE @result int

USE master

EXEC @result = xp_cmdshell '"C:\Program Files\WinZip\wzzip.exe" C:\test\AT0123.zip'

IF (@result = 0)

...

The only way it works for me is I do it like this:

1. Connected to the server that this code will be running off of.

2. Saved the excel file to...