LISTING 1: Code Snippet from sp_helpindex

SELECT
	'index_name' = index_name,
	'index_description' = convert(varchar(210),
	CASE WHEN (stats & 16)<>0 THEN 'clustered' ELSE 'nonclustered' END
				+ CASE WHEN (stats & 1)<>0 THEN ', '+@des1 ELSE @empty END
				+ CASE WHEN (stats & 2)<>0 THEN ', '+@des2 ELSE @empty END
				+ CASE WHEN (stats & 4)<>0 THEN ', '+@des4 ELSE @empty END
				+ CASE WHEN (stats & 64)<>0 THEN ', '+@des64
					ELSE CASE WHEN (stats & 32)<>0 THEN ', '+@des32
						ELSE @empty
					    END
				   END
				+ CASE WHEN (stats & 2048)<>0 THEN ', '+@des2048 ELSE @empty
					 END
				+ CASE WHEN (stats & 4096)<>0 THEN ', '+@des4096 ELSE @empty 
					END
				+ CASE WHEN (stats & 8388608)<>0 THEN ', '+@des8388608
					ELSE @empty
				   END
				+ CASE WHEN (stats & 16777216)<>0 THEN ', '+@des16777216
					ELSE @empty
				   END
				+ ' located on ' + groupname),
		'index_keys' = index_keys
	FROM #spindtab