How did I not know sqlserver could do temporary stored procedures?! ad hoc scripts can get so much easier now...