Using table variables SQL Server 2000 has a new Table data type that lets you declare local variables as type table. The table type is available only via a UDF.

eWEEK content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More. In this, Part 4 of a series on programming T-SQL ...

for the love of god, use lower case man! your code is so shouty it hurts the eyes. Also, use the code tag to surround the code.<BR><BR>To give something constructive, here are my suggestions:<BR ...