What? Huh? This can't be...can it? Well this person seemed to think so:
http://www.dbforums.com/showthread.php?t=1219537
I didn't think that this was possible...and, well, it isn't...so I am posting this for future reference....and to start blogging all things SQL again
USE Northwind
GO
CREATE TABLE myTable99(Col1 int)
GO
INSERT INTO myTable99(Col1)
SELECT 1 UNION ALL
SELECT 2 UNION ALL
SELECT 3 UNION ALL
SELECT null UNION ALL
SELECT null UNION ALL
SELECT null
GO
CREATE PROC mySproc99 @Rows int OUTPUT AS
SELECT @Rows = COUNT(*) FROM myTable99 WHERE Col1 IS NULL
GO
DECLARE @Rows int
EXEC mySproc99 @Rows OUTPUT
SELECT @Rows
DECLARE @cmd varchar(8000), @sql varchar(8000)
SELECT @sql = 'DECLARE @Rows int EXEC mySproc99 @Rows OUTPUT SELECT @Rows'
SELECT @cmd = 'osql -U sa -P <password>-S <servername> -d Northwind -Q "' + @sql + '"'
EXEC master..xp_cmdshell @cmd
GO
DROP PROC mySproc99
DROP TABLE myTable99
GO