use dynamic sql to output the result

DECLARE @sql1 nvarchar(400)

DECLARE @table_name varchar(50)

 

SET @table_name =(SELECT name FROM sysobjects where name = 'source_system' )

--SELECT name FROMsysobjects where name = 'source_system'

 

SET @sql1 = 'SELECT COUNT(*) FROM ' +@table_name

 

EXEC SP_EXECUTESQL@sql1,N'@count bigint output',@count output