-- CWM Metastore: Accessing Multivalued Attributes of Machine 
--
DECLARE @result INT
DECLARE @name VARCHAR(256)
DECLARE @ID INT
DECLARE @Value VARCHAR(256)
DECLARE @cursor CURSOR
EXECUTE @result = Get_SoftwareDeployment_Machine_name 1, @name OUTPUT
IF @result = 0
   EXECUTE @result = GetCursor_SoftwareDeployment_Machine_ipAddress 1, 
      @cursor OUTPUT
IF @result = 0
BEGIN
   PRINT 'The ' + @name ' machine is known by the IP addresses:'
   FETCH NEXT FROM @cursor INTO @ID, @Value
   WHILE @@Fetch_Status = 0
   BEGIN
      PRINT '   ' + @Value + ' (Metastore ID = ' + 
                CONVERT(VARCHAR, @ID) + ')'
      FETCH NEXT FROM @cursor INTO @ID, @Value
   END
END
CLOSE @cursor
DEALLOCATE @cursor
GO