I recently had to create a mortage coupon book. Now i was able to accomplish this using a table variable in Sql 2000. Is there a way to do this without using the table variable or temp tables? I couldnt discern a way to do it without using a loop to insert the values into a table. The reason i ask is that i would really prefer to put this into a view instead of stored procedure.