Thread: Why can’t recursive queries contain...?

Looks like we're going to have to agree to disagree on this extremely minor, drawn out point. Michael

Since we're really stretching the definition of "support for TVPs", we can surely stretch the definition of "support for digestion" to include the Food Network.  As you say, it depends on how you look at it, if you choose to look at it that way. :)  The fact that the LINQ providers have no support for TVPs is not even a question.  The fact that you can kludge around the lack...

Permit me to point out that in the programming trade, nothing is proven to work until code is written and tested. Later in the thread, you can this sample:  SqlCommand command = CodeToCreateMyCommand();  command.parameters["MyTableVariable"].Value = ResultsFromMyLinqQuery();  command.Execute(); This sample is not likely to work of the simple reason that you fail to set the parameter type. You also...

At each recursive level you can have some success with windowing functions. Therefore, at each recursive level you can use aggregates with OVER clause. Why some success? well check that MS Connect link. Some don't work as expected. If they did, you could row_number() at each level, get max( from derived table where row_number (level data set)) OVER () at each level and then start the next ireration level with r.max_prev_iteration +...

Thank you all for your help

Hi Klem, Simple - because that are the limitation the development team chose to put in place. <speculation mode on> Allowing these options would probably allow users to write queries that were too hard to figure out how to do, or that would require more development time than was necessary. Evey option allowed adds to the complexion of the final product. Remember that if an option is allowed, customers will expect it to work in...

MS SQL Server is a minimal subset of the ANSI/ISO Standards.  In Standard SQL, the WITH clause is "WITH [RECURSIVE]<cte name>" so that the compiler gets to change modes when a CTE is recursive.  There are other differences.  I am at speaking at PASS now and then going to SQL Connections, so I do not have my Standards with me; Google around for it. I think the Standard might allow for...