Views : 124 Clicks : 12

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

Wanted: PHP Internship and Job at Teknowledge Software (Kolkata, West Bengal). See this and other great job listings on the jobs page.

Freshly Arrived

1. Simple movie search using PHP, jQuery and themoviedb.org API
2. Running PHPUnit with the IBM i
3. Timing PHP script execution time
4. Social Share/Vote Button plugin for joomla content
5. New Wordpress Plugin: Escape HTML

Getting Hotter

1. Integrating Dreamweaver CS5 and Joomla 1.5 OR Joomla 1.6
2. Scaling WordPress on Microsoft
3. More WordPress Useless Stats And Graphs
4. jQuery and Ajax Best Demos Part-7
5. Writing Clean CSS3 Code