I have a form which inserts data in to a sql db with an INSERT INTO. I would like to be able to allow a user to only input 10 records (limiting due to the inputs being 10 free advertisements). I am fairly confident that I have written a sp which will accomplish that, however, I do not know how to do the INSERT and have the sp monitor the inserts at the same time.
As an example, Bing Webmaster allows a user to insert 10 URLs per day for indexing. As each URL is submitted, there is a counter which decreases by 1 each time a URL is submitted, and at 0, no more URLs may be submitted.
Is it possible to run an INSERT and sp at the same time? If so, I would appreciate being pointed toward on-line documentation to accomplish such. Or, any guidance on how to accomplish this would be appreciated.