CREATE PROCEDURE [dbo].[q_GetCOO_byItemID] @ItemID varchar(max) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; select country_of_origin from inventory_supplier inner join inventory_supplier_x_loc on inventory_supplier_x_loc.inventory_supplier_uid = inventory_supplier.inventory_supplier_uid inner join inventory_supplier_trade on inventory_supplier_trade.inventory_supplier_uid = inventory_supplier.inventory_supplier_uid inner join inv_mast on inv_mast.inv_mast_uid = inventory_supplier.inv_mast_uid where inv_mast.item_id = @ItemID and primary_supplier = 'Y' and location_id = '10' END
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)