SQL Temp Tables, Cursor

DECLARE @TempTableNames TABLE ( Name NVARCHAR(MAX), ResultTable NVARCHAR(MAX) )
INSERT INTO @TempTableNames
SELECT DISTINCT CollectionName, ResultTableName
FROM [CM_PS1].[dbo].[Collections]

DECLARE @TempCollectionStats TABLE ( Name NVARCHAR(MAX), XP_Count INT, Win7_Count INT)
DECLARE @XPCnt INT
DECLARE @7Cnt INT
DECLARE @Para NVARCHAR(MAX)
DECLARE @SQL    NVARCHAR(MAX)
DECLARE @TableName NVARCHAR(MAX)
DECLARE @CollName NVARCHAR(MAX)
DECLARE MY_CURSOR CURSOR
    LOCAL STATIC READ_ONLY FORWARD_ONLY
FOR
SELECT DISTINCT Name, ResultTable
FROM @TempTableNames

OPEN MY_CURSOR
FETCH NEXT FROM MY_CURSOR INTO @CollName, @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
    Print @CollName
    Print @TableName
    SET @SQL = 'SET @XPCnt = (SELECT COUNT(*) FROM [CM_PS1].[dbo].[' + @TableName + '] WHERE DeviceOS like ''%Workstation 5%'')'
    SET @Para = '@XPCnt NVARCHAR(10) OUTPUT'
    EXECUTE SP_EXECUTESQL @SQL,@Para,@XPCnt = @XPCnt OUTPUT

    SET @SQL = 'SET @7Cnt = (SELECT COUNT(*) FROM [CM_PS1].[dbo].[' + @TableName + '] WHERE DeviceOS like ''%Workstation 6%'')'
    SET @Para = '@7Cnt NVARCHAR(10) OUTPUT'
    EXECUTE SP_EXECUTESQL @SQL,@Para,@7Cnt = @7Cnt OUTPUT

    INSERT INTO @TempCollectionStats VALUES(@CollName,@XPCnt, @7Cnt)

    FETCH NEXT FROM MY_CURSOR INTO @CollName, @TableName
END
CLOSE MY_CURSOR
DEALLOCATE MY_CURSOR

SELECT * FROM @TempCollectionStats WHERE XP_Count > 0 AND Win7_Count > 0