Viewing 15 posts - 1 through 15 (of 34 total)
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...
July 7, 2010 at 10:43 am
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...
April 29, 2010 at 8:28 am
Isn't the snapshot isolation level used in SQL Server 2005? I am working with 2000.
March 5, 2007 at 11:28 am
mngong - What exactly is the snapshot isolation level and where would I change that?
March 5, 2007 at 11:03 am
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...
February 6, 2007 at 2:36 pm
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...
January 3, 2007 at 7:34 am
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...
November 16, 2006 at 12:25 pm
The projectId doesn't matter because this is a staging table all of the records have the same projectid.
August 31, 2006 at 12:35 pm
kmlakov - I didn't understand your post. Can you please retype it?
August 25, 2006 at 11:06 am
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)
...
August 25, 2006 at 11:04 am
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...
August 25, 2006 at 10:58 am
Viewing 15 posts - 1 through 15 (of 34 total)