>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?

Try something like this:

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

AS

CREATE TABLE #getcount
(countis     int)

EXEC (
'DELCARE @nCount integer
SELECT @nCount = count(*) FROM '+@cTable+' WHERE '+@tcColumn+' = '+@tnValue
'INSERT #getcount (countis) VALUES (@nCount)'
)

declare @nCount integer

select @nCount = countis from #getcount

RETURN @nCount
GO 

BOb