Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mindgasm
Starting Member
2 Posts |
Posted - 2008-06-13 : 15:07:23
|
Hello everybody,
I'm having a dataset of the following form with approx. 35000 records: Date Object 7/11/2000 08.2 7/11/2000 08.3 7/11/2000 5239.200 4/10/2001 3471.100 20/06/2002 7007 20/06/2002 7007.100 20/06/2002 7007.500 20/06/2002 7007.521 ... ... ...
I would like to combine all rows for each date into one row. So for the example-data above this would ideally result in: 7/11/2000 08.2 08.3 4/10/2001 3471.100 20/06/2002 7007 7007.100 7007.500 7007.521 ... ...
I work with Access 2007. I know that there are some similar questions on this forum, but they all have PL/SQL solutions.
Any help would be greatly appreciated.
Kind regards, K |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-13 : 15:10:05
|
Moving your thread to the Access forum.
I doubt any solutions here are for PL/SQL since that's Oracle and not SQL Server. SQL Server's language is T-SQL.
Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/
Subscribe to my blog |
 |
|
mindgasm
Starting Member
2 Posts |
Posted - 2008-06-13 : 15:19:19
|
quote: Originally posted by tkizer
Moving your thread to the Access forum.
I doubt any solutions here are for PL/SQL since that's Oracle and not SQL Server. SQL Server's language is T-SQL.
Tara Kizer Microsoft MVP for Windows Server System - SQL Server http://weblogs.sqlteam.com/tarad/
Subscribe to my blog
Oh yes, you're right. I once heard of procedural languages in SQL, so I thought it was all PL/SQL. My apologies. |
 |
|
|
|
|