1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
|
CREATE TABLE #result
(
[Dimension Set Id] int,
[Axe1] nvarchar(80),
[Axe2] nvarchar(80),
[Axe3] nvarchar(80),
[Axe4] nvarchar(80),
[Axe5] nvarchar(80),
[Axe6] nvarchar(80),
[Axe7] nvarchar(80),
[Axe8] nvarchar(80),
[Axe9] nvarchar(80),
[Axe10]nvarchar(80)
)
INSERT INTO #result
SELECT
DISTINCT [Dimension Set Id], 'N/A' [Axe1], 'N/A' [Axe2], 'N/A' [Axe3], 'N/A' [Axe4], 'N/A' [Axe5], 'N/A' [Axe6], 'N/A' [Axe7], 'N/A' [Axe8], 'N/A' [Axe9], 'N/A' [Axe10]
FROM
dbo.[BI_STD Analytic TEST]
UPDATE #result
set [Axe1] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 1
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe2] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 2
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe3] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 3
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe4] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 4
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe5] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 5
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe6] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 6
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe7] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 7
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe8] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 8
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe9] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 9
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
UPDATE #result
set [Axe10] = B.[Analytic Value]
FROM dbo.[BI_STD Analytic TEST] B, #result R
WHERE [Axe ID] = 10
AND R.[Dimension Set ID] = B.[Dimension Set ID]
GO
SELECT * FROM #result ORDER BY ([Dimension Set Id])
DROP TABLE #result |
Partager