CREATE PROCEDURE ps_ShipItems
@CODTrackingNo nvarchar(50),
@DateShipped smalldatetime,
@InvoiceNo nvarchar(50),
@ShippedBy nvarchar(50),
@ShipQty int,
@SODetailID int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
Insert Into SalesOrder_detailTracking
(
TrackingNumber, Datecode, MfgPN, MFGRName, RoHS, SupplierName, Comments, InternalNo,
SalesOrderNumber, DateShipped, InvoiceNumber, ShipQty, CODTrackingNumber, ShippedBy, SalesOrderDetailID
)
VALUES
(
(select T.TrackingNumber from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.Datecode from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.MfgPN from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.Mfgr_Name from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.RoHS from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.SupplierName from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.Comments from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select T.InternalNo from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
(select d.SalesOrderNumber from PurchaseOrder_detailTracking T inner join PurchaseOrder_details D on T.PurchaseOrderDetailID = D.PurchaseOrderDetailID inner join PurchaseOrder_header H on D.PurchaseOrderHeaderID = H.PurchaseOrderInfoID WHERE H.SalesOrderDetailID = @SODetailID),
@DateShipped, @InvoiceNo, @ShipQty, @CODTrackingNo, @ShippedBy, @SODetailID)
END
GO
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE