>
>You're selecting from #temp but created #Results table. I am wondering why you don't get an error. Also, please add aliases for all columns.

good catch, thanks. However I'm still not getting any columns when selecting this SP in the tableadapter. :(

I get this error in the Visual Studio TableAdapter:

Invalid object name '#Results'

update

I found this solution posted on-line:

"Add these lines to the beginning of your sp:

IF 1=0 BEGIN
SET FMTONLY OFF
END"

It works!