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 |
Partager