Forum Replies Created

Viewing 15 posts - 76 through 90 (of 127 total)

  • RE: Stored Procedure with mode flag

    I have read about that in the past, but didn't think about it.  Another good point.  I'm just going to split up the SPs based on function.  Thanks guys.

  • RE: Stored Procedure with mode flag

    Sergiy - Monday, August 27, 2018 7:07 AM

    It's easy to find out:

    lol. Yes, that was a lazy question.  Thanks.

  • RE: Stored Procedure with mode flag

    I think i understand.  The SP is for Inventory lot allocation. So, I should just create separate procedures. i.e. IM_Lot_Select, IM_Lot_Update, IM_Lot_Delete?

  • RE: Stored Procedure with mode flag

    Sergiy - Monday, August 27, 2018 7:00 AM

    Jackie Lowery - Monday, August 27, 2018 6:30 AM

    August 27, 2018 at 7:03 am

    #2003419

  • RE: Stored Procedure with mode flag

    Can you provide a rough example or a link?  Also, why is it not good practice?

  • RE: XML nodes help

    I made the change to db compat level and created the XML computed column.  Now the query takes 12 sec. to return 119 rows for a single CDA.  I'm at...

  • RE: XML nodes help

    I changed the db compat level on our test server db to SQL 2012.  The try_convert function works on it now.  What things should i be concerned with when changing...

  • RE: XML nodes help

    I get this error:

    Msg 195, Level 15, State 10, Line 1
    'try_convert' is not a recognized built-in function name.

  • RE: XML nodes help

    Eirikur Eiriksson - Monday, July 9, 2018 4:59 AM

    What is the actual version you are running on?
    😎

    You can use features...

  • RE: XML nodes help

    Is it possible to use a persisted calculated column when there are errors in some of the XML?
    I can't use try_convert b/c the db compat level is server...
  • RE: XML nodes help

    Eirikur Eiriksson - Saturday, July 7, 2018 3:23 AM

    I would try to dump the sub-query into a temporary table with a...

  • RE: XML nodes help

    Eirikur Eiriksson - Saturday, July 7, 2018 3:23 AM

    I would try to dump the sub-query into a temporary table with a...

  • RE: XML nodes help

    Eirikur Eiriksson - Friday, July 6, 2018 10:25 AM

    My guess is that the server has the default "cost threshold for parallelism"...

  • RE: XML nodes help

    Sorry for the late response on this.  Project got put on the backburner for a couple weeks.  So, to catch up, Erikur Erikssons solution in previous post gives me a...

  • RE: Wildcard in IN statement

    Here is my final full code and exec plan if you have a bit of time to look for any further issues.  Thanks again for the help.

    [code...

Viewing 15 posts - 76 through 90 (of 127 total)