use testDatabase
GO

CREATE TYPE Customer AS TABLE (id int, CustomerName nvarchar(50), postcode nvarchar(50))
GO

CREATE TABLE Customers (id int, CustomerName nvarchar(50))
GO

CREATE TABLE CustomerPostCodes(id int, postcode nvarchar(50))
GO

/*
INSERT INTO Customers VALUES (1, 'Bob')
INSERT INTO CustomerPostCodes VALUES (1, 'ASD')
INSERT INTO Customers VALUES (2, 'Jack')
INSERT INTO CustomerPostCodes VALUES (2, 'QWE')
INSERT INTO Customers VALUES (3, 'Gill')
INSERT INTO CustomerPostCodes VALUES (3, 'ZXC')
GO
*/

CREATE Procedure AddCustomers(@customer Customer READONLY) 
AS 

INSERT INTO Customers
SELECT id, CustomerName FROM @customer

INSERT INTO CustomerPostCodes
SELECT id, postcode FROM @customer

GO

DECLARE @myNewCustomer Customer;
INSERT INTO @myNewCustomer VALUES (1, 'Harry', 'NEW')
EXEC AddCustomers @myNewCustomer
GO

SELECT * FROM Customers
SELECT * FROM CustomerPostCodes
GO

drop table Customers
go
drop table CustomerPostCodes
go
drop procedure AddCustomers
go
drop type Customer
go