Forum Replies Created

Viewing 5 posts - 46 through 51 (of 51 total)

  • RE: SP help

    Try to isolate the error. Run this code out of the stored procedure and debug it to see where is the problem.

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

    October 17, 2013 at 6:43 am

    #1659289

  • RE: Can I avoid RBAR in the following scenario

    Then this should do the trick :

    select

    coalesce(p.period_month,r.Fromdate) as period_month,r.warehouse_code,r.item_number,r.origin_warehouse_code,r.Fromdate

    from

    Routing_History r

    left join Period p on p.period_month= r.Fromdate

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

    October 17, 2013 at 6:23 am

    #1659279

  • RE: Can I avoid RBAR in the following scenario

    I think what you want is to query all routing_history rows and show period_month column only if available. This is a left join :

    select

    p.period_month,r.warehouse_code,r.item_number,r.origin_warehouse_code,r.Fromdate

    from

    Routing_History r

    left join Period p...

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

    October 17, 2013 at 6:08 am

    #1659265

  • RE: SP help

    What is the datatype of LH.hazardCode column ?

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

    October 17, 2013 at 6:00 am

    #1659261

  • RE: fragment_count

    fragment count 2000 means that index data is spread accross 2000 blocks of consecutive pages.

    Jonathan Bernardez Bernardez
    ___________________________________________________________
    DBD. MCSA SQL Server 2012

    October 17, 2013 at 5:50 am

    #1659255

Viewing 5 posts - 46 through 51 (of 51 total)