hola, pues en realidad, lo que deseo hacer es la siguiente consulta SQL pero de manera dinamica:
Código SQL:
Ver originalSELECT a.gestion,
(a.[201301]+b.[201301]+c.[201301]+d.[201301]) AS [201301],
(a.[201302]+b.[201302]+c.[201302]+d.[201302]) AS [201302],
(a.[201303]+b.[201303]+c.[201303]+d.[201303]) AS [201303],
(a.[201304]+b.[201304]+c.[201304]+d.[201304]) AS [201304],
(a.[201305]+b.[201305]+c.[201305]+d.[201305]) AS [201305],
(a.[201306]+b.[201306]+c.[201306]+d.[201306]) AS [201306],
(a.[201307]+b.[201307]+c.[201307]+d.[201307]) AS [201307],
(a.[201308]+b.[201308]+c.[201308]+d.[201308]) AS [201308],
(a.[201309]+b.[201309]+c.[201309]+d.[201309]) AS [201309],
(a.[201310]+b.[201310]+c.[201310]+d.[201310]) AS [201310],
(a.[201311]+b.[201311]+c.[201311]+d.[201311]) AS [201311],
(a.[201312]+b.[201312]+c.[201312]+d.[201312]) AS [201312], 'GES08' AS COD_GES
FROM Llamadas_Mensual_Oro_Final a INNER JOIN Llamadas_Mensual_plata_Final b
ON a.gestion = b.gestion
INNER JOIN Llamadas_Mensual_Reten_Final c
ON b.gestion = c.gestion
INNER JOIN Llamadas_Mensual_cable_Final d
ON c.gestion = d.gestion
el cual el valor año se tome del año del sistema y para los meses solo use los numeros del 1 al 12 concatenandolos como texto a cada uno....