You won't be able to use this function in SQL. It's an MDX function.

If you're starting to dive into Analysis Services and MDX, I'd suggest the following book:
http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=0471400467&vm=

Also be warned that MDX is not SQL. It's set oriented, recursive, and iterative all at the same time <s>

-Mike

>Does anyone have a sample (or doc or website) of using the correlation operator in SQL ?