Forum Replies Created

Viewing 15 posts - 2,176 through 2,190 (of 3,232 total)

  • RE: Passing expression to an stored procedure

    The exact thing the developer is trying to avoid doing here is the way to do it.  Why would the developer want to avoid creating a variable to hold this...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 2, 2007 at 1:16 pm

    #724307

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Well, rewriting your work Set based is a bit of a chore without having your core tables, views, and data so please take any work that...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 2, 2007 at 12:19 pm

    #724293

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Yes, I understand this part as the code is coded this way, but I thought the purpose of this SP was to get the next level if it exists.  Wouldn't you...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 1, 2007 at 4:44 pm

    #724023

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Yes, that makes perfect sense to me.  Amazingly, this is what I gathered from reading your code.  But the problem is, your 2nd SP does not...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 1, 2007 at 4:12 pm

    #724017

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Yes, that makes perfect sense to me.  Amazingly, this is what I gathered from reading your code.  But the problem is, your 2nd SP does not...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 1, 2007 at 4:12 pm

    #724018

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    I am a bit confused by the logic in your sp_getnextlevel_single procedure as it appears to always return the same level that is passed into...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 1, 2007 at 3:08 pm

    #724005

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Also, you are using SELECT INTO to create temporary tables to use in your procedure.  SELECT INTO copies the table structure in terms of columns, but indexes are not copied...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    August 1, 2007 at 10:24 am

    #723948

  • RE: Optimizing Performance of Stored Procedures in SQL Server 2000

    Your best bet here will be to post your table DDL and your code.  SQL Server works best by operating on Sets of data, not row-by-row (look up RBAR...a Modenism...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 31, 2007 at 4:07 pm

    #723730

  • RE: CHARINDEX - CAPTURING TEXT TO LEFT

    Yep, you're correct.  Thanks for the catch

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 31, 2007 at 4:00 pm

    #723729

  • RE: How to notify a person when there''''s an update done to a table

    I would recommend using the trigger to insert notification rows into another table.  Then set up a job to read that table and send the e-mails.  The reason for this...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 31, 2007 at 3:31 pm

    #723723

  • RE: CHARINDEX - CAPTURING TEXT TO LEFT

    There are a number of methods you could use to do this including, but necessarily limited to, the following example.  All three of these methods are well documented in BOL. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 31, 2007 at 3:25 pm

    #723721

  • RE: Blocked task

    A task that shows up as blocking itself is usually a result of the task waiting on I/O.  Check the wait type the next time you see this occur and...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 30, 2007 at 6:34 pm

    #723443

  • RE: max row for each id

    I'm not sure if I'm following you.  Do what a million times?  The solution I provided will obviously need re-written to use your real table/column names, but it will...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 27, 2007 at 9:11 am

    #722918

  • RE: Impossible to catch error for : Cannot insert duplicate key row in object .......

    jesus,

    In what way is your problem similar?  You would probably have better results in terms of feedback on your problem if you start a new thread.  Also include any...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 27, 2007 at 9:02 am

    #722911

  • RE: max row for each id

    This may get you going in the right direction.  Keep in mind that in the event you have 2 rows in your table with the same MAX(Date), you'll get more...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    July 27, 2007 at 8:41 am

    #722897

Viewing 15 posts - 2,176 through 2,190 (of 3,232 total)