ALTER PROCEDURE [dbo].[createTempDBUpdateTables]
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
create table #temp_currency(
	currency_code char(3) not null primary key ,
	exchange_rate money not null
)

--- Create temp supplier table

create table #temp_supplier(
	supplier_id int not null primary key,
	supplier_name nvarchar(64) not null
)

-- Create #temp parts table
create table #temp_part(
	part_id nvarchar(35) not null primary key,
	description nvarchar(64),
	internal_description nvarchar(64),
	price money not null,
	currency_code char(3) not null,
	supplier_id int not null
)

END