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:36:45
|
| 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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-16 : 17:53:29
|
| It is not possible. If you provide more information, I'm sure we can come up with an alternative solution.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Help With Creating View