I believe what you want is the CROSS APPLY function: https://technet.microsoft.com/en-US/library/ms175156(v=SQL.105).aspx

I was having similar problems. I discovered that the ASP.NET State Service had not been started. After starting it (and setting it to automatic) I as able to...