Query Help

• EasyBoy

  SSCertifiable

  Points: 5301

  More actions

  November 1, 2010 at 6:40 am

  #388135

  Hello All,

  I need help with query and attached result for the Query.

  Now my question is without this condition and b.Callback < '2009-12-31 00:00:00' i am getting two rows. If i apply that condition then i will get only one row but i dont need any row if that condition satisfy. Can anyone let me know how can i modify that query?

  select a.KeyInstn, b.KeyQuestionnaireTracking, b.KeyQuestionnaire, b.KeyInstn, b.KeyFinl,

  b.Callback, b.MostRecentSequence, c.StandardDate, c.KeyFinlEOP, c.FiscalQuarter,

  d.DateEndedStandard

  from Instn a join QuestionnaireTracking b on b.KeyInstn = a.KeyInstn

  join Finl c on c.KeyFinl = b.KeyFinl

  join FinlEOP d on d.KeyFinlEOP = c.KeyFinlEOP

  where b.KeyQuestionnaire in (0, 63, 29, 30, 32, 33, 35, 36, 37, 38, 39, 41, 42, 67, 44, 45, 1, 2,

  64, 46, 47, 48, 49, 50, 52, 53, 54, 55, 56, 57, 58, 59, 61, 62)

  and b.MostRecentSequence =1

  and d.CurrentFinl =1

  and c.AppStatus = 2

  --and b.Callback < '2009-12-31 00:00:00'

  and a.KeyInstn =100095 --and 111111

  order by a.KeyInstn

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 1, 2010 at 7:02 am

  #1244797

  Check out "Exists" in books online.