cBjQzSNG

· 7 years ago · Nov 02, 2018, 10:04 AM
1USE [farjestad]
2GO
3/****** Object:  StoredProcedure [dbo].[csp_createCampaignParticipants]    Script Date: 2018-11-02 10:56:02 ******/
4SET ANSI_NULLS ON
5GO
6SET QUOTED_IDENTIFIER ON
7GO
8-- =============================================
9-- Author:		Jesper SandsjÃ¶
10-- Create date: 2018-08-21
11-- Description:	Create campaign
12-- =============================================
13ALTER PROCEDURE [dbo].[csp_createCampaignParticipants]
14	(
15		@@person nvarchar(MAX),
16		@@campaign INT,
17		@@updateduser INT,
18		@@participantstatus INT = 56101, --Empty
19		@@addAllPersons INT = 0
20		
21	)
22AS
23BEGIN
24
25	
26	-- FLAG_EXTERNALACCESS --
27
28	CREATE TABLE #persons(
29		idperson int)
30	
31	IF @@addAllPersons = 0 THEN  
32
33
34	INSERT INTO #persons (idperson)
35	SELECT person FROM participant WHERE campaign = @@campaign
36
37	BEGIN
38	INSERT INTO participant(person, [status], createdtime, [timestamp], createduser, updateduser, campaign, participantstatus)
39		SELECT DISTINCT t.value, 0, GETDATE(), GETDATE(), @@updateduser, @@updateduser, @@campaign, @@participantstatus 
40		FROM [dbo].[cfn_lc_gettablefromstring](@@person, N';') t
41		WHERE NOT EXISTS (SELECT idperson FROM #persons WHERE #persons.idperson = t.value)
42	END
43	
44	DROP TABLE #persons
45
46END