Home Forums SQL Server 7,2000 T-SQL table variable in a table-valued function RE: table variable in a table-valued function

  • John,

    I appreciate your prompt reply. The reason why I am using the table declaration is that I have more code that follows the first part. I intend to join to the records in the table variable for speed reasons. Think of it almost like joining to a view in a table-valued function. If I did not have any more codes after the first set of codes, then your suggestion would be the way to go.

    Thanks again.

    Messan