pro tip: use stored procedures instead of copy/pasting SQL code blocks over and over

I'm not sure how common this is, but I've seen some analytics people copy and paste SQL code many times, where there's some slight variation. Say, doing a similar transformation but on different columns. It causes the length of the code to blow up.

Just like using functions in programming, you can do for loops, if/then conditions, take input arguments, etc.

But for the love of god please don't copy and paste a code block 20 times lol.

code datascience sql sql code