Don't know how big the sproc is but it has an 870 lines(+-) select query. It joins data from around 50 tables doing multiple agregates and uses variuouse functions. It basicaly does statistics on a conected graph with tens of thousants of lines at the
largest level. It also has some comments and not all lines are sql statements. No temporary tables are used in the query.