Just to clarify the above posts (in case you are directed here while looking in regards to SQL 2005)

Use this code for 2005:

/*FIND WAIT RESOURCE BY SPID*/

/*harvested and adjusted from...