Just some advice to any and all newbies... when you're trying to learn something new and you've gotten done with the proverbial "Hello World" examples, the very next thing you should do is spend a week or two studying and playing with the intrinsic functions and operators of whatever language you're using. The first week should be "by the book learning" and the second week should be done doing Google searches on special ways to use those functions and operators for things they weren't specifically designed for and there will be no similar examples "in the book".
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
When you put the right degree of spin on it, the number 3|8
is also a glyph that describes the nature of a DBAs job. 😉
How to post code problems
Create a Tally Function (fnTally)