1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
CREATE PROCEDURE [dbo].[SP_MigrCompteUtilisateur]
-- Add the parameters for the stored procedure here
@Company as nvarchar(100)
AS
BEGIN
-- USERS
insert into USERS([Id_Company],[Id_Users],[profil]
,[Login],[Password],[Company],[AccessKey],[urlConsole]
,[Del_Records_If_Error],[Img],[ClassName]
,[DESIGNATION_WAV_1],[PATH_NAME_WAV_1],[TEXT_WAV_1]
,[DESIGNATION_WAV_2],[TEXT_WAV_2],[PATH_NAME_WAV_2]
,[DESIGNATION_WAV_3],[TEXT_WAV_3],[PATH_NAME_WAV_3]
,[DESIGNATION_WAV_4],[TEXT_WAV_4],[PATH_NAME_WAV_4]
,[DESIGNATION_WAV_5],[TEXT_WAV_5],[PATH_NAME_WAV_5]
,[DESIGNATION_WAV_6],[TEXT_WAV_6],[PATH_NAME_WAV_6]
,[DESIGNATION_WAV_7],[TEXT_WAV_7],[PATH_NAME_WAV_7]
,[DESIGNATION_WAV_8],[TEXT_WAV_8],[PATH_NAME_WAV_8]
,[DESIGNATION_WAV_9],[TEXT_WAV_9],[PATH_NAME_WAV_9]
,[DESIGNATION_WAV_10],[TEXT_WAV_10],[PATH_NAME_WAV_10]
,[TEL_REDIRIGE_1],[TEL_REDIRIGE_2],[TEL_REDIRIGE_3]
,[TEL_REDIRIGE_4],[TEL_REDIRIGE_5],[TEL_REDIRIGE_6]
,[DESIGNATION_WAV_11],[TEXT_WAV_11],[PATH_NAME_WAV_11]
,[DESIGNATION_WAV_12],[TEXT_WAV_12],[PATH_NAME_WAV_12]
,[DESIGNATION_DEPOSE_1],[PATH_NAME_DEPOSE_1],[DESIGNATION_DEPOSE_2]
,[PATH_NAME_DEPOSE_2],[serveur],[PAGESIZE]
,[DISPLAY_CAMP],[DISPLAY_FILE],[TEL_REDIRIGE_7]
,[TEL_REDIRIGE_8],[TEL_REDIRIGE_9])
SELECT [Id_Company],[Id_Users],[profil]
,[Login],[Password],[Company],[AccessKey],[urlConsole]
,[Del_Records_If_Error],[Img],[ClassName]
,[DESIGNATION_WAV_1],[PATH_NAME_WAV_1],[TEXT_WAV_1]
,[DESIGNATION_WAV_2],[TEXT_WAV_2],[PATH_NAME_WAV_2]
,[DESIGNATION_WAV_3],[TEXT_WAV_3],[PATH_NAME_WAV_3]
,[DESIGNATION_WAV_4],[TEXT_WAV_4],[PATH_NAME_WAV_4]
,[DESIGNATION_WAV_5],[TEXT_WAV_5],[PATH_NAME_WAV_5]
,[DESIGNATION_WAV_6],[TEXT_WAV_6],[PATH_NAME_WAV_6]
,[DESIGNATION_WAV_7],[TEXT_WAV_7],[PATH_NAME_WAV_7]
,[DESIGNATION_WAV_8],[TEXT_WAV_8],[PATH_NAME_WAV_8]
,[DESIGNATION_WAV_9],[TEXT_WAV_9],[PATH_NAME_WAV_9]
,[DESIGNATION_WAV_10],[TEXT_WAV_10],[PATH_NAME_WAV_10]
,[TEL_REDIRIGE_1],[TEL_REDIRIGE_2],[TEL_REDIRIGE_3]
,[TEL_REDIRIGE_4],[TEL_REDIRIGE_5],[TEL_REDIRIGE_6]
,[DESIGNATION_WAV_11],[TEXT_WAV_11],[PATH_NAME_WAV_11]
,[DESIGNATION_WAV_12],[TEXT_WAV_12],[PATH_NAME_WAV_12]
,[DESIGNATION_DEPOSE_1],[PATH_NAME_DEPOSE_1],[DESIGNATION_DEPOSE_2]
,[PATH_NAME_DEPOSE_2],[serveur],[PAGESIZE]
,[DISPLAY_CAMP],[DISPLAY_FILE],[TEL_REDIRIGE_7]
,[TEL_REDIRIGE_8],[TEL_REDIRIGE_9]
FROM [SERVER-LIE].[NomBase].[dbo].[USERS]
WHERE Company like @Company
-- GROUP_STATUTS
insert into GROUP_STATUTS([GROUPENAME],[STATUT],[CLIENT]
,[id_group],[LIB],[id_sgroup])
SELECT [GROUPENAME],[STATUT],[CLIENT]
,[id_group],[LIB],[id_sgroup]
FROM [SERVER-LIE].[NomBase].[dbo].[GROUP_STATUTS]
WHERE RTRIM(LTRIM(CLIENT)) like @Company
-- Files_Wavs_Associations
insert into Files_Wavs_Associations
SELECT *
FROM [SERVER-LIE].[NomBase].[dbo].Files_Wavs_Associations
where id_compagny in (select id_company FROM USERS WHERE Company like @Company)
-- Files_sms_Associations
insert into Files_sms_Associations
SELECT *
FROM [SERVER-LIE].[NomBase].[dbo].Files_sms_Associations
where id_compagny in (select id_company FROM USERS WHERE Company like @Company)
END |
