pretty random

Note: this is just being posted for me in case I need it and for those poor long-suffering google searchers who can't find this solution easily as it's pretty well-hidden!

The problem: make an event in Outlook (single event or recurring), and invite people to it. Later, your synchronization app like Google Calendar Sync syncs everything up like it always does. However, the next time you want to modify that meeting (like add another person, or cancel it) you can't, because Outlook no longer believes you're the owner!

Note: THE FIXES BELOW ARE NOT MY CODE. DON'T ASK ME HOW TO CHANGE IT PLEASE. I don't know VBA. This is just to help you get a head start if you need it, and for my own reference.


( The fix! )

I am so awesome. Not really. But I figured out how to do this all by myself:

select i.lastname,i.firstname,count(ic.instructorid) as 'Number of Courses' from instructor as i,instructorcourse as ic where i.type='Facilitator' and i.instructorid = ic.instructorid group by i.lastname,i.firstname

This is primarily for my future reference.