-- What SQL Statements Are Currently Running?

SELECT [Spid] = session_Id

, ecid

, sp.blocked as 'Blocked By'

, [Database] = DB_NAME(sp.dbid)

, nt_domain

, [User] = nt_username

, sp.loginame

, sp.cmd as 'Command'

, [Status] = er.status

, [Wait]...

Try using Pivot. Follow the link for example

http://msdn.microsoft.com/en-us/library/ms177410(v=sql.105).aspx