Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 7,636 total)

  • RE: Are the posted questions getting worse?

    GSquared (3/9/2009)


    RBarryYoung (3/7/2009)


    As Woody Allen once said:

    "I'm not sure I want to join any club that would have me as a member."

    Either he stole that one from Groucho Marx,...

  • RE: help on xml schema

    By the way, If you really want to put the XML in your post, you can use one of the following methods:

    * Replace all "<" and ">" with "["...

  • RE: help on xml schema

    What have you tried? And what has happened when you tried it? (tell us the error message if there is one)

  • RE: insert data into multiple tables

    Good point, Jack. I had assumed that CaseID was Ok in the table since it appears to be set by the procedure, but it's not necessarily so. Best...

  • RE: Bulk insert

    Hmmm, yeah that's quite a bit different from what I usually have to do: loading daily extracts. Very regular, very stable. Much more suited to permanent staging tables.

  • RE: Using Cursor to retrieve multiple table data to return as dataset

    It is not really clear what you are trying to do or what your question is. Please read the following article on how to get better answers to your...

  • RE: help on xml schema

    We cannot see most of you schema, because the security on these forums will filter out most text that looks like XML or HTML. Please post your XML as...

  • RE: insert data into multiple tables

    Check for triggers on the AssetTracking table.

    You may also find that you will get more responses if you bother to format your SQL code a little, like your VB code...

  • RE: sql server 2005 xp_cmdshell

    The NULL is the blank line that the command shell is printing. It is not coming from SQL Server or the xp_CmdShell procedure, it is coming from DOS itself.

    If...

  • RE: Bulk insert

    Jeff Moden (3/7/2009)


    I'd recommend that you never import 3rd party directly to permanent tables. I always do the imports to temporary staging tables so I can validate the data...

  • RE: Are the posted questions getting worse?

    As Woody Allen once said:

    "I'm not sure I want to join any club that would have me as a member."

  • RE: Activity Monitor

    You would need to write your own activity monitor for that.

  • RE: Lets help the experts help themselves

    GilaMonster (3/7/2009)


    t.walker (3/6/2009)


    I really support that idea. I think a more private invited members forum would enable me to speak more freely/

    Just one question. How would you determine who's allowed...

  • RE: Lets help the experts help themselves

    t.walker (3/6/2009)


    I really support that idea. I think a more private invited members forum would enable me to speak more freely/

    Although I am a rookie here, I am also a...

  • RE: Update values within trigger

    GSquared (3/28/2008)


    rbarryyoung (3/27/2008)


    GSquared (3/27/2008)


    Joe creates an order in the Orders table: CreateBy = "Joe"

    Bob updates the order and changes the price incorrectly: UpdateBy = "Bob"

    Sue updates the order and changes...

Viewing 15 posts - 3,481 through 3,495 (of 7,636 total)