Validate Order

INSERT INTO [TyreSanner].[dbo].[Link_OrderProduct](OrderFK, ProductFK, ProductQuantity, TotalProductSaleCost, FittingDate, FittingTime)
SELECT @OrderFK,  @ProductFK,  @ProductQuantity, @TotalProductSaleCost, @FittingDate, @FittingTime
WHERE EXISTS (SELECT 1
FROM OrderTable
WHERE OrderID = @OrderFK)

---

Please Mark This As Answer if it solved your issue

Please Mark This As Helpful if it helps to solve your issue

Visakh

----------------------------

My MSDN Page

My Personal Blog

My Facebook Page