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

Web: https://www.reddit.com/r/datascience/comments/vixbr1/pro_tip_use_stored_procedures_instead_of/

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