Rotate SQL tables

 I need rotate a relative big table (~100K rows)

The source table:

idenvdate
1yahoo1/1/3
2igoogle1/1/4
3vista1/2/4
4igoogle1/1/2
5iphone12/12/02

 

Target table or query result set must be:

  iphoneigoogleyahoovista
  1211

 

I need (in single SELECT) count rows grouping by 'env' and create result as shown before.

Any ideas?

 

Developer