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.
| Author |
Topic |
|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 2009-08-31 : 12:34:39
|
| I am assigned to update one Access program to ASP.NET. In Access program, there are a few queries to make a final result table to be used in a report. Between these queries, Access program using a few table to swap data in order to make final table.Question: In SQL server, how to do it? ASP.NET program can not use tables in SQL server to swap data since there about 50 users will use ASP.NET program. |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-08-31 : 12:51:05
|
| You are not specific enough in your question. I suspect you're looking for information on temp tables.Create table #temp(columnname as varchar(15) null,Columntwo as int)See books online for more information on temp tablesAn infinite universe is the ultimate cartesian product. |
 |
|
|
|
|
|
Need an idea of using swap table