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 |
|
hab
Starting Member
3 Posts |
 Posted - 2008-04-16 : 17:34:58
|
| Hi All, I have a sql command with temporary tables, but whenever I am trying to create a view with temporary tables I am getting an error as below:"Views or functions are not allowed on temporary tables. Table names that begin with ‘#’ denote temporary tables." Please anybody let me know is it possible to create a view with temporary tables in SQL Server 2005.If not, then is their any way how I can create a view with temporary tables. Thank You |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-16 : 20:19:51
|
| It's not possible.What are you trying to achieve.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2008-04-17 : 07:28:32
|
| An alternative might be to use a common table expression. Look it up in books online if you're not sure...Ryan Randall Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
|
|
|
Help With Creating View