Indexes - Inequality Before Equality

USE master

SELECT OBJECT_NAME(indexes.object_id) AS table_name,
       indexes.name AS index_name,
       columns.column_name,
       columns.type_name,
       columns.key_ordinal,
       columns.key_column_count
  FROM (
       SELECT index_columns.object_id,
              index_columns.index_id,
              columns.name AS column_name,
              types.name AS type_name,
              index_columns.key_ordinal,
              COUNT(*) OVER (PARTITION BY index_columns.object_id, index_columns.index_id) AS key_column_count
         FROM sys.index_columns
        INNER JOIN sys.columns ON index_columns.object_id = columns.object_id
          AND index_columns.column_id = columns.column_id
        INNER JOIN sys.types ON columns.system_type_id = types.system_type_id
          AND columns.user_type_id = types.user_type_id
        WHERE index_columns.key_ordinal > 0
       ) AS columns
 INNER JOIN sys.indexes ON columns.object_id = indexes.object_id
   AND columns.index_id = indexes.index_id
 WHERE type_name LIKE 'date%'
   AND key_ordinal < key_column_count
 ORDER BY table_name ASC
OPTION (RECOMPILE)