group by - COUNT(DISTINCT) in multiple columns in SQL Server 2008 - Stack Overflow

In Oracle, it's possible to get a count of distinct values in multiple columns by using the || operator (according to this forum post, anyway): SELECT COUNT(DISTINCT ColumnA || ColumnB) FROM MyTable Is there a way to do this in SQL Server 2008? I'm trying

stackoverflow.com