Eirikur Eiriksson (4/8/2014)
hisakimatama (4/8/2014)
EDIT: Doh, forgot the closing parenthesis.The parenthesis where the problem, a CTE does not require the columnar declaration.
😎
Aha, so it doesn't :-). I've always declared CTEs with the column declarations, and by the wonderful problems of habit, it stuck as "the" way to do it. Well, I learned something that should make syntax a good bit clearer myself 😀
- 😀