YQ0JDsbC

1USE [ILS]
2GO
3/****** Object:  StoredProcedure [dbo].[KC_VOICE_SEED_RESOURCES]    Script Date: 6/9/2018 7:43:18 PM ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8
9
10
11
12   
13ALTER procedure [dbo].[KC_VOICE_SEED_RESOURCES]
14--exec KC_VOICE_UNASSIGN_WU 'tfedorov', 'AO_13042#000010'
15as
16
17begin	
18DROP TABLE  IF EXISTS #TempTest
19end
20go
21
22
23begin
24DROP TABLE  IF EXISTS #TempTest
25    CREATE TABLE #TempTest (RESOURCE_KEY text, TEXT text, RESOURCE_LANGUAGE text, RESOURCE_GROUP text)
26	end
27go
28
29begin
30	bulk insert #TempTest
31from 'c:\import\file.csv'
32with
33  (
34  Fieldterminator = ';'
35  )
36  end
37  go
38
39
40  begin
41MERGE [ILS].[dbo].[RESOURCE_FILE_CUSTOM] AS target
42USING #TempTest AS source ON (target.resource_key COLLATE SQL_Latin1_General_CP1_CS_AS = CONVERT(NVARCHAR(50), source.resource_key) COLLATE SQL_Latin1_General_CP1_CS_AS )
43WHEN MATCHED THEN 
44    UPDATE SET  RESOURCE_LANGUAGE =  source.RESOURCE_KEY,
45	   RESOURCE_GROUP = source.RESOURCE_GROUP,
46	   TEXT = source.TEXT,
47	   RESOURCE_KEY = source.RESOURCE_KEY
48	  
49
50WHEN NOT MATCHED  BY TARGET THEN   
51INSERT (RESOURCE_LANGUAGE, RESOURCE_GROUP, TEXT, RESOURCE_KEY, date_time_stamp)
52    VALUES (CONVERT(NVARCHAR(2000), source.RESOURCE_LANGUAGE), CONVERT(NVARCHAR(2000), source.RESOURCE_GROUP), CONVERT(NVARCHAR(2000), source.TEXT), CONVERT(NVARCHAR(2000), source.RESOURCE_KEY) ,  getdate());
53
54
55	end
56	go
57
58	begin	
59DROP TABLE  IF EXISTS #TempTest
60end
61go