SQL Finding the size of query result

Question

So basically I'm doing a SQL select query, but I want to know how much data I am pulling back (how many kilobytes), any way?

Answer 1

Actually, "Show Client Statistics" within SSMS query Editor Window will return the resultset size, Bytes Received from Server, etc

Answer 2

SELECT <your query here>
INTO dbo.MyTempTable
FROM <query source>

exec sp_spaceused 'MyTempTable'

DROP TABLE MyTempTable

This wlil Return Rows, Reserved Space, Data space (in KB), Index space, and unused space for that table.