Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language


 
 
Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

case select by column


is it possible to do the following ?

table has ID,number,column1,column2,column3,column4

i need to select a column by the value in the number column

eg results would be

1,1,column1
2,3,column3
3,2,column2
4,1,column1

eg if number =1 then select column1, number=2 select column2 etc

possible ?

thanks in advance

mark

hi

see my blog on Rotate a table in SQL Server

http://oneplace4sql.blogspot.com/

VT
Knowledge is power, share it....
http://oneplace4sql.blogspot.com/

"luna" <lun@themoon.com> wrote in message

news:KO-dnTcFWPBRRPrbnZ2dnUVZ8s6gnZ2d@giganews.com...

"vt" <vinu.t.1@gmail.com> wrote in message

news:O$5k77OqHHA.1288@TK2MSFTNGP06.phx.gbl...
> hi

> see my blog on Rotate a table in SQL Server

> http://oneplace4sql.blogspot.com/

> VT
> Knowledge is power, share it....
> http://oneplace4sql.blogspot.com/

ahh union join, i wasnt thinking properly this morning

cheers for the hints

mark

Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc