INSERT INTO Schedule (schStartTime, schEndTime, schNote, sId, hId, cId,
schPending) VALUES (@startDT, @endDT, @Note, @sAlias, @hName, @cName, 5)
I'm not sure, but what is the type of hId and cId, they seem IDs to me, and you're assigning string values to them, @hName and @cName. Can you post the structure of your table.....