Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Re-ordering a #Temp table! Please Help!

Author  Topic  cyx Starting Member 9 Posts Posted - 2000-12-19 : 09:51:15 Hello everybody, I hope you could help me with this brain candy. I have a stored procedure which creates a #Temp table and does some SELECTs and UPDATEs in it. Now in some stage, I want to re-order the columns in the table, how can I do it Here is how the table looks like (sort of): CREATE TABLE #TempTable ( COLUMN_ID int IDENTITY, product_id varchar(100) NOT NULL, ... ) Hope you could help me out without creating a new #Temp table, Cheers everyone! ---------------------- Rafi B., Israel.