Jump to content

bernycat

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About bernycat

  • Rank
    Newbie
  1. I need a query that will return the "Next" lines (the lines that come after the lines I specify). I'm told the LAG function works in SQL 2012, but I'm running 2008 and LAG is not recognized.Here's what I'm looking for:Tables: WORK_ORDER, OPERATIONMy OPERATION table contains all of the operations (sequenced (10,20,30,40...)) associated with each work order. My work orders each have 10 linear operations, meaning that only one is worked on at a time, and the next operation does not start until the current operation is completed. The OPERATION table shows sequence, qty_completed, and scheduled sta
×
×
  • Create New...