I'm trying to create a SP that can return a count of rows for a specified table, column and column value. I get an error that states "Must declare the variable @tcTable".

Any ideas?

Doug

Here's the SP ...

CREATE PROCEDURE get_count @tcTable varchar(30), @tcColumn varchar(30), @tnValue integer AS

declare @nCount integer

select @nCount = count(*) from @cTable where @tcColumn = @tnValue

RETURN @nCount
GO