Using PIVOT and UNPIVOT with SQL 2005/2008

by Farooq Kaiser 31. May 2009 11:54

The PIVOT operator can be used to transform a set of rows into columns while the UNPIVOT operator complements the PIVOT operator by allowing you to turn columns into rows. The following sample will use AdventureWorks database.Sample CodeUSE AdventureWorks GOSELECT DaysToManufacture, sum(StandardCost... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: sql, t-sql

SQL

Querying Active Directory with LINQ

by Farooq Kaiser 30. May 2009 14:45

Today, i will show you Querying Active Directory with LINQ. Sample Codevar users = new DirectoryObject<User>(new DirectoryEntry("LDAP://localhost"), SearchScope.Subtree);var groups = n... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: active directory, linq

.NET | API | C#

Creating Word file using Office Open XML

by Farooq Kaiser 28. May 2009 14:40

Recently, i created a webservice to generate the word and excel files using Office Open XML. The Open XML SDK can be downloaded from http://www.microsoft.com/downloads/details.aspx?familyid=ad0b72fb-4a1d-4c52-bdb5-7dd7e816d046&displaylang=en Use the following namespaces... [More]

Currently rated 5.0 by 1 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: office open xml

.NET | C# | XML