Thursday, March 29, 2012

changing the structure of data in a table

I have a table that looks like this:
ID Type
123 Phone
123 Meeting
123 Phone
and I would like the data to look like this
ID phone Meeting
123 2 1
How do I do this?Search for crosstab, but I am sure someone will post you a code, just sit tight :)|||Code Please ?|||See this:

http://www.dbforums.com/showthread.php?threadid=978654sql

No comments:

Post a Comment