I faced one problem while working with Common Table expressions in Sqlserver 2008.
the problem is How to use the table(means temporary table) which is created by with CTE's after that one select statement.
Actaully the table(which is created using with CTE) is automatically deleted, one's after execution of any select,insert,update or create view statement .Right!
But I needed that table second time also. How it is possible.
please help if any one knows..........
Thanks in Advance........
View Complete Post