Reading Query From .sql File Error

I have a report that is based on a query that is read from a .sql file and is executed in the stored procedure. I found this code on the internet. When I run the SP in Query Analyser it tells me that "2 rows have been affected". I don't know why I don't get the data. Any help??





Stored procedure:





CREATE PROCEDURE TimeTracker_Report_ClientNumbers2





AS


DECLARE @SQLQuery as NVARCHAR(4000)


BEGIN


CREATE TABLE #tmpQuery (Query NVARCHAR(4000))


BULK INSERT #tmpQuery FROM '\servernameQueriesReport_ClientNumbers.sql'


SELECT @SQLQuery = Query FROM #TMPQUERY


EXECUTE sp_executesql @SQLQuery


END


GO





and Report_ClientNumbers.sql contains the following query:





SELECT Name, ClientNumber FROM Companies WHERE Not ClientNumber IS NULL ORDER BY ClientNumber