Is INDEXPROPERTY(<table id>, <index name>,' IndexDepth') the same value as
DBCC SHOWCONTIG TABLERESULTS output column 'Level'?

[OT] SQL Humor
composite key structure
Default Column Values
Finding similar sales
return set of only first unique row