thousands of lines long that take ~30 minutes
Oh yea!!! Well I have 76 lines of code that takes up to 18 hours to run for 1 client!!!!!
/s
Haha I only mentioned the run time to provide some context, since a lot of people have only ran OLTP queries that take less than a few seconds to run.