Interesting idea. Is there a place where this makes sense or where you want to stream a result set back in your applications?

Does SSMS do this? It seems that I'll get data on some larger queries while it's still returning other data, or is that just a network/rendering delay as things are transferring?