Function to Rank Rows

• Mark Mokris

  SSC Veteran

  Points: 279

  More actions

  February 3, 2006 at 2:49 pm

  #167421

  I need to create a FUNCTION that accepts a SQL statement as a parameter and an index as the other parameter.  The SQL statement will return a single column with multiple rows.  I want the function to pass back the 1st value (row), or 2nd value, or 3rd value depending on the index parameter.

  I don't think I can pass in the SQL statement as a VARCHAR and execute it in a SQL function.  Can I pass in the results of the SQL statement as a table and have the function return the row identified by the index parameter?

  I need this to be a function because I want to call it within a column of an outer SQL statement.

  Thanks,

  Mark

   

• [KH]

  SSCommitted

  Points: 1908

  More actions

  February 5, 2006 at 8:02 pm

  #618889

  Can you post your table DDL, some sample data and expected result ?