Flatten rows into a single row
750906Aug 4 2010 — edited Aug 6 2010Hi All,
I have a table1 with records and PK for table 1 is (Date,Time).
All I have to do is for a particular transaction, I have to get all the records and flatten them into a single row.
For ex: Table 1 has the following
Date Time Col1 Value
08/03/2010 10:00am Employee_name John
08/03/2010 10:00am Employee_ID 20
08/03/2010 10:00am Salary 10000
Now I have a table 2 which has the following structure:
Date Time Employee_name Employee_ID Salary
08/03/2010 10:00am John 20 10000
Please let me know how to achieve this.,
Thank You.