Transact SQL for SQL 2005 to work with a integer array like structure

Transact SQL for SQL 2005

CREATE PROCEDURE getNodes
  @isActive bit
AS
  BEGIN
    -- Declare a single column table to be used as a single dimension array
    DECLARE @activeNodes TABLE (id int)
    
    -- Only if the following condition is satisfied, 1070 will be added to the pseudo-array
    IF @isActive = 1
      INSERT INTO @activeNodes(id) VALUES (1070)

    -- 1067 and 1069 will be anyhow added to the pseudo-array
    INSERT INTO @activeNodes(id) VALUES (1067)
    INSERT INTO @activeNodes(id) VALUES (1069)
    
    -- Now an IN clause could be used, really useful in more complex queries
    SELECT [nodeId],[xml]
	  FROM [cmsContentXml]
	  WHERE [nodeId] IN (SELECT id FROM @activeNodes)

  END

GO