Feb. 10th, 2009

dchenes: (Default)
Yay!

Got the week before Easter off. If I don't take a week off from this job about every 4 months, I get burned out. So, December (which I get anyway because the place is closed), April and August it is.

When I'm not cleaning things during that week, what should I do? I think I want to go to the aquarium, because I haven't been there in years.

Also yay, I love my teeny little useful database. Otherwise coming up with a list of the last 100 full professors promoted would have been a serious pain in the neck. Instead I just told a query that I wanted the professors from academic year 2006-present that were not second appointments or clinical professors. Then I knocked the extra 39 names off the list and that was that. (I bet there's a way to get it not to give me the extra 39 names, too, but I was in something of a hurry.)

This is precisely the sort of thing I set up this database for, particularly because nobody ever asks for the same set of data twice. So far it's given me all full professors by academic year, by department, by institution, by appointment type by month, by month by year, and the last 100 professors promoted. I love it when I get an idea that works.
Page generated Sep. 24th, 2025 11:34 am
Powered by Dreamwidth Studios