Query

• Jeff Moden

  SSC Guru

  Points: 1004646

  More actions

  May 11, 2015 at 11:41 am

  #1797051

  sonu_mhl (5/11/2015)

  ---

  Hi

  I have below data & i want record with value 6 & 2013 should be returned. Both the fields are numeric

  U_MonthU_Year

  122012

  12013

  22013

  32013

  42013

  52013

  62013

  Thanks

  Glad you got the help you needed but do read the article I pointed you to. It will help you a lot when you post for help in the future. 😉

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)