Sql Pivot?

Hello, I have the folowing sql query;

SELECT DateTime, TagName, Value
FROM v_AnalogHistory
WHERE (DateTime >= CAST(CONVERT(VARCHAR(8), GETDATE() - 1, 112) AS DATETIME)) AND (DateTime < CAST(CONVERT(VARCHAR(8), GETDATE(), 112)
AS DATETIME)) AND (TagName = N'FI702A') OR
(TagName = N'FI701A') OR
(TagName = N'FI504A') OR
(TagName = N'ZI504A') OR
(TagName = N'ZI502A') OR
(TagName = N'LI103A')

What I would like to know is how to change this query to a pivot query to produce the following report;









Gas
Flow to
Synagro
Flow
to Gas
Burner
Gas Holder
Liq. Overflo
Rate
Gas Holder
Roof
Position
ESD# 1
Liquid
Level












DateTime
FI702A
FI701A
FI504A
ZI502A
LI103A

12 AM
69.6
11703.5
3.9
0.2
60.1

1 AM
69.4
11703.5
3.8
0.2
60.2

2 AM
69.3
11703.5
3.7
0.2
60.4

3 AM
69.6
11703.5
3.7
0.2
60.2

4 AM
69.5
11703.5
3.6
0.2
59.7

5 AM
69.4
11703.5
3.6
0.2
59.2

6 AM
69.5
9363.7
3.6
0.2
58.7

7 AM
69.4
3.8
3.6
0.2
57.6

8 AM
167.3
3.8
3.7
0.2
57.9

9 AM
297.2
3.2
3.7
0.2
57.7

10 AM
327.8
2.9
3.7
0.2
57.4

11 AM
295.2
454.7
3.6
0.2
57.2

12 PM
299.1
1106.6
3.5
0.2
57.1

1 PM
301.3
461.2
3.4
0.2
57.2

2 PM
69.6
3.2
3.4
0.2
57.1

3 PM
69.7
1.8
3.5
0.2
57.2

4 PM
69.7
3.8
3.6
0.2
58.5

5 PM
69.6
1.5
3.7
0.2
59.1

6 PM
174.5
2.3
3.8
0.2
59.0

7 PM
328.8
2.0
3.7
0.2
58.9

8 PM
300.0
2.6
3.6
0.2
58.7

9 PM
240.0
2.3
3.5
0.2
58.2

10 PM
69.6
3.5
3.5
0.2
57.9

11 PM
69.7
2.9
3.6
0.2
57.6