Rows to column in sql server 2000

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.

Howdy, Stranger!

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