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
 General SQL Server Forums
 New to SQL Server Programming
 WITH common_table_expression

Author  Topic 

nissansentra
Starting Member

3 Posts

Posted - 2006-02-10 : 10:46:05
I am using the WITH CTE feature in SQL Server 2005 to create a temporary table. But everytime the compiler gives me a warning of "something wrong near with". The database is in remote server, so I am not sure whether it's the problem. There is no problem running the CTE example in the sample database of AdventureWorks, quite weird.
   

- Advertisement -