cf7QAp8k

1SUBSTRING(ContactName,1,FINDSTRING(ContactName,",",1) - 1)
2	
3SUBSTRING(ContactName,FINDSTRING(ContactName,",",1) + 1,FINDSTRING(ContactName,",",2) - FINDSTRING(ContactName,",",1) - 1)
4	
5USE [NorthWindDW]
6GO
7
8/****** Object:  StoredProcedure [dbo].[Insert_New_Suppliers]    Script Date: 09/01/2017 23:14:03 ******/
9SET ANSI_NULLS ON
10GO
11
12SET QUOTED_IDENTIFIER ON
13GO
14
15
16
17
18-- =============================================
19-- Author:      <Author,,Name>
20-- Create date: <Create Date,,>
21-- Description: <Description,,>
22-- =============================================
23CREATE PROCEDURE [dbo].[Insert_New_Suppliers] 
24
25AS
26BEGIN
27    -- SET NOCOUNT ON added to prevent extra result sets from
28    -- interfering with SELECT statements.
29    SET NOCOUNT ON;
30    IF NOT EXISTS 
31    (
32        SELECT * FROM [dbo].DimSupplier
33        WHERE SupplierKey = -1
34    )
35
36    BEGIN
37    SET IDENTITY_INSERT [dbo].[DimSupplier] ON 
38    INSERT [dbo].[DimSupplier] (SupplierKey, SupplierId, SupplierFirstName, SupplierLastName, Position, SupplierCountry, PostCode, Telephone) VALUES
39    (-1,-1,'Unknown','Unknown','Unknown', 'Unknown', 'Unknown','Unknowm');
40    SET IDENTITY_INSERT [dbo].[DimSupplier] OFF
41    END
42END
43
44
45GO
46	
47Create Table [dbo].[DimSupplier]
48(SupplierKey         INT IDENTITY NOT NULL,
49 SupplierId          INT NOT NULL,
50 SupplierFirstName   NVARCHAR(50) NOT NULL,
51 SupplierLastName    NVARCHAR(50) NOT NULL,
52 Position            NVARCHAR(50) NOT NULL,
53 SupplierCountry     NVARCHAR(50) NOT NULL,
54 PostCode            NVARCHAR(25) NOT NULL,
55 Telephone           NVARCHAR(25) NOT NULL);
56Go