Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    74

    Unanswered: Temp tables and UDF's

    Hey,

    I am in the process of modifying some stored procedures that currently do not use temp tables. For this modification I am required to make the stored procedures use temp tables. There are several UDF's within this stored procedure that will need to use the temp tables, and this is where in lies the problem. Does anyone know of a work around that would allow UDF's to use temp tables, or does anyone know of alternate methods instead of temp tables that wouldn't involve too much change?

    Thanks

  2. #2
    Join Date
    Apr 2004
    Posts
    69
    I think you can use variables of type TABLE

    i.e. DECLARE var TABLE(....

Posting Permissions

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