AS
IF @Filter IS NULL OR @Filter=''
EXEC('SELECT COUNT(*) AS RecordCount FROM '+@Tbname)
ELSE
EXEC('SELECT COUNT(*) AS RecordCount FROM '+@Tbname+' WHERE '+@filter)
AS
IF @Filter IS NULL OR @Filter=''
EXEC('SELECT COUNT(*) AS RecordCount FROM '+@Tbname)
ELSE
EXEC(SELECT COUNT(*) AS RecordCount FROM '+@Tbname+' WHERE '+@filter+')