SET @count = (SELECT COUNT(*) FROM @myTable)
SET @SQLcmd = 'SET @NumRecs = (SELECT COUNT(*) FROM @myTable)'
EXEC(@SQLcmd)
CREATE TABLE #tmp_count (cnt int)
SET @SQLcmd = 'INSERT INTO #tmp_count SELECT COUNT(*) FROM @myTable'
EXEC(@SQLcmd)
SELECT @NumRecs = cnt FROM #tmp_count
SET @lcParam = N'@lcResult AS nvarchar(4000) OUTPUT'
SET @lcSQLcmd = '
DECLARE @lnCount AS int
SELECT @lnCount = (SELECT COUNT(*) FROM @myTable)
SET @lcResult = CAST(@lnCount AS varchar)'
EXEC sp_executesql @lcSQLcmd, @lcParam, @lcResultString = @lcResult OUTPUT
SELECT @lcResult