could someone show any way to do that?

See
http://msdn.microsoft.com/library/de.../distinct2.asp

This method does not rely on using the distinct count aggregate so it will
work with custom rollup operators.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> wrote