I want to save a new (record)order in purchase order table for an existing user.
asked
want to save a new order in purchase order table
basically you use the INSERT command to do this.
What's the problem you are facing ?
when I executed the stored proc I do not see the order, I had declared in the purchase order table thru the below query.I am not sure which store proc to execute I am trying to insert an order thru a query for an exisitng customer in the purshase order table. please correct the below query as i see the error as below... (1 row(s) affected) Msg 2812, Level 16, State 62, Line 3 Could not find stored procedure 'dbo.SPI_Ord_PurchaseOrder'.
DECLARE @TrackingNumber VARCHAR(50) SELECT TrackingNumber='726013' Execute dbo.SPI_Ord_PurchaseOrder @Name='NULL',@SoldToId ='',@SoldToAddressId='',@LineItemCount='1', @ShippingTotal='4.9900',@HandlingTotal='0.0000',@TaxTotal='0.6600',@SubTotal='11.0000', @Total='16.6500',@Created='3/25/2010 9:40:11 PM',@LastModified='3/25/2010 9:38:32 PM', @ModifiedBy='',@TrackingNumber='726008',@BasketId='2bb080b1-61c5-4ec3-89b5-c7b4a51661f2', @BillingCurrency='',@Status='AtWarehouse',@SoldToName='aaa', @MarshalledData='',@RefundedTotal='0.0000',@OrderGroupId='9a9b14a8-e6d0-49f8-a5d0-7ea3326eaec0'
--Execute dbo.SPI_Ord_PurchaseOrder --EXECUTE dbo.SPS_Ord_PurchaseOrder --EXECUTE dbo.SPD_Ord_PurchaseOrder --EXECUTE dbo.SPE_Ord_PurchaseOrder
