Dear Scott thanks for your reply,
Please check the below query,I have used palsatish query.Need to add where condition in that.
Alter procedure tabproc
(
@tablename Varchar(500)
)
as
begin
EXEC('Select count(*) from '+@tablename where isactive=0 )
End
I'm...