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]

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]

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]