This is a great explanation of using the new SQL 2k5 operators of INTERSECT and EXCEPT instead of inner and outer joins. Quote Raymond Lewallen : New INTERSECT and EXCEPT operators in Sql Server 2005 T-SQL
Month: February 2006
Data Warehousing Planning
When planning to build an enterprise data warehouse, there are many of small details ranging from hardware allocation to error reporting. So unless you plan for this correctly, you may deliver an inadequate system. A good article to review on the issues to resolve when planning a data warehouse can be found in Craig Utley’s article within the July 2004 edition of SQL Server Magazine "Beating the Odds" Company Politics: turf battles, lack of clear vision, bureaucracy, etc. Lack of User Involvement: Ask the questions and figure out what is needed and what to report. Overbuilding: Do not try…
Recursive Query
Use of Recursive Commom Table Expression (CTE) If you have a parent-child table, a common thing to do is to run a recursive query that can list out all of the parent-child path strings. For example, if you have a table called Taxonomy, with the format / data below: TaxonomyID ParentTaxonomyID TaxonomyName 2 1 Shoes 3 1 Accessories 20 2 Ladies 21 2 Men 22 2 Kids And you will want to list out the values: \Shoes \Accessories \Shoes\Ladies \Shoes\Men \Shoes\Kids To do this, you can use Recursive Common Table Expressions (CTE) to quickly get you that…
Denny Lee 