Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. daveys110

    COUNTing Rows Returned From A User Defined Function

    Thanks, I've solved this now - I just made another function to COUNT the rows returned by the first function. EG: SELECT sg.id, sg.title, dbo.CountStoresInGroup(sg.id) AS storeCount FROM StoreGroups sg ORDER BY sg.title Thanks, Dave
  2. daveys110

    COUNTing Rows Returned From A User Defined Function

    MS SQL 2000
  3. daveys110

    COUNTing Rows Returned From A User Defined Function

    Hi! I'm trying to return the number of rows returned by a UDF which returns a table: The UDF returns a TABLE defined with only 1 column (storeID INT) I want to get the number of rows returned by the UDF: StoreIDListForGroup( <groupID> ) Example usage that works: SELECT sg.id, sg.title...

Part and Inventory Search

Back
Top