Check out this bug report - http://connect.microsoft.com/SQLServer/feedback/details/464339/unsupported-data-type-reported-for-supported-data-types-in-nested-query

It appears to be a long standing issue from SQL 2005 which they still havent fixed.

The work around appears to be to not work with your view in design mode, you will have to develop this view manually in query analyzer.

SQL VIEW Unsupported Data Type
A coin having probability $p$ of coming up heads is successively flipped until the $r^{th}$ head appears. Let $X$ be the number of flips required. Find the probability $P(X=n)$. 

So this means I need to find the probability that $n$ flips are needed to get the $r^{th}$ head. I am not sure how to proceed. Any help/clarification please?

Thank you. 
