INSERT INTO [EPD].[SAPEPDDB].[NSI_REQ_HISTORY] (CREATE_DATE,GID,REQUEST_NUMBER,REQUEST_STATUS,DIRECTORY_CODE,MTRCLASS,PRODUCTTYPE,MTRTYPE) 
  SELECT 
	CREATE_DATE,
	RECORD_NUMBER,
	REQUEST_NUMBER,
	REQUEST_STATUS,
	DIRECTORY_CODE,
	FIELD_VALUES as MTRCLASS,
	NULL as PRODUCTTYPE,
	NULL AS MTRTYPE
  FROM [EPD].[SAPEPDDB].[NSI_STEPS_HISTORY]
  WHERE FIELD_NAME LIKE @MTRClass
  AND DIRECTORY_CODE IS NOT NULL
  AND REQUEST_NUMBER = '286615'

USE [EPD]
GO

/****** Object:  Table [SAPEPDDB].[NSI_REQ_HISTORY]    Script Date: 27.02.2019 9:22:54 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [SAPEPDDB].[NSI_REQ_HISTORY](
	[ID] [int] NOT NULL,
	[CREATE_DATE] [datetime] NULL,
	[GID] [nvarchar](20) NULL,
	[REQUEST_NUMBER] [nvarchar](50) NULL,
	[REQUEST_STATUS] [nvarchar](5) NULL,
	[DIRECTORY_CODE] [nvarchar](50) NULL,
	[MTRCLASS] [nvarchar](250) NULL,
	[PRODUCTTYPE] [nvarchar](250) NULL,
	[MTRTYPE] [nvarchar](250) NULL,
PRIMARY KEY CLUSTERED 
(
	[ID] 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

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT ((0)) FOR [ID]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [GID]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [REQUEST_NUMBER]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [REQUEST_STATUS]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [DIRECTORY_CODE]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [MTRCLASS]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [PRODUCTTYPE]
GO

ALTER TABLE [SAPEPDDB].[NSI_REQ_HISTORY] ADD  DEFAULT (N' ') FOR [MTRTYPE]
GO