Using T-SQL PIVOT Clause

25Jun08

  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

IIS Feature Requirement on Windows Vista for SQL Server 2005

16Jun08

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