dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

Flip table - sqlserver-programming

This is a discussion on Flip table - sqlserver-programming ; how to flip a table? Suppose the tables has same decimail datatypes for all columns except column0 which is varchar. After flip the table, columnnames should be in the column0 of new table and the original fields in column0 become ...


Home > Database Forum > Microsoft SQL Server > sqlserver-programming > Flip table

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-14-2008, 11:39 PM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Flip table
how to flip a table?
Suppose the tables has same decimail datatypes for all columns except
column0 which is varchar.
After flip the table, columnnames should be in the column0 of new table and
the original fields in column0 become the columnnames.

Thanks

Reply With Quote
  #2  
Old 11-15-2008, 12:10 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: Flip table
"MXC" wrote in message
news:96A4C421-BB19-49C7-85AB-D6F186586B90@microsoft.com...
> how to flip a table?
> Suppose the tables has same decimail datatypes for all columns except
> column0 which is varchar.
> After flip the table, columnnames should be in the column0 of new table
> and the original fields in column0 become the columnnames.

Can you say that again?

Michael


Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 02:21 PM.