Archive for June, 2008
We often need to deal with hierarchies (tree structures) in SQL. Some common examples are employee hierarchies, parent-child hierarchies etc. There is a clean solution to achieve it using CTE (Common Table Expressions) which is demonstrated below with a simple example. The diagram below represents a parent-child hierarchy: And the table [...]
Filed under: SQL Server, SQL Server 2005, T-SQL | Leave a Comment
Tags: Common Table Expressions, CTE, Recursive Query SQL, SQL Recursion
Using T-SQL PIVOT Clause
One feature in SQL Server 2005 that made my life easier many occasions is PIVOT clause in T-SQL. You will find it useful if you need to generate Cross-Tab summaries especially while generating reports. This feature allows you to convert a column’s values in table rows into columns. To see how it works, [...]
Filed under: SQL Server, SQL Server 2005, T-SQL | 3 Comments
Tags: PIVOT, SQL Server, SQL Server 2005, T-SQL
When you try to install SQL Server 2005 on Windows Vista, you may get the following warning against IIS Feature requirement : “Microsoft Internet Information Services (IIS) is either not installed or is disabled“ This indicates that some of IIS 7.0 components are missing in your IIS configuration. You can verify this by going to : Start -> Control Panel ->Programs ->Turn Windows [...]
Filed under: SQL Server | 4 Comments
Tags: IIS 7, SQL Server 2005, Vista
