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
| create procedure test (
@NomCampagne varchar(255))
AS
BEGIN
declare @record_id int
declare @contact_info varchar (128)
declare @contact_info_type int
declare @record_type int
declare @record_status int
declare @call_result int
declare @attempt int
declare @dial_sched_time int
declare @call_time int
declare @daily_from int
declare @daily_till int
declare @tz_dbid int
declare @campaign_id int
declare @agent_id varchar (32)
declare @chain_id int
declare @chain_n int
declare @group_id int
declare @app_id int
declare @treatments varchar (255)
declare @media_ref int
declare @email_subject varchar (255)
declare @email_template_id int
declare @switch_id int
declare @crm_agent_name varchar (255)
declare @crm_campaign_id varchar (20)
declare @crm_camp_con_id varchar (20)
declare @crm_contact_id varchar (20)
declare @crm_contact_name varchar (255)
declare @crm_client_id varchar (40)
declare @crm_client_name varchar (255)
declare @crm_cancel varchar (255)
declare @crm_dotc_name varchar (255)
declare @crm_naf_name varchar (255)
declare @crm_commune varchar (255)
declare @crm_secteur varchar (255)
declare @crm_affranchissement varchar (255)
declare @crm_ca int
declare @crm_nbr_opp int
declare @SQLString varchar(255)
declare @ParmDefinition varchar(255)
declare Temp_curseur cursor for
select record_id, contact_info, contact_info_type, record_type, record_status, call_result, attempt,dial_sched_time, call_time, daily_from, daily_till, tz_dbid, campaign_id, agent_id,chain_id, chain_n,group_id, app_id,treatments, media_ref, email_subject, email_template_id, switch_id, crm_agent_name, crm_campaign_id, crm_camp_con_id, crm_contact_id, crm_contact_name, crm_client_id, crm_client_name, crm_cancel, crm_dotc_name, crm_naf_name, crm_commune, crm_secteur, crm_affranchissement, crm_ca, crm_nbr_opp
from Table_temp
open Temp_curseur
fetch from Temp_curseur into @record_id, @contact_info, @contact_info_type, @record_type, @record_status, @call_result, @attempt, @dial_sched_time, @call_time, @daily_from, @daily_till, @tz_dbid, @campaign_id, @agent_id, @chain_id, @chain_n, @group_id, @app_id, @treatments, @media_ref, @email_subject, @email_template_id, @switch_id, @crm_agent_name, @crm_campaign_id, @crm_camp_con_id, @crm_contact_id, @crm_contact_name, @crm_client_id, @crm_client_name, @crm_cancel, @crm_dotc_name, @crm_naf_name, @crm_commune, @crm_secteur, @crm_affranchissement, @crm_ca, @crm_nbr_opp
while (@@fetch_status = 0)
begin
set @ParmDefinition = N'@record_id int, @contact_info varchar(128), @contact_info_type int, @record_type int, @record_status int, @call_result int, @attempt int, @dial_sched_time int, @call_time int, @daily_from int, @daily_till int, @tz_dbid int, @campaign_id int, @agent_id varchar(32), @chain_id int, @chain_n int, @group_id int, @app_id int, @treatments varchar(255), @media_ref int, @email_subject varchar(255), @email_template_id int, @switch_id int, @crm_agent_name varchar(255), @crm_campaign_id varchar(20), @crm_camp_con_id varchar(20), @crm_contact_id varchar(20), @crm_contact_name varchar(255), @crm_client_id varchar(20), @crm_client_name varchar(255), @crm_cancel varchar(40), @crm_dotc_name varchar(255), @crm_naf_name varchar(255), @crm_commune varchar(255), @crm_secteur varchar(255), @crm_affranchissement varchar(255), @crm_ca int, @crm_nbr_opp int'
execute sp_executesql @SQLString, @ParmDefinition, @NomCampagne
fetch next from Temp_curseur into @record_id, @contact_info, @contact_info_type, @record_type, @record_status, @call_result, @attempt, @dial_sched_time, @call_time, @daily_from, @daily_till, @tz_dbid, @campaign_id, @agent_id, @chain_id, @chain_n, @group_id, @app_id, @treatments, @media_ref, @email_subject, @email_template_id, @switch_id, @crm_agent_name, @crm_campaign_id, @crm_camp_con_id, @crm_contact_id, @crm_contact_name, @crm_client_id, @crm_client_name, @crm_cancel, @crm_dotc_name, @crm_naf_name, @crm_commune, @crm_secteur, @crm_affranchissement, @crm_ca, @crm_nbr_opp
end
close Temp_curseur
deallocate Temp_curseur
END
GO |
Partager