Forum Replies Created

Viewing 15 posts - 1 through 15 (of 34 total)

  • RE: incremental data loading

    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...

  • RE: Do I need a cursor?

    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...

  • RE: DeadLock issues

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

  • RE: DeadLock issues

    VB.net

  • RE: DeadLock issues

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

  • RE: DeadLock issues

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

  • RE: AND/OR Logic

    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...

  • RE: Changing an empty value to NULL???

    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...

  • RE: Truncating Transaction Logs

    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...

  • RE: SQL Server 2000 and 2005

    They are both on the server.

  • RE: Validation queries running too long

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

  • RE: Using Bulk Insert with SQL Server 2005

    The link isn't working.

  • RE: ActiveX scripts and files

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

  • RE: ActiveX scripts and files

    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)

    ...

  • RE: ActiveX scripts and files

    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...

Viewing 15 posts - 1 through 15 (of 34 total)