CREATE PROCEDURE [dbo].[GetProcessorCount]
@ProcessorCount INT = 0 OUTPUT,
@PrintHelp BIT = 0
AS
SET NOCOUNT ON
IF @PrintHelp = 1
PRINT 'DECLARE
@ReturnVal int,
@ProcessorCount int
EXEC @ReturnVal = dbo.GetProcessorCount
@ProcessorCount = @ProcessorCount OUTPUT
SELECT @ReturnVal as ''@ReturnVal'', @ProcessorCount AS ''@ProcessorCount''
'
PRINT 1
DECLARE @numprocs TABLE (id INT,
colname VARCHAR(128),
IV INT,
CV VARCHAR(128))
INSERT @numprocs(id, colname, IV, CV)
EXEC master..xp_msver 'ProcessorCount'
SELECT @ProcessorCount = IV
FROM @numprocs
WHERE colname LIKE '%ProcessorCount%'