Clever Geek Handbook

How do I rename a column before it is opened? SQL Server

Help I need to rename a column before using the method unpivot

My table is like this:

List item

id| value| ENE| FEB| MAR| ABR| MAY  
1 | dsads|2000|2334|2344|2344|2344

after univot I get something like this

id| value| month| amount
1 |  dads| ENE  | 2000
2 |  sadf| FEB  | 2334

but i want something like this

id| value| month| amount
1 |  dads| 01   | 2000
2 |  sadf| 02   | 2334

This is my request

select 
    [año], [Empresa], [Region], [Suc], [CC], [Cuenta], 
    [Subcuenta], [Descripcion], Periodo, Importe
from 
    (select * from [dbo].['P Cargado$']) S
unpivot 
    (Importe for Periodo in
        ([ENE], [FEB], [MAR], [ABR], [MAY], [JUN], [JUL], [AGO], [SEP],[OCT], [NOV], [DIC])
    ) AS unpvt;
+3


source to share


1 answer


If you are using , you can do it like this: cross apply(values ..) 

select t.id, t.value, x.*
from t
cross apply (values (1,ene),(2,feb),(3,mar),(4,abr),(5,may)) x (Mnth,Amount)

registry: http://rextester.com/SZDP50356



returns:

+----+-------+------+--------+
| id | value | Mnth | Amount |
+----+-------+------+--------+
|  1 | dsads |    1 |   2000 |
|  1 | dsads |    2 |   2334 |
|  1 | dsads |    3 |   2344 |
|  1 | dsads |    4 |   2344 |
|  1 | dsads |    5 |   2344 |
+----+-------+------+--------+
+3


source






More articles: