• There is only one OrderID.
    I don't get an error just data for last row:

    GH_Office_Material_Orders :

    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE [dbo].[GH_Office_Material_Orders](
        [OrderID] [int] IDENTITY(1,1) NOT NULL,
        [ReasonID] [int] NOT NULL,
        [Name] [nvarchar](50) NULL,
        [Partner_Created] [int] NULL,
        [Date_Created] [datetime] NULL,
        [Delivery_LocationID] [int] NULL,
        [Partner_Approved] [int] NULL,
        [Date_Approved] [datetime] NULL,
        [StatusID] [int] NULL,
        [StatusName] AS ([dbo].[Status_Name]([StatusID])),
        [Access] [int] NULL,
        [DocName] [varchar](150) NULL,
    CONSTRAINT [PK_GH_Office_Material_Order] PRIMARY KEY CLUSTERED
    (
        [OrderID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Cost_Center1] FOREIGN KEY([Delivery_LocationID])
    REFERENCES [dbo].[GH_Cost_Center] ([Cost_CenterID])
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Cost_Center1]
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Reason] FOREIGN KEY([ReasonID])
    REFERENCES [dbo].[GH_Office_Material_Order_Reason] ([ReasonID])
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Reason]
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] WITH CHECK ADD CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Status] FOREIGN KEY([StatusID])
    REFERENCES [dbo].[GH_Office_Material_Order_Status] ([StatusID])
    GO

    ALTER TABLE [dbo].[GH_Office_Material_Orders] CHECK CONSTRAINT [FK_GH_Office_Material_Orders_GH_Office_Material_Order_Status]
    GO

    EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ured u koji ce se izvršiti narudžba' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'GH_Office_Material_Orders'
    GO

    GH_Office_Material_Order_Material 

    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    SET ANSI_PADDING ON
    GO

    CREATE TABLE [dbo].[GH_Office_Material_Order_Material](
        [Material_OrderID] [int] IDENTITY(1,1) NOT NULL,
        [OrderID] [int] NOT NULL,
        [MatrialID] [int] NOT NULL,
        [UnitID] [int] NOT NULL,
        [Quantity] [int] NOT NULL,
        [Unit_Price] [float] NOT NULL,
        [Price] [float] NULL,
        [Partner_Created] [int] NULL,
        [Date_Created] [datetime] NULL,
        [MaterialName] AS ([dbo].[Material_Name]([MatrialID])),
        [MaterialGroupID] [int] NULL,
        [StatusID] [int] NULL,
        [QuantityDelivered] [int] NULL,
        [QuantityUndelivered] [int] NULL,
        [SupplierName] [varchar](50) NULL,
        [Description] [varchar](max) NULL,
        [CatalogBr] [nvarchar](50) NULL,
        [MaterialNameOld] [varchar](150) NULL,
        [StatusIDOld] [int] NULL,
        [PartnerName] [varchar](100) NULL,
        [LastUpdated] [datetime] NULL,
    CONSTRAINT [PK_GH_Office_Material_Order_Material] PRIMARY KEY CLUSTERED
    (
        [Material_OrderID] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF
    GO