Re: sql queries

From: Plamen Ratchev <Plamen@xxxxxxxxxxxxx>
Date: Thu, 11 Mar 2010 10:52:43 -0500

harish rg wrote:

I need a help

Table: airlines_data

Table Structure:

Airlines Airport
ADAMAIR US
AERLINGUS UK
AEROFLOT US
AIRBERLIN US

I want the records in given below format

Airport ADAMAIR AERLINGUS AEROFLOT AIRBERLIN
US YES NO YES YES
UK NO Yes NO NO

Please can you help me in this

You can use dynamic pivoting:
http://pratchev.blogspot.com/2008/12/dynamic-pivoting.html

--
Plamen Ratchev
http://www.SQLStudio.com
.

References:
- sql queries
  - From: harish rg

Prev by Date: Re: how do i stop a maintenance plan?
Next by Date: Re: how do i stop a maintenance plan?
Previous by thread: sql queries
Next by thread: SQL 2005 attemted to read or write protected memory.
Index(es):
- Date
- Thread