Run Function for each result from query

• kmaclure

  SSC Journeyman

  Points: 80

  More actions

  August 19, 2002 at 4:23 am

  #79918

  I've got a SP that runs a query to get a list of users. I then pass a userid to a function only if the userid meets a specific criteria. This runs great if only one userid meets the criteria. How can I pass more that one userid to a function sequencially? Like if three userid's meet the criteria pass userid 1, then when the function completes pass userid 2 etc.

  This shouldn't be too difficult but it is beyond me at the moment...

  Thanks

  "It makes me want to run around the Server Room in a Super-Hero Costume"

  
  "It makes me want to run around the Server Room in a Super-Hero Costume"

• Chris Hedgate

  One Orange Chip

  Points: 25041

  More actions

  August 19, 2002 at 6:53 am

  #434780

  Wouldn't this work?

  SELECT MyFunction(userid)

  FROM MYTABLE

  WHERE userid = some_criteria

  Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

  http://www.sql.nu

  --
  Chris Hedgate http://www.hedgate.net/
  Contributor to the Best of SQL Server Central volumes
  Articles: http://www.sqlservercentral.com/columnists/chedgate/