UDF and RowCount

• alorenzini

  SSCarpal Tunnel

  Points: 4620

  More actions

  December 11, 2007 at 9:02 am

  #201546

  I have a situation in which I am using a UDF to return a table but what I need to happen is if the table has more than 2 records than I only what to passout one record. Any ideas?

  Thanks,
  Art
  Database Analyst
  Tastefully Simple, Inc.

  alorenzini@tastefullysimple.com
  " Some days, it's not even worth chewing through the restraints!

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  December 11, 2007 at 9:42 am

  #759038

  Without knowing what exactly you try to achieve and no ddl I can only guess.

  Does it matter which record is returned or do you just want any record?

  Can't you use something like Select top 1 * from udf_results()

  [font="Verdana"]Markus Bohse[/font]