#DateForumTypeThreadPost
310 Aug 2015 @ 04:35 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clauseHi Dieter, can you please help with this view creation using 'WITH' keyowrd for derived tables ?   Thanks !!
207 Aug 2015 @ 12:13 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clauseYes, the same problem. Could execute the WITH part as a simple SQL. But when I create the same as a view it throws as error.   Can you guys please guide on this. Thanks in Advance !!
106 Aug 2015 @ 03:10 PDTDatabaseReplycreating a view on a SQL query starting with "WITH" clauseHi, I'm not able to Create view(Non Recursive) using WITH cluase for derived table going by the syntax given in the above link. Replace View DB_Name.Vw_Name AS WITH Temp(C1,C2,C3) AS ( SEL A...