Dynamic SQL query with Columns

Declare @sql nvarchar(4000), @Table varchar(25), @BatchNo varchar(25)
, @BatchCol varchar(25),@IDColumn varchar(25), @Max int, @Loopcount int
,@returnValue int, @Statement nvarchar(4000)

set @Statement = N'
SELECT @result = Count(1) 
from [CKOLTP_Staging].dbo.[@TableValue] tbl (nolock)
where tbl.[@BatchColValue] = Convert(varchar(10),@BatchNoValue)'
exec sp_executesql @Statement, 
    N'@TableValue varchar(25)
	,@BatchColValue varchar(25) 
	,@BatchNoValue varchar(25)
	,@result INT OUTPUT', 
    @TableValue = @Table
	,@BatchColValue = @BatchCol
	,@BatchNoValue = @BatchNo 
	,@result=@returnValue OUTPUT    

Select allOpen in new window

Msg 208, Level 16, State 1, Line 5
Invalid object name 'CKOLTP_Staging.dbo.@TableValue'.

Select allOpen in new window