Finding out the missing segments from the source dataset

• SQL Prog

  SSCrazy

  Points: 2020

  More actions

  October 23, 2014 at 4:06 pm

  #294422

  I have 2 tables, #MainSample and #SampleCode

  In the #MainSample, Line_ID is the Primary key

  Line_ID BegMeasure EndMeasure

  656 0.00 254500.00

  657 0.00 7000.00

  658 0.00 308000.00

  659 0.00 20000.00

  #Sample Code

  Line_ID BegMeasure EndMeasure Code

  659 665.00 9456.00 APL-XL

  657 0.00 200 BHP

  From this, I have to find out the segments for which there is no defined code value. I want the output as

  Line_ID BegMeasure EndMeasure

  656 0.00 254500.00

  657 200.00 7000.00

  658 0.00 308000.00

  659 0.00 665.00

  659 9456.00 20000.00

  How to achieve this? Please help. Thanks a bunch.