Stored Procedure

Results 1 to 2 of 2

Thread: Stored Procedure

  1. #1
    Join Date
    Dec 1969

    Default Stored Procedure

    Does anyone know how to call a stored procedure from SELECT statement?<BR>Something like this:<BR><BR>select * from Person_Identification where PersonID in (exec GetPersonID &#039;00001&#039;)<BR><BR>The GetPersonID returns all PersonID in group &#039;00001&#039;<BR><BR>(No cursors please)

  2. #2
    Join Date
    Dec 1969

    Default RE: Stored Procedure

    can&#039;t do that. <BR><BR>You have to create a user defiend function that returns a table.<BR><BR>(search for &#039;table valued UDF&#039;)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts