Rows to column in sql server 2000 - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Rows to column in sql server 2000

starman_68starman_68 Posts: 8Member
I am creating a report from a table that stores data as follows:
ID Name Activity Date Total
1 John Doe Play 2009-06-01 1
2 Jane Doe Run 2009-06-01 2

but i need to get the report in the format of

Name Play Run Total
John Doe 1 0 1
Jane Doe 0 2 2

i am unsure how to generate this result, any help would be great
Sign In or Register to comment.