Recursive queries?
anonymous_at_discussions.microsoft.com
Date: 01/13/05
- Next message: Mike Epprecht (SQL MVP): "RE: Cross Database Trigger"
- Previous message: DMP: "Data Export T-SQL to Excel"
- In reply to: SLE: "Recursive queries?"
- Next in thread: Alex Papadimoulis: "RE: Recursive queries?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 Jan 2005 01:15:25 -0800
Get this book. You'll appreciate what it has inside.
Library of Congress Cataloging-in-Publication Data
Celko, Joe.
Joe Celko's Trees and hierarchies in SQL for smarties /
Joe Celko.
p. cm.
Includes bibliographical references.
ISBN 1-55860-920-2
1. SQL (Computer program language) 2. Trees (Graph
theory) I. Title:
Trees and hierarchies in SQL for smarties. II. Title.
QA76.73.S67C435 2004
05.13'3-dc20 2004006193
>-----Original Message-----
>Hi there,
>
>Categories are persisted in the following table. This
illustrates that
>categories can have child categories (or in other words
categories can have
>a parent category).
>
>tblCategory
>CatID int
>CatName nvarchar(255)
>CatParent int (nullable)
>
>I need some generic T-SQL which will return all n-level
categories.
>
>
>Thanks,
>
>--
>SLE
>
>
>.
>
- Next message: Mike Epprecht (SQL MVP): "RE: Cross Database Trigger"
- Previous message: DMP: "Data Export T-SQL to Excel"
- In reply to: SLE: "Recursive queries?"
- Next in thread: Alex Papadimoulis: "RE: Recursive queries?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
