Forum Replies Created

Viewing 15 posts - 106 through 120 (of 190 total)

  • RE: Defining Criteria - WHERE clause

    ramya.he (8/7/2009)


    dgfghgf

    Thanks for your insightful reply. Exactly the SQL syntax I was looking for. Works like magic under my where clause! 😎

  • RE: Using CURSOR

    never mind. problem solved, dont need to initialize it, maybe Lynn meant something else and i confused it. sorry for the hi-jack.

  • RE: Using CURSOR

    ta.bu.shi.da.yu (8/6/2009)


    No need to.

    Just run:

    set @value = 3

    exec dbo.dummystoredprocedure @value

    print @value

    where dummystoredprocedure has some sort of NOP (e.g. select 1).

    You'll see that the value after the exec doesn't...

  • RE: Using @@Rowcount for storing multiple updates/insert counts

    GSquared,

    In another post, I saw Lynn say that the variable needs to be initiliazed to zero (0).

    My concern is, does the variable have to be initialized after every update/insert? meaning...

  • RE: Using CURSOR

    Yes, I am calling another stored procedure from within a stored procedure. I can't actually run any of the updates and inserts at this point so can't do print. Though...

  • RE: Using CURSOR

    ta.bu.shi.da.yu (8/6/2009)


    Slick84 (8/6/2009)


    Lynn Pettis (8/4/2009)


    I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.

    How would you initiliaze...

  • RE: Using CURSOR

    Lynn Pettis (8/4/2009)


    I may have missed it, but you will want to ensure that @RESULT is initialized to zero (0) before you start the update.

    How would you initiliaze the @result...

  • RE: Lot of time takes for Excution of small query

    Suresh,

    You could use SQL profiler to set a trace and run the select query. It should give you some helpful information.

    Thanks,

    S

  • RE: Defining Criteria - WHERE clause

    That's true Matt. That was exactly the reason that threw me off and got me confused. So I did use parentheses in my next statement. In the first update I...

  • RE: Defining Criteria - WHERE clause

    Aah... you know what.. I think I have this figured out. I was trying to update Table B above, I just used AND's in the criteria and then added another...

  • RE: Data Insert timings

    Jack Corbett (7/29/2009)


    It Depends on the servers, the network, and activity. I'd be more inclined to use bcp/bulk insert or SSIS to do something like this.

    BCP utility would be...

  • RE: Does Maturity Make a DBA?

    mtucker (7/28/2009)


    Lynn Pettis (7/28/2009)


    Unfortunately, rational thinking isn't the end all in solving problems. Many times I have found solutions. not through rational thought, but through inspiration and imagination both...

  • RE: Does Maturity Make a DBA?

    sashikanta.mishra (7/29/2009)


    Hello Gail,

    I do not agree that Brad will get more hate mails as this is his individual research and thought.

    But speaking through the relation of nature of...

  • RE: Does Maturity Make a DBA?

    Robert.Smith (7/27/2009)


    Self-congratulatory bollocks.

    Pick almost any career (architects, police, trades, heck even pot growers) and the people doing it will claim to be stable, family-oriented, hard-working, community-minded.

    Robb

    Thats true.. and hilarious :w00t:

  • RE: Does Maturity Make a DBA?

    Lynn Pettis (7/26/2009)


    Slick84 (7/26/2009)


    So how about a DBA who does not possess those qualities and does not qualify the criteria you have laid out? What's wrong with them? If I'm...

Viewing 15 posts - 106 through 120 (of 190 total)