t, Sql Server - rextester

t

Language: Layout:

View schema
Execution time: 0,02 sec, rows selected: 5, rows affected: 3, absolute service time: 0,19 sec, absolute service time: 0,19 sec

fork mode | history

  
Columns

1
[DataType],[DateMod],[EnvType]


  
Query

1
SELECT [ID], [DataType],[DateMod],[EnvType] from 
            (
                select 1 as ID
                    , [seqval]
                    , [Column_Name]
                from Table1
           ) x
            pivot 
            (
                 max([seqval])
                for [Column_Name] in ([DataType],[DateMod],[EnvType])
            ) p 


  
ID
DataType
DateMod
EnvType

1
1
3600
3600
3600

λ

                                      .NET NoSQL database for rapid development