Print Out From Dynamic Query

All,

I need help on the procedure below. this procedure gets intput table_name and do a row count. I want to print out the result from the Dynamic query within the procedure.



Thanks in advance



create PROCEDURE [dbo].[SRC_sp_Batch_test]

@table_name as varchar(50)

AS

DECLARE @execstr2 as varchar(1000)

declare @count as varchar(10)





set @execstr2 = 'select count(*) as count1 from ' + @table_name

exec (@execstr2)


-- want to print out the records count from executing @execstr2

set @count = count1

print @count

print 'here'