vur7diqf

1USE [NorthWindDW]
2GO
3
4
5SET ANSI_NULLS ON
6GO
7
8SET QUOTED_IDENTIFIER ON
9GO
10
11CREATE PROCEDURE [dbo].[Insert_New_Employee] 
12
13AS
14BEGIN
15
16    SET NOCOUNT ON;
17    IF NOT EXISTS 
18    (
19        SELECT * FROM [dbo].DimEmployee
20        WHERE EmpKey = -1
21    )
22
23    BEGIN
24    SET IDENTITY_INSERT [dbo].[DimEmployee] ON 
25    INSERT [dbo].[DimEmployee] (EmpKey, EmpId,Title, EmpFirstName, EmpLastName, HireDate,Country, StoreCode, Telephone,JobTitle) VALUES
26    (-1,-1,'UNKNOWN','UNKNOWN','UNKNOWN','1900-01-01', 'UNKNOWN','UNKNOWN', 'UNKNOWN','UNKNOWN');
27    SET IDENTITY_INSERT [dbo].[DimEmployee] OFF
28    END
29END
30
31GO
32	
33Create Table [dbo].[DimEmployee]
34(EmpKey        INT IDENTITY NOT NULL,
35EmpId          INT NOT NULL,
36EmpFirstName   NVARCHAR(50) NOT NULL,
37EmpLastName    NVARCHAR(50) NOT NULL,
38Title          NVARCHAR(8) NOT NULL,
39HireDate       DATE        NOT NULL,
40Country        NVARCHAR(50) NOT NULL,
41StoreCity      NVARCHAR(50) NOT NULL,
42Telephone      NVARCHAR(25) NOT NULL,
43JobTitle       NVARCHAR(50) NOT NULL);
44Go