on 06-24-2013 8:48 PM
Estimados buenas tardes
Trato de obtener información mediante un pivot que no me trae ninguna información a pesar de que los datos si existen.
Es probable que tenga algo malo pero no se que pueda ser, agradezco su ayuda y dejo el código para su evaluación
Select P.[Codigo], P.[Descripcion],
[1] as [1],
[2] as [2],
[3] as [3],
[4] as [4],
[5] as [5],
[6] as [6],
[7] as [7],
[8] as [8],
[9] as [9],
[10] as [10],
[11] as [11],
[12] as [12]
From
(SELECT
MONTH(T0.[PostDate])[MONTH],
T0.[ItemCode][Codigo],
T1.[ItemName][Descripcion],
SUM(T0.[CmpltQty])[Total]
FROM OWOR T0
INNER JOIN OITM T1 ON T0.[ItemCode] = T1.[ItemCode]
WHERE
T0.[CmpltQty] > 0
and MONTH(T0.[PostDate]) Between [%0] and [%1]
GROUP BY
MONTH(T0.[PostDate]),
T0.[ItemCode],
T1.[ItemName])P
Pivot(SUM(Total)
For [MONTH] In ([1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]))P
La función PIVOT no funciona desde el query manager. Tienes que usarlo con procedimiento almacenado.
Al menos así era la ultima vez que lo probé
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.