Hey,

I need to write two stored procedures and link them to a button on a web form. Basically I have a web form called OrderAllocation.aspx This form takes orders and allocates them to ships (Orders and Ships being two different tables). This "allocation" involves adding the select order and ship to a new table called OrdersonShip. I need to write the two stored procedures so that 1) I can get that the Ship has space to take the order and that the ship isn't full already. 2) If the ship is able to take the order insert a new line in the OrdersonShip table (consisting of the ShipID and OrderID) and then add the value of the order (NumofItems) to the currentnumofCargo of the ship in the Ship table. To me it sounds horribly complicated, but I have no idea how to start. I have looked at a few guides online but they don not seem to help, or they don't go as indepth as I need them to.

Below is a link which shows my database diagram.


http://img396.imageshack.us/img396/8...diagramtn6.jpg

Many thanks for any help, it's driving me mad working our where I should start and what to do to complete this task.

Peter

Not sure how this equates to two sprocs. Without knowning any of the business rules of your database, I assume, something like this would work:

CREATE PROCEDURE usp_ShipOrder
(
   --Any Params
)
AS

if (SELECT Sum(NumberofCargo - CurrentNumOfCargo) From Ship where ShipID = value) > 0
Begin
    --Space is available on the ship, add the record
End
Else
Begin
    --Space is not available on the ship, exit
End

Does that make sense?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

you need to give more info if you want more help......