:35525743  SELECT NON EMPTY { [Measures].[Cost Sales], [Measures].[Margin], [Measures].[Quantity Ordered] } ON COLUMNS, NON EMPTY { ([Product].[Products].[Discontinued].ALLMEMBERS * [Time].[CalendarSales].[Month].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM [NorthWindDW_SSAS] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

SELECT ID
FROM (SELECT TOP 3 DISTINCT ID, n =  NEWID() FROM X_LARGE_TABLE ORDER BY n)

SELECT id
FROM
  ( SELECT id, rnk = RANK() OVER (ORDER BY NULL)
    FROM x_large_table_2
  ) AS x
WHERE rnk <= 2 ;

SELECT id
FROM
  ( SELECT id, rnk = ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
    FROM x_large_table_2
    GROUP BY id
  ) AS x
WHERE rnk <= 2 ;

WITH ct AS
  ( SELECT TOP (1) ID, found = 1
    FROM x_large_table_2
  UNION ALL
    SELECT TOP (1) ID, found + 1
    FROM ct CROSS JOIN x_large_table_2 AS x
    WHERE ct.found < 2
      AND x.id NOT IN (SELECT id FROM ct)
  )
SELECT id FROM ct ;

WITH ct AS
  ( SELECT TOP (1) ID, found = 1
    FROM x_large_table_2
  UNION ALL
    SELECT TOP (1) ID, found + 1
    FROM ct CROSS JOIN x_large_table_2 AS x
    WHERE ct.found < 2
      AND x.id <> ct.id
  )
SELECT id FROM ct ;

WITH ct AS
  ( SELECT TOP (1) ID, found = 1
    FROM x_large_table_2
  UNION ALL
    SELECT y.ID, y.found + 1
    FROM
      ( SELECT x.id, ct.found
        FROM ct CROSS JOIN x_large_table_2 AS x
        WHERE ct.found < 2
          AND x.id <> ct.id
      ) AS y
    WHERE y.rn = 1
  )
SELECT id FROM ct ;