Well, if there's a solution to the question, I'd love to learn it, but I've been able to restructure my table's key fields to make this all work.
OK, so this gets me one step closer to where I need to be, the second step I need to take is to ensure I don't add the same record multiple times. The way I would normally accomplish this would be an insert statement with a "where keyfield not in (select from table where keyfield = keyfieldparameter). In the DB design this isn't looking at the primary key field, but at a field that should be unique within a calendar year. There's a long-story reason for this, but the options for "Insert Ignore" or...
Thank you for the link, Alin!
So, I'm hoping someone can help me with this. I'm working on my first Android app and using the net.sourceforge.jtds.jdbc.Driver to connect back to our primary database. I'm able to connect and retrieve data, which is great. Now, what I'd like to do is to call a stored procedure and send a 'datatable' (result set?) parameter. I'm getting stuck on the syntax and haven't found any examples of how to do this, exactly. Perhaps it's not feasible? Technically, for clarity's sake, on the SQL SP it's a user...