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