Posted by Erland Sommarskog on 05/01/07 22:19

Designing Solutions WD (michael.grassman@gmail.com) writes:
> Please disreguard post.
>
> Everything work but when I moved the database over to a new server the
> default values didn't stick to so the parent trasactionid was never
> initiallized to 0.

Which version of SQL Server are you? If you are on SQL 2005, you should
look into a new features know as Common Table Expressions, or CTEs for
short. A special form is recursive CTE which permits you to handle a
hierarchy in a single statement. Look up the topic "WITH common table
expression" in Books Online for further details.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Need to tune a table for performance gains
• Prev in forum: Re: Dynamic SQL reading statements from table
• Thread view: Re: Need to go down path to find if everything is settled (recursive possibly)

[Reply to this message]