Trouble with Pivot Tables
===

I know there are a lot of Pivot table examples on the internet, however I'm new to SQL and I'm having a bit of trouble as all the examples seem to be pertaining to aggregate functions.

Table 1:

|Date        | Tag  |Value |
----------
|06/10 2:00pm |  A   |  65  | 
----------
|06/10 2:00pm |  B   |  44  |
----------
|06/10 2:00pm |  C   |  33  |
----------
|06/10 2:02pm |  A   |  12  |
----------
|06/10 2:02pm |  B   |  55  |
----------
|06/10 2:02pm |  C   |  21  |
----------
....
|06/10 1:58am |  A   |  23  |
----------

What I would like it to look like is (table 2):

|Date      |  A  |  B  |  C  |
----------
|06/10 2:00pm|  65 |  44 |  33 | 
----------
|06/10 2:02pm  |  12 |  55 |  21 | 
----------
.....
|06/10 1:58am | 23 | etc.  | etc. |
----------


(sorry for the format)

Some problems that  encounter (doesn't work with code I have found online)
I'd like to run this as a stored procedure (rather a SQL job), every 2 minutes so that this data from table 1 is constantly being moved to table 2.  However I think I would need to alter the date every single time? (thats the syntax I've seen)
The pivot table itself seems simple on its own, but the datetime has been causing me grief.
Any code snipets or links would be greatly appreciated.

Thanks.