[grey_whiskers]

Don't forget the UNION ALL statement ☺

[Fellow Traveler]

I can remember Union all and case statements, it is those dang window functions I have to look up every time. Partition by, over, order by. Never can remember that syntax.