My Table Invoice and LineItem arent outputting its values :     enter code here SET NOCOUNT ON
    Create Database FinalDatabase
    GO

    USE FinalDatabase
    GO
 


    /*
    Create tables
    */

     Create TABLE tblSalesPerson
     (
     SalesID INT IDENTITY(1,1)PRIMARY KEY,
     FName VARCHAR(24) NOT NULL,
     LName VARCHAR(24) NOT NULL,)

     GO

     Create TABLE tblCustomer
     (
      CustomerID INT IDENTITY(1,1) PRIMARY KEY,
      Name VARCHAR(24)NOT NULL,
      Address VARCHAR(48)NOT NULL,
      City VARCHAR (48) NOT NULL,
      State VARCHAR (2)NOT NULL,
      ZIP VARCHAR (5)NOT NULL,
      Phone VARCHAR (10)NOT NULL,)

     GO

     Create TABLE tblItem 
     (
     ItemID INT IDENTITY (1,1)PRIMARY KEY,
     Description VARCHAR(100),
     UnitPrice MONEY)

     GO

    Create TABLE tblInvoice
    (
    InvoiceID INT IDENTITY(1,1) PRIMARY KEY,
    Date DATE NOT NULL,
    Subtotal MONEY ,
    SalesTax MONEY ,
    Total    MONEY ,
    ShipDate DATE,
    ShipHand MONEY NULL,
    CustomerID INT NOT NULL,
    SalesID INT   NULL
    )
    GO

    Create TABLE tblLineItem
    (
    LineItemID INT IDENTITY(1,1) PRIMARY KEY,
    Quantity   INT NOT NULL,
    Amount	   MONEY,
    UnitPrice MONEY,
    InvoiceID	INT NOT NULL,
    ItemID	INT  NOT NULL
    )

   GO



    --Echo a print statement that confirms result.
    PRINT 'Tables successfully constructed...'

    SET NOCOUNT OFF

    ALTER TABLE tblInvoice
    ADD CONSTRAINT Customer_ID_FK FOREIGN KEY (CustomerID)
    REFERENCES tblCustomer(CustomerID)
    GO

     ALTER TABLE tblInvoice
     ADD CONSTRAINT Sales_ID_FK FOREIGN KEY(SalesID)
     REFERENCES tblSalesPerson(SalesID)
     GO

     ALTER TABLE tblLineItem
     ADD CONSTRAINT Invoice_ID_FK FOREIGN KEY(InvoiceID)
     REFERENCES tblInvoice(InvoiceID)
     GO

     ALTER TABLE tblLineItem
     ADD CONSTRAINT Item_ID_FK FOREIGN KEY(ItemID)
     REFERENCES tblItem(ItemID)
     GO

     PRINT 'Foreign Key Constraints successfully applied...'

     -- Alters tblInvoice to require CustomerID 
     ALTER TABLE tblInvoice
     ALTER COLUMN CustomerID INT  NULL
     GO

     ALTER TABLE tblLineItem
     ALTER COLUMN ItemID INT  NULL
     GO


     --Cannot give away orders....must have a total


     PRINT 'NOT NULL Constraints successfully applied...'



     ALTER TABLE tblInvoice
     ALTER COLUMN Total MONEY NOT NULL
     GO


    PRINT 'NOT NULL Constraints successfully applied...'



    --If you have any default constraints

     PRINT 'DEFAULT Constraints successfully applied...'


     ALTER TABLE tblCustomer
     ADD CONSTRAINT Name_Phone_Unique UNIQUE(Name, Phone) -- makes this an  alternate key
      GO


     PRINT 'UNQUE Constraints successfully applied...'


    --Check to make sure Ship Date is in the future
    ALTER TABLE tblInvoice
    ADD CONSTRAINT ShipDate_Future_Check
    CHECK (ShipDate > Date)
    GO

    PRINT 'CHECK Constraints successfully applied...'


    SET NOCOUNT ON

    GO

    --Insert Customers

    BEGIN TRY
    BEGIN TRANSACTION

   --INSERT INTO tblCustomer 

    INSERT INTO tblCustomer (Name,Address, City, State, ZIP, Phone)
    VALUES ('Larry Bond',   '1225 Meddle St', 'Williamsburg', 'MS', '39457', '2286562989'),
	       ('Meagan Jones', '2345 Drive Rd', 'Mobile',		'AL', '36609', '2057849658'),
		   ('Calvin Brown', '2434 Dream St','Athens',		'GA', '45789', '7065894152'),
		   ('John White',   '9865 Treet St', ' Brooklyn',   'NY', '89575', '5489586325')

		
	
	PRINT 'Customers successfully inserted...'

	INSERT INTO tblSalesPerson(FName,LName)
	VALUES ('Larry', 'Bond'),
		   ('Meagan', 'Jones'),
		   ('Calvin', 'Brown'),
		   ('John','White')	 
  
	INSERT INTO tblItem(Description,UnitPrice)
	VALUES ('Go Jag T Shirts - Color Red – Size M','4.99'),
		   ('Jag Spirit Towels – Color White','1.25'),
		   ('Go Jag Red T – Size XL','4.99'),
		   ('Go Jag Red T – Size L','4.99')
  COMMIT TRANSACTION


     END TRY
     BEGIN CATCH
     DECLARE @ErrorMessage VARCHAR(500)
     SET @ErrorMessage = ERROR_MESSAGE() + ' Rolledback transaction: Customer insertions.'
     ROLLBACK TRANSACTION
     RAISERROR (@ErrorMessage, 16,1)
     END CATCH
     GO



       --SELECT * FROM tblCustomer





        --Insert Invoice And SaleItem

        BEGIN TRY

       BEGIN TRANSACTION
  
       DECLARE @CustomerID INT
      SET @CustomerID = (SELECT CustomerID FROM tblCustomer WHERE Name = 'Larry Bond' AND Phone = '2286562989')
  
       DECLARE @SalesID INT
       SET @SalesID = (SELECT SalesID FROM tblSalesPerson WHERE FName = 'Larry')
  
 
         INSERT INTO tblInvoice (DATE,Subtotal, Salestax,Total, ShipDate, ShipHand, CustomerID, SalesID)
          VALUES ('2010-8-6', '174.44', '1.44','186.87', '2010-8-6', '10.99', @CustomerID, @SalesID),
		   ('2010-8-7', '34.44', '5.44','50.87', '2010-8-6', '10.99', @CustomerID, @SalesID),
		   ('2010-8-8', '140.44', '5.44','156.87', '2010-8-6', '10.99', @CustomerID, @SalesID),
		   ('2010-8-9', '74.23', '1.44','86.86', '2010-8-6', '10.99', @CustomerID, @SalesID)
		   
          --Retrieve the newly created primary key to insert as a foreign key in tblLineItem
         DECLARE @InvoiceID INT
  DECLARE @ItemID INT
  
        SET @InvoiceID = @@Identity
  
        --Retrieve primary key of product for current listitem
        --Insert new row in tblLineItem
       SET @ItemID = (SELECT ItemID FROM tblItem WHERE Description ='Go Jag T Shirts - Color Red – Size M')

       INSERT INTO tblLineItem ( Quantity, Amount, UnitPrice, InvoiceID, ItemID)
       VALUES ('6', '52.66', '4.99', @InvoiceID, @ItemID)

       SET @ItemID = (SELECT ItemID FROM tblItem WHERE Description ='Jag Spirit Towels- Color White')
      INSERT INTO tblLineItem ( Quantity, Amount, UnitPrice, InvoiceID, ItemID)  
  VALUES ('4', '23.89', '1.25', @InvoiceID, @ItemID)

       SET @ItemID = (SELECT ItemID FROM tblItem WHERE Description ='Go Jag Red T- Size XL')
       INSERT INTO tblLineItem ( Quantity, Amount, UnitPrice, InvoiceID, ItemID)  
  VALUES	  ('5', '42.89', '4.99', @InvoiceID, @ItemID)

	SET @ItemID = (SELECT ItemID FROM tblItem WHERE Description ='Go Jag Red T-Size L')
	INSERT INTO tblLineItem ( Quantity, Amount, UnitPrice, InvoiceID, ItemID)  
	VALUES  ('3', '6.99', '4.99', @InvoiceID, @ItemID)

  

  
      END TRY
  
      BEGIN CATCH
      DECLARE @ErrorMessage VARCHAR(500)
      SET @ErrorMessage = ERROR_MESSAGE() + ' Rolledback transaction:  insertions.'
      ROLLBACK TRANSACTION
 
      END CATCH

    
  
 



      SELECT * FROM  tblCustomer
      SELECT * FROM tblInvoice
      SELECT * FROM tblItem
      SELECT * FROM tblLineItem
      SELECT * FROM tblSalesPerson 

      SET NOCOUNT OFF


My table tblCustomer,Tblitem,tblSalePerson shows its output but table invoice and lineitem doesn't why?