>
>In the first, you are only creating the view. You aren't actually returning records. In the second, you actually return the records.


Yes, you're quite right. I was in dork mode. Frustrated because I still haven't solved the parameterised view problem I posted the other day. So I was trying to repeat the process in the command window and I forgot to "USE" after creating.

DOH!