Re: Yukon Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 12:23:11 +0100

Yukon's Common Table Expression feature supports recursive queries. Itzik
Ben-Gan shows some examples of how to expand a hierarchy using CTE:

http://msdn.microsoft.com/library/en-us/dnsql90/html/sql_YukonTSQLEnhance.asp 

-- 
David Portas
SQL Server MVP
--

Relevant Pages

  • Re: for updae trigger question
    ... I will try to generate the triggers that way so the ... >> Rather than write dynamic SQL into your production code why not write ... >> David Portas ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: sql - question
    ... > David Portas ... > SQL Server MVP ... Your guidance has been useful to me. ... it's value as zero. ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: [NOW ANSWER Aarons QUESTION CELKO]
    ... I personally don't care about "elegant" code. ... clients since SQL 2005 came out was that only a VERY small percentage of ... SQL Server MVP ... CTE but I am hardly able to use this technique with DB2. ...
    (microsoft.public.sqlserver.programming)
  • Re: Extremely Slow Trigger Problem
    ... been working okay up until about a week ago, and I think there is an ... cost so much to open that cursor with 1 row in the inserted/deleted tables. ... "David Portas" wrote: ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • RE: Using variable column-names
    ... help, please post DDL, sample data INSERTs and required results. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)