Views : 231 Clicks : 13

Switching rows and columns in SQL

By nisha_singh via www.simple-talk.com
Submitted On February 8, 2010

he problem was to replicate this sort of functionality in SQL Server. It’s possible to write a CLR function to transform the data, however, I believe that a set-based T-SQL query is the preferred solution to this type of problem.

  0 Comments   Tags: Usablitiy,  Database

Freshly Arrived

1. Wall4PHP Mobile Framework
2. Practical PHP Refactoring: Convert Procedural Design to Objects
3. The __toString() Method – Objects as Strings
4. How to Create Your Own Super Simple WordPress Plugins
5. Learning JavaScript

Getting Hotter