Combining Multiple rows

		Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Combining Multiple rows

SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

February 23rd, 2007, 05:23 AM

LateBinding LateBinding is offline

Registered User

Join Date: Feb 2007

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Combining Multiple rows

Hi
I have a table that has got this field

id1
scode1
score
id1
scode2
score
id1
scode1
score
id2
scode3
score
id2
scode1
score
id2
scode2
score
how can I combining all rows into format like this
stdid scode1 scode2 scode3 scoden
id1 score score score score
id2 score score score score
idn score score score score

thanx

Alwayz drink Beer to save Water

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining the average of multiple rows into one	Saidar	SQL Server 2005	2	December 24th, 2007 03:45 AM
Highlighting multiple rows	nzhang	ASP.NET 2.0 Basics	1	June 21st, 2006 11:12 PM
Copying Multiple Rows	raj_phoenix	Excel VBA	3	May 6th, 2005 03:58 AM
print multiple times..multiple rows...	abhit_kumar	JSP Basics	3	January 18th, 2005 07:11 PM
Updating multiple Rows from multiple fields in ASP	vdm_nana	SQL Server ASP	0	April 1st, 2004 04:26 AM