Getting RowNumbers from a Table

• kalyankumar.hyd

  Newbie

  Points: 9

  More actions

  January 18, 2011 at 12:06 pm

  #243820

  I have a below requirement where I need to get the best way to write a stored procedure:

  I have a table where there are employees data with employee_id, age, Posted_user_id

  I need to get the rownumbers (concatenated) of all the employees with age 45 posted by Posted_User_id.

  Please help me in getting the same.

  Regards,

  Kalyan

• Jeff Moden

  SSC Guru

  Points: 1004683

  More actions

  January 18, 2011 at 12:47 pm

  #1274945

  Heh... and what form of age discrimination will this be used for? 😉

  --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)
  

• Jack Corbett

  SSC Guru

  Points: 184397

  More actions

  January 19, 2011 at 9:58 am

  #1275410

  Are you really using SQL Server 7 or 2000?

  I'd start with a simple query that returns the rows I want.

  Select columns desired from table where age = 45 and posted_user_id = @posted_user_id

  I'm not sure what you mean by row number because you haven't posted the table definiton, so I don't know if there is a column named rownumber or if you mean the primary key for each row.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question