SQL Query wanted

• anbaz1976

  SSC Rookie

  Points: 36

  More actions

  May 11, 2011 at 9:28 pm

  #250877

  Hi All,

  I have a reference table that table have two columns ie "value" and "text".

  The records are like "value" column = 1 means equalent "text" column is January

  second record "value" column = 2 means equalent "text" column value is February..

  ....

  if "value" column = 12 means equalent "text" column value is December.

  i want a sql query to fetch from table like January;February;march;april if i pass the input as 1;2;3;4; etc..

  Regards,

  Anbu

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  May 12, 2011 at 8:13 am

  #1323686

  This is the same as your previous post. Please direct all replies here

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/