November 13, 2010 at 1:12 am
In Source Contain Two Column name Menuname, NextMenuName.In Stored-procedure contain Three Temporary tables(#IntoMEnuCount,#outTomenuCount,#menupairCount) in that Temp table one of the column name as intocount , that intocount Column name contains count(*) of the column name(NextMenuname),like wise #outtomenucount of the temp table count * is there.The #MenuPair temp table Contain some columns in the Soucre table. up-to this coming correctly.at last of SP we Select the data from MenuPair temp tables,and left outer join the intomenucount,outtomenucount temp tables.
insertsmilie('') in the SP we group By the Columns finally.Column names: PEriod ,Phone number etc... here values are differntly incremented when compare to source tables.. How to Solve this problem..any Queries is there. Temptables values and final select statement of stored procedures values are vsrying.. How i Compare this,,,????????????????????????????// HELP ME....
November 13, 2010 at 2:28 am
You describe your current solution instead of the problem you're trying to resolve. Maybe the total approach of using three temp tables can be replaced alltogether.
What I'd like to see is: what's the data structure you have to begin with and what is the final result you're looking for.
The best format to provide this information is by following the first link in my signature nad post the data as described in a ready to use format. If the business logic is not self-explaining, describe the steps how the final result is calculated.
November 16, 2010 at 1:44 am
SOURCE DATA:
COLUMN NAMES:ID ,STREAMID ,OFFEREDTIME ,TERMINATEDTIME ,Menuname,Prevmenuname,NextMenuName,ivrdisconnected,CallerANI,CallerDNI
200 , 160#A31 ,2010-06-01 01:29:59.000,2010-06-01 01:29:59.000,Account,Agent,Agent Transfer,13,9865,9678
221,160#B31,2010-06-01 02:29:59.000,2010-06-01 01:29:59.000,MenuName,Repeat Offer,Account,15,998,997
222,160#c#1,2010-06-01 03:29:59.000,2010-06-01 02:29:59.000,Previousmenu,Account,Agenttransfer,16,997,09
STORED PROCEDURE:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[SSIS_IVRAnalysis_IVR_InsertMenusByTimesMobileNumberMenu2]
(
--DECLARE
@LastID int,
@MaxID int
)
AS
--set @LastID=0
--set @MaxID =20000
BEGIN
SET FMTONLY OFF
SET NOCOUNT ON
DECLARE @ProcessedRows INT --number of rows processed
DECLARE @Offered INT --total call offered
DECLARE @PrimaryMenu varchar(100) -- The first Menu Name in the IVR
-- How many calls came into TO menu
CREATE TABLE #InToMenuCount(
Period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
inToCountINT
)
-- How many calls came out of TO menu
CREATE TABLE #OutToMenuCount(
Period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
OutToCountINT
)
-- Count of calls for each available Menu Pair in IVR
CREATE TABLE #MenuPairCount(
period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
NextMenuName Varchar(200),
PairCountINT
)
SELECT top 1 @PrimaryMenu = MenuNameLevel0 FROM IVRMenu GROUP BY MenuNameLevel0 -- Fetch the first Menu Name in the IVR
select @Offered = count(distinct (Stream_ID) )
from IVRMenu_SPlit
where ID > @LastID and ID <= @MaxID
insert into #InToMenuCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName, count(*) from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
and i.PrevMenuName <> ''
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END),
i.MenuName,i.CallerANI,i.CallerDNIS
insert into #OutToMenuCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName, count(*) from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
and i.NextMenuName <> ''
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END),
i.MenuName,i.CallerANI,i.CallerDNIS
INSERT into #MenuPairCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName, i.NextMenuName, count(*)
from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END),
i.MenuName, i.NextMenuName,i.CallerANI,i.CallerDNIS
Create NonClustered Index IX_InToMenuCount_Index1 On #InToMenuCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC)
Create NonClustered Index IX_OutToMenuCount_Index1 On #OutToMenuCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC)
Create NonClustered Index IX_MenuPairCount_Index1 On #MenuPairCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC, NextMenuName ASC)
select @ProcessedRows = count(*) from IVRMenu_SPlit
where ID > @LastID and ID <= @MaxID
select A.Period, A.CallerANI,A.CallerDNIS,A.MenuName, A.NextMenuName,
(CASE WHEN A.NextMenuName = @PrimaryMenu THEN (ISNULL(B.inToCount,0)+@Offered) ELSE ISNULL(B.inToCount,0) END) as inToCount,
ISNULL(C.OutToCount,0) as OutToCount,
(CASE WHEN A.MenuName = @PrimaryMenu THEN (ISNULL(D.inToCount,0)+@Offered) ELSE ISNULL(D.inToCount,0) END) as inFromCount,
ISNULL(E.OutToCount,0) as OutFromCount,
ISNULL(A.PairCount,0) as PairCount,
@ProcessedRows as processedrows
from #MenuPairCount A
left outer join #InToMenuCount B on A.NextMenuName = B.MenuName and A.Period = B.Period and A.CallerANI = B.CallerANI and A.CallerDNIS = B.CallerDNIS
left outer join #OutToMenuCount C on A.NextMenuName = C.MenuName and A.Period = C.Period and A.CallerANI = C.CallerANI and A.CallerDNIS = C.CallerDNIS
left outer join #InToMenuCount D on A.MenuName = D.MenuName and A.Period = D.Period and A.CallerANI = D.CallerANI and A.CallerDNIS = D.CallerDNIS
left outer join #OutToMenuCount E on A.MenuName = E.MenuName and A.Period = E.Period and A.CallerANI = E.CallerANI and A.CallerDNIS = E.CallerDNIS
where A.NextMenuName <> ''
order by A.Period,A.MenuName,A.NextMenuName
END
OUTPUT DATAMODEL:
Period ,CALLERANI,CallerDNIS,MenuNAm,Agentname,IntoCount,OutTocount,InfromCount,OutFromCount,PairCount
>>>..
Here the Intocount ,OutTocount ,OutFromCount,InfromCount columns count values increasing , because of groupby. Source offerdtime and terminated time is every minutes. But StoredProcedure We Group by the period for Every Half Hour. In that group Count is increasing.. We cant avoid group by..Because we need every half hour count ,, Help ME
November 16, 2010 at 1:51 am
Check this SP Also:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
--
--ALTER PROCEDURE [dbo].[SSIS_IVRAnalysis_IVR_InsertMenusByTimesMobileNumberMenu]
--(
DECLARE
@LastID int,
@MaxID int
--)
--AS
set @LastID=0
----set @MaxID =20000
select @MaxID= Max(ID) from ivrmenu_split where year(terminatedtime)=2010 and month(terminatedtime)=6 and
day(terminatedtime)=1
BEGIN
SET FMTONLY OFF
SET NOCOUNT ON
DECLARE @ProcessedRows INT --number of rows processed
DECLARE @Offered INT --total call offered
DECLARE @PrimaryMenu varchar(100) -- The first Menu Name in the IVR
-- How many calls came into TO menu
CREATE TABLE #InToMenuCount
(
Period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
nextMenuName varchar(200),
inToCountINT
)
-- How many calls came out of TO menu
CREATE TABLE #OutToMenuCount
(
Period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
NextMenuName Varchar(200),
OutToCountINT
)
CREATE TABLE #OFFERED
(
Period Datetime,
CallerANI VARCHAR(100),
CallerDNIS VARCHAR(200),
offered int
)
-- Count of calls for each available Menu Pair in IVR
CREATE TABLE #MenuPairCount
(
period Datetime,
CallerANI Varchar(100),
CallerDNIS varchar(100),
MenuNameVARCHAR(200),
NextMenuName Varchar(200),
PairCountINT
)
SELECT top 1 @PrimaryMenu = MenuNameLevel0 FROM IVRMenu GROUP BY MenuNameLevel0 -- Fetch the first Menu Name in the IVR
select @Offered = count(distinct (Stream_ID) )
from IVRMenu_SPlit
where ID > @LastID and ID <= @MaxID
insert into #InToMenuCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName,i.NextMenuname ,count(*) from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
and i.PrevMenuName <> ''
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END),
i.MenuName,i.nextMenuName,i.CallerANI,i.CallerDNIS
insert into #OutToMenuCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName,I.nextmenuname ,count(*) from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
and i.NextMenuName <> ''
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),i.TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,i.TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,i.TerminatedTime))+':59:59.000' END),
i.MenuName,i.NextmenuName,i.CallerANI,i.CallerDNIS
INSERT INTO #OFFERED
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END) as Period,
i.CAllerANI,i.CallerDNIS,count(distinct(STREAM_ID))
from IVRMenu_Split i
where i.ID > @LastID and i.ID<=@MaxID
Group By
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END),
i.CallerANI,i.CallerDNIS
INSERT into #MenuPairCount
select
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END) as Period,
i.CallerANI,i.CallerDNIS,i.MenuName, i.NextMenuName, count(*)
from IVRMenu_SPlit i
where i.ID > @LastID and i.ID <= @MaxID
group by
CONVERT(DATETIME,CONVERT(VARCHAR(10),TerminatedTime,101)+' '+CASE WHEN DATEPART(mi,TerminatedTime) between 0 AND 29 THEN CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':29:59.000' ELSE CONVERT(VARCHAR(2),DATEPART(hh,TerminatedTime))+':59:59.000' END),
i.MenuName, i.NextMenuName,i.CallerANI,i.CallerDNIS
Create NonClustered Index IX_InToMenuCount_Index1 On #InToMenuCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC)
Create NonClustered Index IX_OutToMenuCount_Index1 On #OutToMenuCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC)
Create NonClustered Index IX_MenuPairCount_Index1 On #MenuPairCount
(Period ASC, CallerANI ASC, CallerDNIS ASC,MenuName ASC, NextMenuName ASC)
Create NonClustered Index IX_Offered_Index1 On #OFFERED
(Period ASC, CallerANI ASC, CallerDNIS ASC)
select @ProcessedRows = count(*) from IVRMenu_SPlit
where ID > @LastID and ID <= @MaxID
select * from (
select A.Period, A.CallerANI,A.CallerDNIS,A.MenuName ,A.NextMenuName,
(CASE WHEN A.NextMenuName = @PrimaryMenu THEN (ISNULL(B.inToCount,0)+F.Offered) ELSE ISNULL(B.inToCount,0) END) as inToCount,
ISNULL(C.OutToCount,0) as OutToCount,
(CASE WHEN A.MenuName = @PrimaryMenu THEN (ISNULL(D.inToCount,0)+F.Offered) ELSE ISNULL(D.inToCount,0) END) as inFromCount,
ISNULL(E.OutToCount,0) as OutFromCount,
ISNULL(A.PairCount,0) as PairCount,
@ProcessedRows as processedrows
from #MenuPairCount A
left outer join #InToMenuCount B on A.MenuName = B.MenuName and A.NextMenuName=B.NextMenuname and A.Period = B.Period and A.CallerANI = B.CallerANI and A.CallerDNIS = B.CallerDNIS
left outer join #OutToMenuCount C on A.MenuName = C.MenuName and A.Period = C.Period and A.CallerANI = C.CallerANI and A.CallerDNIS = C.CallerDNIS
left outer join #InToMenuCount D on A.MenuName = D.MenuName and A.Period = D.Period and A.CallerANI = D.CallerANI and A.CallerDNIS = D.CallerDNIS
left outer join #OutToMenuCount E on A.MenuName = E.MenuName and A.Period = E.Period and A.CallerANI = E.CallerANI and A.CallerDNIS = E.CallerDNIS
left outer join #Offered F on A.period = F.period and A.CallerANI = F.CallerANI and A.CallerDNIS = F.CallerDNIS
where A.MenuName <> ''
--group by A.Period,A.CallerANI,A.CallerDNIS,A.MenuName,A.NextMenuName,B.InToCount,C.OutToCount,F.Offered
-- group by A.Period,A.CallerANI,A.CallerDNIS,A.MenuName,A.NextMenuName,B.InToCount,C.OutToCount,F.Offered
--order by A.period,A.MenuName,A.NextMenuName
)
testtable where MenuName = 'Agent Transfer' and Period='2010-06-01 01:29:59.000'
--and Period='2010-06-01 01:29:59.000'
select * from #InToMenuCount where menuname='Agent Transfer' and Period ='2010-06-01 01:29:59.000'
--and Period ='2010-06-01 01:29:59.000'
--
--select * from (EXECUTE SSIS_IVRAnalysis_IVR_InsertMenusByTimesMobileNumberMenu '06/01/2010','06/01/2010')
--EXCEPT
--Select * from InToMenuCount where menuname='Agent transfer'
DROP TABLE #InToMenuCount
DROP TABLE #OutToMenuCount
DROP TABLE #Offered
DROP TABLE #MenupairCount
--select * from vwA
--EXCEPT
--select * from vwB
END
November 16, 2010 at 2:07 am
brainblower13 (11/16/2010)
SOURCE DATA:COLUMN NAMES:ID ,STREAMID ,OFFEREDTIME ,TERMINATEDTIME ,Menuname,Prevmenuname,NextMenuName,ivrdisconnected,CallerANI,CallerDNI
200 , 160#A31 ,2010-06-01 01:29:59.000,2010-06-01 01:29:59.000,Account,Agent,Agent Transfer,13,9865,9678
221,160#B31,2010-06-01 02:29:59.000,2010-06-01 01:29:59.000,MenuName,Repeat Offer,Account,15,998,997
222,160#c#1,2010-06-01 03:29:59.000,2010-06-01 02:29:59.000,Previousmenu,Account,Agenttransfer,16,997,09
This doesn't work. What Lutz is asking for is a CREATE TABLE statement for the table IVRMenu_Split, and a whole bunch of INSERT statements to populate it with some representative data. Running this script should result in a table identical to your own IVRMenu_Split but with a subset of the rows. He can then run your own code against it and get a better idea of the problem. Without it he will be guessing both the problem and the solution and providing you with untested code. It should take you ten minutes tops and it's time very well spent - your time.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 2:22 am
ID main ID SplitIDstreamIDOffered TimeTerminated TimeCallerANICallerDNISIVR DigitMenuNamePrevIVR DigitPrevMenuNAmeNext IVR DigitNectMenNameIVR DISCONNESTED
1211602D021A083004300:44.01:34:0091417414529141155155Main Menu1Product and promotion1
2221602D021A083004300:44.001:34.0914174145291411551551Product and promotionMain Menu2Other Offer Details1
3231602D021A083004300:44.001:34.0914174145291411551552Other Offer Details1Product and promotion3Offer 31
4251602D021A083004300:44.001:34.0914174145291411551551Wrong Entry3Offer 31
5241602D021A083004300:44.001:34.0914174145291411551553Offer 32Other Offer Details1Wrong Entry1
6411602D021A087004301:31.002:08.091417716549141155155Main Menu2Handset or RUIM lost1
7421602D021A087004301:31.002:08.0914177165491411551552Handset or RUIM lostMain Menu1
8611602D021A08D004302:20.002:36.091413641189141155155Main Menu1
9521602D021A089004301:43.002:59.0914174145291411551550Agent TransferMain Menu0
10511602D021A089004301:43.002:59.091417414529141155155Main Menu0Agent Transfer0
11711602D021A08F004302:59.003:04.091416207629141155155Main Menu1Product and promotion2
12721602D021A08F004302:59.003:04.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
13731602D021A08F004302:59.003:04.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
14741602D021A08F004302:59.003:04.0914162076291411551550Agent Transfer2Other Offer Details2
15131602D021A081004300:37.003:08.0914180782891411551550Agent Transfer1Product and promotion0
16111602D021A081004300:37.003:08.091418078289141155155Main Menu1Product and promotion0
17121602D021A081004300:37.003:08.0914180782891411551551Product and promotionMain Menu0Agent Transfer0
18811602D021A091004303:03.003:14.091416124969141155155Main Menu1
19911602D021A093004303:13.003:22.091416207629141155155Main Menu1Product and promotion2
20921602D021A093004303:13.003:22.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
21931602D021A093004303:13.003:22.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
22941602D021A093004303:13.003:22.0914162076291411551550Agent Transfer2Other Offer Details2
231011602D021A096004303:36.003:42.098666360579133155155Main Menu1
241221602D021A09A004303:49.003:59.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
251231602D021A09A004303:49.003:59.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
261241602D021A09A004303:49.003:59.0914162076291411551550Agent Transfer2Other Offer Details2
271211602D021A09A004303:49.003:59.091416207629141155155Main Menu1Product and promotion2
281411602D021A09E004304:17.004:27.091413066059141155155Main Menu1
291511602D021A0A0004304:19.005:02.091416207629141155155Main Menu1Product and promotion2
301521602D021A0A0004304:19.005:02.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
311531602D021A0A0004304:19.005:02.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
321541602D021A0A0004304:19.005:02.0914162076291411551550Agent Transfer2Other Offer Details2
331611602D021A0A3004305:11.005:20.091416124969141155155Main Menu1
341911602D021A0A9004305:55.005:56.091413029279141155155Main Menu1
351811602D021A0A7004305:53.006:11.091413698069141155155Main Menu1Product and promotion1
361821602D021A0A7004305:53.006:11.0914136980691411551551Product and promotionMain Menu1
371121602D021A098004303:49.007:29.0914180581591411551552Handset or RUIM lostMain Menu0
381111602D021A098004303:49.007:29.091418058159141155155Main Menu2Handset or RUIM lost0
392011602D021A0AB004307:31.007:41.091416564309141155155Main Menu1
401331602D021A09C004304:03.008:16.0914166882391411551550Agent Transfer3Account0
411311602D021A09C004304:03.008:16.091416688239141155155Main Menu3Account0
421321602D021A09C004304:03.008:16.0914166882391411551553AccountMain Menu0Agent Transfer0
431741602D021A0A5004305:23.010:53.0914135783891411551552Wrong Entry9Repeat Menu0
441711602D021A0A5004305:23.010:53.091413578389141155155Main Menu3Account0
451721602D021A0A5004305:23.010:53.0914135783891411551553AccountMain Menu9Repeat Menu0
461731602D021A0A5004305:23.010:53.0914135783891411551559Repeat Menu3Account2Wrong Entry0
472211602D021A0B5004310:41.011:01.091418114079141155155Main Menu1
482311602D021A0C0004313:02.013:20.091415642209141155155Main Menu1
49311602D021A085004301:04.013:59.096032561539133155155Main Menu1Product and promotion0
50371602D021A085004301:04.013:59.0960325615391331551553Wrong Entry3Wrong Entry7Previous Menu0
513111602D021A085004301:04.013:59.0960325615391331551553Wrong Entry4Wrong Entry7Previous Menu0
523121602D021A085004301:04.013:59.0960325615391331551557Previous Menu3Wrong Entry2Wrong Entry0
533141602D021A085004301:04.013:59.0960325615391331551551Wrong Entry2Wrong Entry0Agent Transfer0
54321602D021A085004301:04.013:59.0960325615391331551551Product and promotionMain Menu1Repeat Offer Detail0
55351602D021A085004301:04.013:59.0960325615391331551551Wrong Entry9Repeat Menu3Wrong Entry0
56381602D021A085004301:04.013:59.0960325615391331551557Previous Menu3Wrong Entry3Wrong Entry0
57391602D021A085004301:04.013:59.0960325615391331551553Wrong Entry7Previous Menu4Wrong Entry0
583131602D021A085004301:04.013:59.0960325615391331551552Wrong Entry7Previous Menu1Wrong Entry0
593151602D021A085004301:04.013:59.0960325615391331551550Agent Transfer1Wrong Entry0
60331602D021A085004301:04.013:59.0960325615391331551551Repeat Offer Detail1Product and promotion9Repeat Menu0
61341602D021A085004301:04.013:59.0960325615391331551559Repeat Menu1Repeat Offer Detail1Wrong Entry0
62361602D021A085004301:04.013:59.0960325615391331551553Wrong Entry1Wrong Entry3Wrong Entry0
633101602D021A085004301:04.013:59.0960325615391331551554Wrong Entry3Wrong Entry3Wrong Entry0
642411602D021A0C2004314:02.014:32.091413342789141155155Main Menu1
652521602D021A0C9004316:33.016:49.0914146839391411551553AccountMain Menu1
662511602D021A0C9004316:33.016:49.091414683939141155155Main Menu3Account1
672611602D021A0CD004316:51.019:32.091414683939141155155Main Menu0Agent Transfer0
682621602D021A0CD004316:51.019:32.0914146839391411551550Agent TransferMain Menu0
692821602D021A0D2004319:26.020:34.0914155534591411551550Agent TransferMain Menu2
702811602D021A0D2004319:26.020:34.091415553459141155155Main Menu0Agent Transfer2
712121602D021A0B0004308:45.020:47.0914166882391411551553AccountMain Menu0Agent Transfer0
722131602D021A0B0004308:45.020:47.0914166882391411551550Agent Transfer3Account0
732111602D021A0B0004308:45.020:47.091416688239141155155Main Menu3Account0
743121602D021A0D9004321:05.022:09.0914155534591411551550Agent TransferMain Menu2
753111602D021A0D9004321:05.022:09.091415553459141155155Main Menu0Agent Transfer2
763021602D021A0D7004320:51.023:20.0914168777291411551553AccountMain Menu0Agent Transfer2
773031602D021A0D7004320:51.023:20.0914168777291411551550Agent Transfer3Account2
783011602D021A0D7004320:51.023:20.091416877729141155155Main Menu3Account2
793311602D021A0DF004322:32.023:21.091337118289133155155Main Menu3Account1
803321602D021A0DF004322:32.023:21.0913371182891331551553AccountMain Menu1
812921602D021A0D4004320:12.023:24.0914166290091411551550Agent TransferMain Menu0
822911602D021A0D4004320:12.023:24.091416629009141155155Main Menu0Agent Transfer0
832721602D021A0CF004317:44.023:33.0914150579391411551550Agent TransferMain Menu0
842711602D021A0CF004317:44.023:33.091415057939141155155Main Menu0Agent Transfer0
853511602D021A0E3004323:24.023:41.091415553459141155155Main Menu1
863411602D021A0E1004322:33.024:03.091337062169133155155Main Menu3Account0
873431602D021A0E1004322:33.024:03.0913370621691331551552How to Recharge & extend Validity3Account0
883421602D021A0E1004322:33.024:03.0913370621691331551553AccountMain Menu2How to Recharge & extend Validity0
893711602D021A0E9004324:43.024:45.091416081579141155155Main Menu1
903911602D021A0ED004325:05.025:37.091416081579141155155Main Menu1
914011602D021A0EF004325:17.025:40.091416718169141155155Main Menu1
923841602D021A0EB004324:46.025:45.0913370621691331551553Wrong Entry4Wrong Entry2
933811602D021A0EB004324:46.025:45.091337062169133155155Main Menu3Account2
943831602D021A0EB004324:46.025:45.0913370621691331551554Wrong Entry3Account3Wrong Entry2
953821602D021A0EB004324:46.025:45.0913370621691331551553AccountMain Menu4Wrong Entry2
963611602D021A0E7004324:35.027:22.091416629009141155155Main Menu0Agent Transfer0
973621602D021A0E7004324:35.027:22.0914166290091411551550Agent TransferMain Menu0
983211602D021A0DB004321:28.028:25.091414898949141155155Main Menu0Agent Transfer0
993221602D021A0DB004321:28.028:25.0914148989491411551550Agent TransferMain Menu0
1004311602D021A0F7004327:15.028:56.091417385019141155155Main Menu9Repeat Menu1
1014341602D021A0F7004327:15.028:56.0914173850191411551551Language Option4TPIN & Language change7Previous Menu1
1024351602D021A0F7004327:15.028:56.0914173850191411551557Previous Menu1Language Option1Wrong Entry1
1034361602D021A0F7004327:15.028:56.0914173850191411551551Wrong Entry7Previous Menu9Repeat Menu1
1044371602D021A0F7004327:15.028:56.0914173850191411551559Repeat Menu1Wrong Entry1
1054321602D021A0F7004327:15.028:56.0914173850191411551559Repeat MenuMain Menu4TPIN & Language change1
1064331602D021A0F7004327:15.028:56.0914173850191411551554TPIN & Language change9Repeat Menu1Language Option1
1074611602D021A100004329:09.029:17.091416081579141155155Main Menu1
1084421602D021A0FC004329:05.029:21.0915000033691411551552Handset or RUIM lostMain Menu1
1094411602D021A0FC004329:05.029:21.091500003369141155155Main Menu2Handset or RUIM lost1
1104131602D021A0F1004326:04.029:46.0913370621691331551550Agent Transfer3Account0
1114111602D021A0F1004326:04.029:46.091337062169133155155Main Menu3Account0
1124121602D021A0F1004326:04.029:46.0913370621691331551553AccountMain Menu0Agent Transfer0
1134211602D021A0F3004326:18.031:19.091417961739141155155Main Menu0Agent Transfer0
1144221602D021A0F3004326:18.031:19.0914179617391411551550Agent TransferMain Menu0
1154911602D021A108004332:29.032:35.091414247999141155155Main Menu1
1164721602D021A104004331:51.032:58.0914155534591411551550Agent TransferMain Menu2
1174711602D021A104004331:51.032:58.091415553459141155155Main Menu0Agent Transfer2
1185011602D021A10B004333:25.033:33.091414247999141155155Main Menu1
1195111602D021A10D004333:30.033:54.091417961739141155155Main Menu1
1204521602D021A0FE004329:06.036:26.0914173850191411551552Handset or RUIM lostMain Menu1Wrong Entry0
1214511602D021A0FE004329:06.036:26.091417385019141155155Main Menu2Handset or RUIM lost0
1224531602D021A0FE004329:06.036:26.0914173850191411551551Wrong Entry2Handset or RUIM lost0
1235321602D021A111004334:14.036:34.0914179617391411551550Agent TransferMain Menu0
1245311602D021A111004334:14.036:34.091417961739141155155Main Menu0Agent Transfer0
1255511602D021A116004337:45.037:47.091337166099133155155Main Menu1
1265421602D021A114004336:55.038:13.0913370059291331551553AccountMain Menu0Agent Transfer1
1275431602D021A114004336:55.038:13.0913370059291331551550Agent Transfer3Account1
1285411602D021A114004336:55.038:13.091337005929133155155Main Menu3Account1
1295211602D021A10F004334:03.039:54.091414247999141155155Main Menu0Agent Transfer0
1305221602D021A10F004334:03.039:54.0914142479991411551550Agent TransferMain Menu0
November 16, 2010 at 2:28 am
brainblower13 (11/16/2010)
ID main ID SplitIDstreamIDOffered TimeTerminated TimeCallerANICallerDNISIVR DigitMenuNamePrevIVR DigitPrevMenuNAmeNext IVR DigitNectMenNameIVR DISCONNESTED1211602D021A083004300:44.01:34:0091417414529141155155Main Menu1Product and promotion1
Thank you, but there isn't a CREATE TABLE statement.
The data isn't presented as INSERT statements.
We need a script which we can run to create a table and populate it with data.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 2:51 am
Create Table IVRMENU_SPLIT
(
ID int,
main ID varchar(200),
SplitID varchar(200),
streamID varchar(200),
Offered Time datetime,
Terminated Time datetime,
CallerANI varchar(200),
CallerDNISvarchar(200),
IVR Digit int,
MenuName varchar(220),
PrevIVR Digit int,
PrevMenuNAme varchar(200),
Next IVR Digit int,
NextMenName varchar(200),
)IVR DISCONNESTED int
Insert into IVRMenu_split
(ID ,main ID, SplitID,streamID,Offered Time,Terminated Time,CallerANI,CallerDNIS,IVR Digit,MenuName,PrevIVR Digit,PrevMenuNAme,Next IVR Digit,NectMenName,IVR DISCONNESTED ,)
select (1,2,1,1602D021A0830043,00:44.0,1:34:00,9141741452,9141155155,Main Menu,1,Product and promotion,1,)
November 16, 2010 at 3:11 am
This runs with errors:
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near 'varchar'.
Msg 102, Level 15, State 1, Line 22
Incorrect syntax near 'ID'.
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near ','.
There is only one sample row of data.
We need a sample script which generates a suitable number of rows and runs without errors.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 3:45 am
Create Table IVRMENU_SPLIT1
(
ID int,
MainID int,
SplitID varchar(200),
streamID varchar(200),
OfferedTime datetime,
TerminatedTime datetime,
CallerANI varchar(200),
CallerDNIS varchar(200),
IVRDigit int,
MenuName varchar(220),
PrevIVRDigit int,
PrevMenuNAme varchar(200),
NextIVRDigit int,
NextMenuName varchar(200),
IVRDISCONNESTED int
)
Now this query running correctly. Check this and create the table. I already given 10 rows of data. Please. today i have to finish this and submit to team leader.
Insert into IVRMenu_split1(ID,mainID,SplitID,streamID,OfferedTime,TerminatedTime,CallerANI,CallerDNIS,IVRDigit,MenuName,PrevIVRDigit,PrevMenuNAme,NextIVRDigit,NextMenName,IVRDISCONNESTED)
--select 1, 2, '1', '1602D021A0830043', '00:44.0', '1:34:00', '9141741452', '9141155155', 1,'Main Menu' , 1, 'Product and promotion', 1 ,'agent transfer',1 unionall
--select 2,2,2,'1602D021A0830043','00:44.001:34.0','9141741452','9141155155',1,'Product and promotion','Main Menu',2,'Other Offer Details',1 unionall
--select 3,2,3,'1602D021A0830043','00:44.001:34.0','9141741452','9141155155',2,'Other Offer Details',1,'Product and promotion',3,'Offer ',3,1 unionall.
I checked that insert also... Use It.. U need More Data means using insert u did same for all....ok..
12721602D021A08F004302:59.003:04.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
13731602D021A08F004302:59.003:04.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
14741602D021A08F004302:59.003:04.0914162076291411551550Agent Transfer2Other Offer Details2
15131602D021A081004300:37.003:08.0914180782891411551550Agent Transfer1Product and promotion0
16111602D021A081004300:37.003:08.091418078289141155155Main Menu1Product and promotion0
17121602D021A081004300:37.003:08.0914180782891411551551Product and promotionMain Menu0Agent Transfer0
18811602D021A091004303:03.003:14.091416124969141155155Main Menu1
19911602D021A093004303:13.003:22.091416207629141155155Main Menu1Product and promotion2
20921602D021A093004303:13.003:22.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
21931602D021A093004303:13.003:22.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
22941602D021A093004303:13.003:22.0914162076291411551550Agent Transfer2Other Offer Details2
231011602D021A096004303:36.003:42.098666360579133155155Main Menu1
241221602D021A09A004303:49.003:59.0914162076291411551551Product and promotionMain Menu2Other Offer Details2
251231602D021A09A004303:49.003:59.0914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
261241602D021A09A004303:49.003:59.0914162076291411551550Agent Transfer2Other Offer Details2
271211602D021A09A004303:49.003:59.091416207629141155155Main Menu1Product and promotion2
281411602D021A09E004304:17.004:27.091413066059141155155Main Menu1
291511602D021A0A0004304:19.005:02.091416207629141155155Main Menu1Product and promotion2
381111602D021A098004303:49.007:29.091418058159141155155Main Menu2Handset or RUIM lost
392011602D021A0AB004307:31.007:41.091416564309141155155Main Menu
401331602D021A09C004304:03.008:16.0914166882391411551550Agent Transfer3Account
411311602D021A09C004304:03.008:16.091416688239141155155Main Menu3Account
421321602D021A09C004304:03.008:16.0914166882391411551553AccountMain Menu0Agent Transfer
431741602D021A0A5004305:23.010:53.0914135783891411551552Wrong Entry9Repeat Menu
441711602D021A0A5004305:23.010:53.091413578389141155155Main Menu3Account
451721602D021A0A5004305:23.010:53.0914135783891411551553AccountMain Menu9Repeat Menu
461731602D021A0A5004305:23.010:53.0914135783891411551559Repeat Menu3Account2Wrong Entry
472211602D021A0B5004310:41.011:01.091418114079141155155Main Menu
482311602D021A0C0004313:02.013:20.091415642209141155155Main Menu
49311602D021A085004301:04.013:59.096032561539133155155Main Menu1Product and promotion
50371602D021A085004301:04.013:59.0960325615391331551553Wrong Entry3Wrong Entry7Previous Menu
513111602D021A085004301:04.013:59.0960325615391331551553Wrong Entry4Wrong Entry7Previous Menu
523121602D021A085004301:04.013:59.0960325615391331551557Previous Menu3Wrong Entry2Wrong Entry
533141602D021A085004301:04.013:59.0960325615391331551551Wrong Entry2Wrong Entry0Agent Transfer
54321602D021A085004301:04.013:59.0960325615391331551551Product and promotionMain Menu1Repeat Offer Detail
55351602D021A085004301:04.013:59.0960325615391331551551Wrong Entry9Repeat Menu3Wrong Entry
56381602D021A085004301:04.013:59.0960325615391331551557Previous Menu3Wrong Entry3Wrong Entry
57391602D021A085004301:04.013:59.0960325615391331551553Wrong Entry7Previous Menu4Wrong Entry
583131602D021A085004301:04.013:59.0960325615391331551552Wrong Entry7Previous Menu1Wrong Entry
593151602D021A085004301:04.013:59.0960325615391331551550Agent Transfer1Wrong Entry
60331602D021A085004301:04.013:59.0960325615391331551551Repeat Offer Detail1Product and promotion9Repeat Menu
61341602D021A085004301:04.013:59.0960325615391331551559Repeat Menu1Repeat Offer Detail1Wrong Entry
62361602D021A085004301:04.013:59.0960325615391331551553Wrong Entry1Wrong Entry3Wrong Entry
633101602D021A085004301:04.013:59.0960325615391331551554Wrong Entry3Wrong Entry3Wrong Entry
642411602D021A0C2004314:02.014:32.091413342789141155155Main Menu
652521602D021A0C9004316:33.016:49.0914146839391411551553AccountMain Menu
662511602D021A0C9004316:33.016:49.091414683939141155155Main Menu3Account
672611602D021A0CD004316:51.019:32.091414683939141155155Main Menu0Agent Transfer
682621602D021A0CD004316:51.019:32.0914146839391411551550Agent TransferMain Menu
692821602D021A0D2004319:26.020:34.0914155534591411551550Agent TransferMain Menu
702811602D021A0D2004319:26.020:34.091415553459141155155Main Menu0Agent Transfer
712121602D021A0B0004308:45.020:47.0914166882391411551553AccountMain Menu0Agent Transfer
722131602D021A0B0004308:45.020:47.0914166882391411551550Agent Transfer3Account
732111602D021A0B0004308:45.020:47.091416688239141155155Main Menu3Account
743121602D021A0D9004321:05.022:09.0914155534591411551550Agent TransferMain Menu
753111602D021A0D9004321:05.022:09.091415553459141155155Main Menu0Agent Transfer
763021602D021A0D7004320:51.023:20.0914168777291411551553AccountMain Menu0Agent Transfer
773031602D021A0D7004320:51.023:20.0914168777291411551550Agent Transfer3Account
783011602D021A0D7004320:51.023:20.091416877729141155155Main Menu3Account
793311602D021A0DF004322:32.023:21.091337118289133155155Main Menu3Account
803321602D021A0DF004322:32.023:21.0913371182891331551553AccountMain Menu
812921602D021A0D4004320:12.023:24.0914166290091411551550Agent TransferMain Menu
822911602D021A0D4004320:12.023:24.091416629009141155155Main Menu0Agent Transfer
832721602D021A0CF004317:44.023:33.0914150579391411551550Agent TransferMain Menu
842711602D021A0CF004317:44.023:33.091415057939141155155Main Menu0Agent Transfer
853511602D021A0E3004323:24.023:41.091415553459141155155Main Menu
863411602D021A0E1004322:33.024:03.091337062169133155155Main Menu3Account
873431602D021A0E1004322:33.024:03.0913370621691331551552How to Recharge & extend Validity3Account
883421602D021A0E1004322:33.024:03.0913370621691331551553AccountMain Menu2How to Recharge & extend Validity
893711602D021A0E9004324:43.024:45.091416081579141155155Main Menu
903911602D021A0ED004325:05.025:37.091416081579141155155Main Menu
914011602D021A0EF004325:17.025:40.091416718169141155155Main Menu
923841602D021A0EB004324:46.025:45.0913370621691331551553Wrong Entry4Wrong Entry
933811602D021A0EB004324:46.025:45.091337062169133155155Main Menu3Account
943831602D021A0EB004324:46.025:45.0913370621691331551554Wrong Entry3Account3Wrong Entry
953821602D021A0EB004324:46.025:45.0913370621691331551553AccountMain Menu4Wrong Entry
963611602D021A0E7004324:35.027:22.091416629009141155155Main Menu0Agent Transfer
973621602D021A0E7004324:35.027:22.0914166290091411551550Agent TransferMain Menu
983211602D021A0DB004321:28.028:25.091414898949141155155Main Menu0Agent Transfer
993221602D021A0DB004321:28.028:25.0914148989491411551550Agent TransferMain Menu
1004311602D021A0F7004327:15.028:56.091417385019141155155Main Menu9Repeat Menu
1014341602D021A0F7004327:15.028:56.0914173850191411551551Language Option4TPIN & Language change7Previous Menu
1024351602D021A0F7004327:15.028:56.0914173850191411551557Previous Menu1Language Option1Wrong Entry
1034361602D021A0F7004327:15.028:56.0914173850191411551551Wrong Entry7Previous Menu9Repeat Menu
1044371602D021A0F7004327:15.028:56.0914173850191411551559Repeat Menu1Wrong Entry
November 16, 2010 at 3:54 am
The script for creating the table works fine, thank you.
The script for populating the table with three rows of data does not run:
Msg 205, Level 16, State 1, Line 22
All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.
brainblower13 (11/16/2010)
I checked that insert also... Use It.. U need More Data means using insert u did same for all....ok..
Are you asking me to convert the 100 lines of text in your post above into INSERT statements for you?
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 4:20 am
Please be patient, and don't contact me again by personal mail. By posting your scripts here, you are inviting others to assist you, which helps with the diagnosis of your problem and often results in a number of different solutions from which you can choose the best for your environment.
It also helps with the language issues when English is not the first language of the original poster (you).
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 5:22 am
select A.Period, A.CallerANI,A.CallerDNIS,A.MenuName, A.NextMenuName ,
(CASE WHEN A.NextMenuName = @PrimaryMenu THEN (ISNULL(B.inToCount,0)+F.Offered) ELSE ISNULL(B.inToCount,0) END) as inToCount,
ISNULL(C.OutToCount,0) as OutToCount,
(CASE WHEN A.MenuName = @PrimaryMenu THEN (ISNULL(D.inToCount,0)+F.Offered) ELSE ISNULL(D.inToCount,0) END) as inFromCount,
ISNULL(E.OutToCount,0) as OutFromCount,
ISNULL(A.PairCount,0) as PairCount,
@ProcessedRows as processedrows
from #MenuPairCount A
left join #InToMenuCount B on A.NextMenuName = B.MenuName and A.Period = B.Period and A.CallerANI = B.CallerANI and A.CallerDNIS = B.CallerDNIS
left outer join #OutToMenuCount C on A.NextMenuName = C.MenuName and A.Period = C.Period and A.CallerANI = C.CallerANI and A.CallerDNIS = C.CallerDNIS
left outer join #InToMenuCount D on A.MenuName = D.MenuName and A.Period = D.Period and A.CallerANI = D.CallerANI and A.CallerDNIS = D.CallerDNIS
left outer join #OutToMenuCount E on A.MenuName = E.MenuName and A.Period = E.Period and A.CallerANI = E.CallerANI and A.CallerDNIS = E.CallerDNIS
left outer join #Offered F on A.period = F.period and A.CallerANI = F.CallerANI and A.CallerDNIS = F.CallerDNIS
where A.MenuName <> ''..........
In that whole StoredProcedure , final Select Query Of SP output giving difference...
November 16, 2010 at 6:16 am
brainblower13 (11/16/2010)
...In that whole StoredProcedure , final Select Query Of SP output giving difference...
It's lunchtime here in the UK, I've got a whole hour to spend on this if you wish. The requirement for sample data is still outstanding.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
November 16, 2010 at 6:46 am
1211602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.00091417414529141155155Main Menu1Product and promotion1
2221602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551551Product and promotionMain Menu2Other Offer Details1
3231602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551552Other Offer Details1Product and promotion3Offer 31
4251602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551551Wrong Entry3Offer 31
5241602D021A08300432010-06-01 00:00:44.0002010-06-01 00:01:34.000914174145291411551553Offer 32Other Offer Details1Wrong Entry1
6411602D021A08700432010-06-01 00:01:31.0002010-06-01 00:02:08.00091417716549141155155Main Menu2Handset or RUIM lost1
7421602D021A08700432010-06-01 00:01:31.0002010-06-01 00:02:08.000914177165491411551552Handset or RUIM lostMain Menu1
8611602D021A08D00432010-06-01 00:02:20.0002010-06-01 00:02:36.00091413641189141155155Main Menu1
9521602D021A08900432010-06-01 00:01:43.0002010-06-01 00:02:59.000914174145291411551550Agent TransferMain Menu0
10511602D021A08900432010-06-01 00:01:43.0002010-06-01 00:02:59.00091417414529141155155Main Menu0Agent Transfer0
11711602D021A08F00432010-06-01 00:02:59.0002010-06-01 00:03:04.00091416207629141155155Main Menu1Product and promotion2
12721602D021A08F00432010-06-01 00:02:59.0002010-06-01 00:03:04.000914162076291411551551Product and promotionMain Menu2Other Offer Details2
13731602D021A08F00432010-06-01 00:02:59.0002010-06-01 00:03:04.000914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
14741602D021A08F00432010-06-01 00:02:59.0002010-06-01 00:03:04.000914162076291411551550Agent Transfer2Other Offer Details2
15131602D021A08100432010-06-01 00:00:37.0002010-06-01 00:03:08.000914180782891411551550Agent Transfer1Product and promotion0
16111602D021A08100432010-06-01 00:00:37.0002010-06-01 00:03:08.00091418078289141155155Main Menu1Product and promotion0
17121602D021A08100432010-06-01 00:00:37.0002010-06-01 00:03:08.000914180782891411551551Product and promotionMain Menu0Agent Transfer0
18811602D021A09100432010-06-01 00:03:03.0002010-06-01 00:03:14.00091416124969141155155Main Menu1
19911602D021A09300432010-06-01 00:03:13.0002010-06-01 00:03:22.00091416207629141155155Main Menu1Product and promotion2
20921602D021A09300432010-06-01 00:03:13.0002010-06-01 00:03:22.000914162076291411551551Product and promotionMain Menu2Other Offer Details2
21931602D021A09300432010-06-01 00:03:13.0002010-06-01 00:03:22.000914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
22941602D021A09300432010-06-01 00:03:13.0002010-06-01 00:03:22.000914162076291411551550Agent Transfer2Other Offer Details2
231011602D021A09600432010-06-01 00:03:36.0002010-06-01 00:03:42.00098666360579133155155Main Menu1
241221602D021A09A00432010-06-01 00:03:49.0002010-06-01 00:03:59.000914162076291411551551Product and promotionMain Menu2Other Offer Details2
251231602D021A09A00432010-06-01 00:03:49.0002010-06-01 00:03:59.000914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
261241602D021A09A00432010-06-01 00:03:49.0002010-06-01 00:03:59.000914162076291411551550Agent Transfer2Other Offer Details2
271211602D021A09A00432010-06-01 00:03:49.0002010-06-01 00:03:59.00091416207629141155155Main Menu1Product and promotion2
281411602D021A09E00432010-06-01 00:04:17.0002010-06-01 00:04:27.00091413066059141155155Main Menu1
291511602D021A0A000432010-06-01 00:04:19.0002010-06-01 00:05:02.00091416207629141155155Main Menu1Product and promotion2
301521602D021A0A000432010-06-01 00:04:19.0002010-06-01 00:05:02.000914162076291411551551Product and promotionMain Menu2Other Offer Details2
311531602D021A0A000432010-06-01 00:04:19.0002010-06-01 00:05:02.000914162076291411551552Other Offer Details1Product and promotion0Agent Transfer2
321541602D021A0A000432010-06-01 00:04:19.0002010-06-01 00:05:02.000914162076291411551550Agent Transfer2Other Offer Details2
331611602D021A0A300432010-06-01 00:05:11.0002010-06-01 00:05:20.00091416124969141155155Main Menu1
341911602D021A0A900432010-06-01 00:05:55.0002010-06-01 00:05:56.00091413029279141155155Main Menu1
351811602D021A0A700432010-06-01 00:05:53.0002010-06-01 00:06:11.00091413698069141155155Main Menu1Product and promotion1
361821602D021A0A700432010-06-01 00:05:53.0002010-06-01 00:06:11.000914136980691411551551Product and promotionMain Menu1
371121602D021A09800432010-06-01 00:03:49.0002010-06-01 00:07:29.000914180581591411551552Handset or RUIM lostMain Menu0
381111602D021A09800432010-06-01 00:03:49.0002010-06-01 00:07:29.00091418058159141155155Main Menu2Handset or RUIM lost0
392011602D021A0AB00432010-06-01 00:07:31.0002010-06-01 00:07:41.00091416564309141155155Main Menu1
401331602D021A09C00432010-06-01 00:04:03.0002010-06-01 00:08:16.000914166882391411551550Agent Transfer3Account0
411311602D021A09C00432010-06-01 00:04:03.0002010-06-01 00:08:16.00091416688239141155155Main Menu3Account0
421321602D021A09C00432010-06-01 00:04:03.0002010-06-01 00:08:16.000914166882391411551553AccountMain Menu0Agent Transfer0
431741602D021A0A500432010-06-01 00:05:23.0002010-06-01 00:10:53.000914135783891411551552Wrong Entry9Repeat Menu0
441711602D021A0A500432010-06-01 00:05:23.0002010-06-01 00:10:53.00091413578389141155155Main Menu3Account0
451721602D021A0A500432010-06-01 00:05:23.0002010-06-01 00:10:53.000914135783891411551553AccountMain Menu9Repeat Menu0
461731602D021A0A500432010-06-01 00:05:23.0002010-06-01 00:10:53.000914135783891411551559Repeat Menu3Account2Wrong Entry0
472211602D021A0B500432010-06-01 00:10:41.0002010-06-01 00:11:01.00091418114079141155155Main Menu1
482311602D021A0C000432010-06-01 00:13:02.0002010-06-01 00:13:20.00091415642209141155155Main Menu1
49311602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.00096032561539133155155Main Menu1Product and promotion0
50371602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551553Wrong Entry3Wrong Entry7Previous Menu0
513111602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551553Wrong Entry4Wrong Entry7Previous Menu0
523121602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551557Previous Menu3Wrong Entry2Wrong Entry0
533141602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551551Wrong Entry2Wrong Entry0Agent Transfer0
54321602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551551Product and promotionMain Menu1Repeat Offer Detail0
55351602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551551Wrong Entry9Repeat Menu3Wrong Entry0
56381602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551557Previous Menu3Wrong Entry3Wrong Entry0
57391602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551553Wrong Entry7Previous Menu4Wrong Entry0
583131602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551552Wrong Entry7Previous Menu1Wrong Entry0
593151602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551550Agent Transfer1Wrong Entry0
60331602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551551Repeat Offer Detail1Product and promotion9Repeat Menu0
61341602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551559Repeat Menu1Repeat Offer Detail1Wrong Entry0
62361602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551553Wrong Entry1Wrong Entry3Wrong Entry0
633101602D021A08500432010-06-01 00:01:04.0002010-06-01 00:13:59.000960325615391331551554Wrong Entry3Wrong Entry3Wrong Entry0
642411602D021A0C200432010-06-01 00:14:02.0002010-06-01 00:14:32.00091413342789141155155Main Menu1
652521602D021A0C900432010-06-01 00:16:33.0002010-06-01 00:16:49.000914146839391411551553AccountMain Menu1
662511602D021A0C900432010-06-01 00:16:33.0002010-06-01 00:16:49.00091414683939141155155Main Menu3Account1
672611602D021A0CD00432010-06-01 00:16:51.0002010-06-01 00:19:32.00091414683939141155155Main Menu0Agent Transfer0
682621602D021A0CD00432010-06-01 00:16:51.0002010-06-01 00:19:32.000914146839391411551550Agent TransferMain Menu0
692821602D021A0D200432010-06-01 00:19:26.0002010-06-01 00:20:34.000914155534591411551550Agent TransferMain Menu2
702811602D021A0D200432010-06-01 00:19:26.0002010-06-01 00:20:34.00091415553459141155155Main Menu0Agent Transfer2
712121602D021A0B000432010-06-01 00:08:45.0002010-06-01 00:20:47.000914166882391411551553AccountMain Menu0Agent Transfer0
722131602D021A0B000432010-06-01 00:08:45.0002010-06-01 00:20:47.000914166882391411551550Agent Transfer3Account0
732111602D021A0B000432010-06-01 00:08:45.0002010-06-01 00:20:47.00091416688239141155155Main Menu3Account0
743121602D021A0D900432010-06-01 00:21:05.0002010-06-01 00:22:09.000914155534591411551550Agent TransferMain Menu2
753111602D021A0D900432010-06-01 00:21:05.0002010-06-01 00:22:09.00091415553459141155155Main Menu0Agent Transfer2
763021602D021A0D700432010-06-01 00:20:51.0002010-06-01 00:23:20.000914168777291411551553AccountMain Menu0Agent Transfer2
773031602D021A0D700432010-06-01 00:20:51.0002010-06-01 00:23:20.000914168777291411551550Agent Transfer3Account2
783011602D021A0D700432010-06-01 00:20:51.0002010-06-01 00:23:20.00091416877729141155155Main Menu3Account2
793311602D021A0DF00432010-06-01 00:22:32.0002010-06-01 00:23:21.00091337118289133155155Main Menu3Account1
803321602D021A0DF00432010-06-01 00:22:32.0002010-06-01 00:23:21.000913371182891331551553AccountMain Menu1
812921602D021A0D400432010-06-01 00:20:12.0002010-06-01 00:23:24.000914166290091411551550Agent TransferMain Menu0
822911602D021A0D400432010-06-01 00:20:12.0002010-06-01 00:23:24.00091416629009141155155Main Menu0Agent Transfer0
832721602D021A0CF00432010-06-01 00:17:44.0002010-06-01 00:23:33.000914150579391411551550Agent TransferMain Menu0
842711602D021A0CF00432010-06-01 00:17:44.0002010-06-01 00:23:33.00091415057939141155155Main Menu0Agent Transfer0
853511602D021A0E300432010-06-01 00:23:24.0002010-06-01 00:23:41.00091415553459141155155Main Menu1
863411602D021A0E100432010-06-01 00:22:33.0002010-06-01 00:24:03.00091337062169133155155Main Menu3Account0
873431602D021A0E100432010-06-01 00:22:33.0002010-06-01 00:24:03.000913370621691331551552How to Recharge & extend Validity3Account0
883421602D021A0E100432010-06-01 00:22:33.0002010-06-01 00:24:03.000913370621691331551553AccountMain Menu2How to Recharge & extend Validity0
893711602D021A0E900432010-06-01 00:24:43.0002010-06-01 00:24:45.00091416081579141155155Main Menu1
903911602D021A0ED00432010-06-01 00:25:05.0002010-06-01 00:25:37.00091416081579141155155Main Menu1
914011602D021A0EF00432010-06-01 00:25:17.0002010-06-01 00:25:40.00091416718169141155155Main Menu1
923841602D021A0EB00432010-06-01 00:24:46.0002010-06-01 00:25:45.000913370621691331551553Wrong Entry4Wrong Entry2
933811602D021A0EB00432010-06-01 00:24:46.0002010-06-01 00:25:45.00091337062169133155155Main Menu3Account2
943831602D021A0EB00432010-06-01 00:24:46.0002010-06-01 00:25:45.000913370621691331551554Wrong Entry3Account3Wrong Entry2
953821602D021A0EB00432010-06-01 00:24:46.0002010-06-01 00:25:45.000913370621691331551553AccountMain Menu4Wrong Entry2
963611602D021A0E700432010-06-01 00:24:35.0002010-06-01 00:27:22.00091416629009141155155Main Menu0Agent Transfer0
973621602D021A0E700432010-06-01 00:24:35.0002010-06-01 00:27:22.000914166290091411551550Agent TransferMain Menu0
983211602D021A0DB00432010-06-01 00:21:28.0002010-06-01 00:28:25.00091414898949141155155Main Menu0Agent Transfer0
993221602D021A0DB00432010-06-01 00:21:28.0002010-06-01 00:28:25.000914148989491411551550Agent TransferMain Menu0
1004311602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.00091417385019141155155Main Menu9Repeat Menu1
1014341602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551551Language Option4TPIN & Language change7Previous Menu1
1024351602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551557Previous Menu1Language Option1Wrong Entry1
1034361602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551551Wrong Entry7Previous Menu9Repeat Menu1
1044371602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551559Repeat Menu1Wrong Entry1
1054321602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551559Repeat MenuMain Menu4TPIN & Language change1
1064331602D021A0F700432010-06-01 00:27:15.0002010-06-01 00:28:56.000914173850191411551554TPIN & Language change9Repeat Menu1Language Option1
1074611602D021A10000432010-06-01 00:29:09.0002010-06-01 00:29:17.00091416081579141155155Main Menu1
1084421602D021A0FC00432010-06-01 00:29:05.0002010-06-01 00:29:21.000915000033691411551552Handset or RUIM lostMain Menu1
1094411602D021A0FC00432010-06-01 00:29:05.0002010-06-01 00:29:21.00091500003369141155155Main Menu2Handset or RUIM lost1
1104131602D021A0F100432010-06-01 00:26:04.0002010-06-01 00:29:46.000913370621691331551550Agent Transfer3Account0
1114111602D021A0F100432010-06-01 00:26:04.0002010-06-01 00:29:46.00091337062169133155155Main Menu3Account0
1124121602D021A0F100432010-06-01 00:26:04.0002010-06-01 00:29:46.000913370621691331551553AccountMain Menu0Agent Transfer0
1134211602D021A0F300432010-06-01 00:26:18.0002010-06-01 00:31:19.00091417961739141155155Main Menu0Agent Transfer0
1144221602D021A0F300432010-06-01 00:26:18.0002010-06-01 00:31:19.000914179617391411551550Agent TransferMain Menu0
1154911602D021A10800432010-06-01 00:32:29.0002010-06-01 00:32:35.00091414247999141155155Main Menu1
1164721602D021A10400432010-06-01 00:31:51.0002010-06-01 00:32:58.000914155534591411551550Agent TransferMain Menu2
1174711602D021A10400432010-06-01 00:31:51.0002010-06-01 00:32:58.00091415553459141155155Main Menu0Agent Transfer2
1185011602D021A10B00432010-06-01 00:33:25.0002010-06-01 00:33:33.00091414247999141155155Main Menu1
1195111602D021A10D00432010-06-01 00:33:30.0002010-06-01 00:33:54.00091417961739141155155Main Menu1
1204521602D021A0FE00432010-06-01 00:29:06.0002010-06-01 00:36:26.000914173850191411551552Handset or RUIM lostMain Menu1Wrong Entry0
1214511602D021A0FE00432010-06-01 00:29:06.0002010-06-01 00:36:26.00091417385019141155155Main Menu2Handset or RUIM lost0
1224531602D021A0FE00432010-06-01 00:29:06.0002010-06-01 00:36:26.000914173850191411551551Wrong Entry2Handset or RUIM lost0
1235321602D021A11100432010-06-01 00:34:14.0002010-06-01 00:36:34.000914179617391411551550Agent TransferMain Menu0
1245311602D021A11100432010-06-01 00:34:14.0002010-06-01 00:36:34.00091417961739141155155Main Menu0Agent Transfer0
1255511602D021A11600432010-06-01 00:37:45.0002010-06-01 00:37:47.00091337166099133155155Main Menu1
1265421602D021A11400432010-06-01 00:36:55.0002010-06-01 00:38:13.000913370059291331551553AccountMain Menu0Agent Transfer1
1275431602D021A11400432010-06-01 00:36:55.0002010-06-01 00:38:13.000913370059291331551550Agent Transfer3Account1
1285411602D021A11400432010-06-01 00:36:55.0002010-06-01 00:38:13.00091337005929133155155Main Menu3Account1
1295211602D021A10F00432010-06-01 00:34:03.0002010-06-01 00:39:54.00091414247999141155155Main Menu0Agent Transfer0
1305221602D021A10F00432010-06-01 00:34:03.0002010-06-01 00:39:54.000914142479991411551550Agent TransferMain Menu0
1314821602D021A10600432010-06-01 00:32:13.0002010-06-01 00:41:04.000914148989491411551550Agent TransferMain Menu0
1324811602D021A10600432010-06-01 00:32:13.0002010-06-01 00:41:04.00091414898949141155155Main Menu0Agent Transfer0
1335611602D021A11900432010-06-01 00:41:22.0002010-06-01 00:43:21.00091417518289141155155Main Menu0Agent Transfer0
1345621602D021A11900432010-06-01 00:41:22.0002010-06-01 00:43:21.000914175182891411551550Agent TransferMain Menu0
1356111602D021A12600432010-06-01 00:45:59.0002010-06-01 00:46:36.00091413213749141155155Main Menu1
1366011602D021A12400432010-06-01 00:45:39.0002010-06-01 00:46:41.00091415553459141155155Main Menu0Agent Transfer2
1376021602D021A12400432010-06-01 00:45:39.0002010-06-01 00:46:41.000914155534591411551550Agent TransferMain Menu2
1386211602D021A12800432010-06-01 00:47:45.0002010-06-01 00:47:47.00091337084659133198198Main Menu1
1395911602D021A12200432010-06-01 00:45:30.0002010-06-01 00:50:12.00091414898949141155155Main Menu0Agent Transfer0
1405921602D021A12200432010-06-01 00:45:30.0002010-06-01 00:50:12.000914148989491411551550Agent TransferMain Menu0
1415721602D021A11C00432010-06-01 00:42:57.0002010-06-01 00:50:29.000914170603891411551550Agent TransferMain Menu0
1425711602D021A11C00432010-06-01 00:42:57.0002010-06-01 00:50:29.00091417060389141155155Main Menu0Agent Transfer0
1435821602D021A11E00432010-06-01 00:43:09.0002010-06-01 00:50:29.000914141294391411551550Agent TransferMain Menu0
1445811602D021A11E00432010-06-01 00:43:09.0002010-06-01 00:50:29.00091414129439141155155Main Menu0Agent Transfer0
1456311602D021A12A00432010-06-01 00:51:26.0002010-06-01 00:51:33.00091337084659133198198Main Menu1
1466421602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.000914134121691411551554TPIN & Language changeMain Menu2Wrong Entry1
1476441602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.000914134121691411551558Main Menu2Wrong Entry4TPIN & Language change1
1486461602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.000914134121691411551552Wrong Entry4TPIN & Language change1
1496451602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.000914134121691411551554TPIN & Language change8Main Menu2Wrong Entry1
1506411602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.00091413412169141155155Main Menu4TPIN & Language change1
1516431602D021A12C00432010-06-01 00:58:32.0002010-06-01 01:00:18.000914134121691411551552Wrong Entry4TPIN & Language change8Main Menu1
1526511602D021A12E00432010-06-01 01:01:47.0002010-06-01 01:02:18.00091413412169141155155Main Menu1
1536611602D021A13000432010-06-01 01:02:25.0002010-06-01 01:03:16.00091413412169141155155Main Menu3Account1
1546651602D021A13000432010-06-01 01:02:25.0002010-06-01 01:03:16.000914134121691411551556Wrong Entry1Tariff info1
1556621602D021A13000432010-06-01 01:02:25.0002010-06-01 01:03:16.000914134121691411551553AccountMain Menu1Know your tariff1
1566641602D021A13000432010-06-01 01:02:25.0002010-06-01 01:03:16.000914134121691411551551Tariff info1Know your tariff6Wrong Entry1
1576631602D021A13000432010-06-01 01:02:25.0002010-06-01 01:03:16.000914134121691411551551Know your tariff3Account1Tariff info1
1586711602D021A13400432010-06-01 01:03:46.0002010-06-01 01:03:50.00091413412169141155155Main Menu1
1596821602D021A13600432010-06-01 01:09:20.0002010-06-01 01:10:43.000914179617391411551551Product and promotionMain Menu1Repeat Offer Detail1
1606831602D021A13600432010-06-01 01:09:20.0002010-06-01 01:10:43.000914179617391411551551Repeat Offer Detail1Product and promotion1
1616811602D021A13600432010-06-01 01:09:20.0002010-06-01 01:10:43.00091417961739141155155Main Menu1Product and promotion1
1627111602D021A13C00432010-06-01 01:11:14.0002010-06-01 01:13:41.00091416622709141155155Main Menu1Product and promotion0
1637131602D021A13C00432010-06-01 01:11:14.0002010-06-01 01:13:41.000914166227091411551550Agent Transfer1Product and promotion0
1647121602D021A13C00432010-06-01 01:11:14.0002010-06-01 01:13:41.000914166227091411551551Product and promotionMain Menu0Agent Transfer0
1657011602D021A13A00432010-06-01 01:10:16.0002010-06-01 01:14:00.00091337111569133155155Main Menu3Account0
1667021602D021A13A00432010-06-01 01:10:16.0002010-06-01 01:14:00.000913371115691331551553AccountMain Menu0Agent Transfer0
1677031602D021A13A00432010-06-01 01:10:16.0002010-06-01 01:14:00.000913371115691331551550Agent Transfer3Account0
1687231602D021A14000432010-06-01 01:14:05.0002010-06-01 01:17:57.000914166227091411551551Repeat Offer Detail1Product and promotion0Agent Transfer0
1697211602D021A14000432010-06-01 01:14:05.0002010-06-01 01:17:57.00091416622709141155155Main Menu1Product and promotion0
1707241602D021A14000432010-06-01 01:14:05.0002010-06-01 01:17:57.000914166227091411551550Agent Transfer1Repeat Offer Detail0
1717221602D021A14000432010-06-01 01:14:05.0002010-06-01 01:17:57.000914166227091411551551Product and promotionMain Menu1Repeat Offer Detail0
1726941602D021A13800432010-06-01 01:10:08.0002010-06-01 01:19:09.000914168726891411551550Agent Transfer9Repeat Menu0
1736911602D021A13800432010-06-01 01:10:08.0002010-06-01 01:19:09.00091416872689141155155Main Menu1Product and promotion0
1746931602D021A13800432010-06-01 01:10:08.0002010-06-01 01:19:09.000914168726891411551559Repeat Menu1Product and promotion0Agent Transfer0
1756921602D021A13800432010-06-01 01:10:08.0002010-06-01 01:19:09.000914168726891411551551Product and promotionMain Menu9Repeat Menu0
1767321602D021A14300432010-06-01 01:18:03.0002010-06-01 01:26:41.000913370142591331551553AccountMain Menu3know the services activated in your account0
1777331602D021A14300432010-06-01 01:18:03.0002010-06-01 01:26:41.000913370142591331551553know the services activated in your account3Account0Agent Transfer0
1787311602D021A14300432010-06-01 01:18:03.0002010-06-01 01:26:41.00091337014259133155155Main Menu3Account0
1797341602D021A14300432010-06-01 01:18:03.0002010-06-01 01:26:41.000913370142591331551550Agent Transfer3know the services activated in your account0
1807411602D021A14700432010-06-01 01:25:36.0002010-06-01 01:28:22.00091337028219133155155Main Menu3Account0
1817421602D021A14700432010-06-01 01:25:36.0002010-06-01 01:28:22.000913370282191331551553AccountMain Menu0Agent Transfer0
1827431602D021A14700432010-06-01 01:25:36.0002010-06-01 01:28:22.000913370282191331551550Agent Transfer3Account0
1837521602D021A14A00432010-06-01 01:35:29.0002010-06-01 01:35:52.000914133547591411551552Handset or RUIM lostMain Menu1
1847511602D021A14A00432010-06-01 01:35:29.0002010-06-01 01:35:52.00091413354759141155155Main Menu2Handset or RUIM lost1
1857611602D021A14C00432010-06-01 01:40:21.0002010-06-01 01:40:39.00091419191519141144144Main Menu1
1867711602D021A14E00432010-06-01 01:41:45.0002010-06-01 01:41:47.00091416622709141155155Main Menu1
1877811602D021A15600432010-06-01 01:46:54.0002010-06-01 01:47:22.00091416704689141155155Main Menu1Product and promotion1
1887821602D021A15600432010-06-01 01:46:54.0002010-06-01 01:47:22.000914167046891411551551Product and promotionMain Menu1
1897931603D09B22B3002A2010-06-01 02:00:25.0002010-06-01 02:03:01.000913371115691331551559Repeat Menu3Account3Wrong Entry1
1907941603D09B22B3002A2010-06-01 02:00:25.0002010-06-01 02:03:01.000913371115691331551553Wrong Entry9Repeat Menu3Wrong Entry1
1917921603D09B22B3002A2010-06-01 02:00:25.0002010-06-01 02:03:01.000913371115691331551553AccountMain Menu9Repeat Menu1
1927951603D09B22B3002A2010-06-01 02:00:25.0002010-06-01 02:03:01.000913371115691331551553Wrong Entry3Wrong Entry1
1937911603D09B22B3002A2010-06-01 02:00:25.0002010-06-01 02:03:01.00091337111569133155155Main Menu3Account1
1948111603D09B22BA002A2010-06-01 02:20:52.0002010-06-01 02:21:12.00091416842169141155155Main Menu1
1958021603D09B22B7002A2010-06-01 02:19:12.0002010-06-01 02:24:26.000914181346091411551559Repeat MenuMain Menu2Handset or RUIM lost0
1968011603D09B22B7002A2010-06-01 02:19:12.0002010-06-01 02:24:26.00091418134609141155155Main Menu9Repeat Menu0
1978031603D09B22B7002A2010-06-01 02:19:12.0002010-06-01 02:24:26.000914181346091411551552Handset or RUIM lost9Repeat Menu0
198821160421A400DE00432010-06-01 02:29:46.0002010-06-01 02:29:58.00091413225249141155155Main Menu1
199831160421A400E000432010-06-01 02:31:01.0002010-06-01 02:31:07.00091413936469141155155Main Menu1
200841160421A400E200432010-06-01 02:39:10.0002010-06-01 02:40:25.00091413627419141155155Main Menu3Account1
201843160421A400E200432010-06-01 02:39:10.0002010-06-01 02:40:25.000914136274191411551551Know your tariff3Account2Roaming Tariff1
202842160421A400E200432010-06-01 02:39:10.0002010-06-01 02:40:25.000914136274191411551553AccountMain Menu1Know your tariff1
203844160421A400E200432010-06-01 02:39:10.0002010-06-01 02:40:25.000914136274191411551552Roaming Tariff1Know your tariff1
204852160421A400E400432010-06-01 02:40:56.0002010-06-01 02:43:17.000914138374091411551557Wrong EntryMain Menu0Agent Transfer0
205851160421A400E400432010-06-01 02:40:56.0002010-06-01 02:43:17.00091413837409141155155Main Menu7Wrong Entry0
206853160421A400E400432010-06-01 02:40:56.0002010-06-01 02:43:17.000914138374091411551550Agent Transfer7Wrong Entry0
207861160421A400F600432010-06-01 03:20:35.0002010-06-01 03:20:56.00091337018309133155155Main Menu1
208871160421A400F800432010-06-01 03:20:41.0002010-06-01 03:20:58.00091415502449141155155Main Menu1
209882160421A400FA00432010-06-01 03:21:42.0002010-06-01 03:21:53.000914155024491411551551Product and promotionMain Menu1
210881160421A400FA00432010-06-01 03:21:42.0002010-06-01 03:21:53.00091415502449141155155Main Menu1Product and promotion1
211891160421A400FC00432010-06-01 03:21:45.0002010-06-01 03:22:02.00091337018309133155155Main Menu1
212901160421A400FE00432010-06-01 03:23:50.0002010-06-01 03:24:03.00091415502449141144144Main Menu1
213921160421A4010200432010-06-01 03:30:29.0002010-06-01 03:30:44.00091418122129141155155Main Menu1
214911160421A4010000432010-06-01 03:30:18.0002010-06-01 03:31:06.00091337188069133155155Main Menu1
215931160421A4010400432010-06-01 03:31:16.0002010-06-01 03:31:37.00091337188069133198198Main Menu1
216941160421A4010600432010-06-01 03:34:34.0002010-06-01 03:34:43.00091337132839133155155Main Menu1
217951160421A4010800432010-06-01 03:35:11.0002010-06-01 03:35:14.00091413402149141155155Main Menu1
218961160421A4010D00432010-06-01 03:43:11.0002010-06-01 03:43:23.00091337018309133155155Main Menu1
219972160421A4010F00432010-06-01 03:43:38.0002010-06-01 03:45:26.000913370183091331551553AccountMain Menu1Know your tariff1
220975160421A4010F00432010-06-01 03:43:38.0002010-06-01 03:45:26.000913370183091331551551Wrong Entry9Repeat Menu1
221973160421A4010F00432010-06-01 03:43:38.0002010-06-01 03:45:26.000913370183091331551551Know your tariff3Account9Repeat Menu1
222974160421A4010F00432010-06-01 03:43:38.0002010-06-01 03:45:26.000913370183091331551559Repeat Menu1Know your tariff1Wrong Entry1
223971160421A4010F00432010-06-01 03:43:38.0002010-06-01 03:45:26.00091337018309133155155Main Menu3Account1
224981160421A4011900432010-06-01 04:12:03.0002010-06-01 04:13:12.00091413204849141144144Main Menu2
225991160421A4011B00432010-06-01 04:16:38.0002010-06-01 04:17:39.00091417567589141155155Main Menu1Product and promotion1
226992160421A4011B00432010-06-01 04:16:38.0002010-06-01 04:17:39.000914175675891411551551Product and promotionMain Menu1Repeat Offer Detail1
227993160421A4011B00432010-06-01 04:16:38.0002010-06-01 04:17:39.000914175675891411551551Repeat Offer Detail1Product and promotion1
2281002160421A4012000432010-06-01 04:48:10.0002010-06-01 04:48:31.000914172829791411551550Agent TransferMain Menu1
2291001160421A4012000432010-06-01 04:48:10.0002010-06-01 04:48:31.00091417282979141155155Main Menu0Agent Transfer1
2301012160421A4012200432010-06-01 04:48:39.0002010-06-01 04:50:55.000914172829791411551550Agent TransferMain Menu0
2311011160421A4012200432010-06-01 04:48:39.0002010-06-01 04:50:55.00091417282979141155155Main Menu0Agent Transfer0
2321021160421A4012500432010-06-01 04:52:27.0002010-06-01 04:52:56.00091417011199141155155Main Menu1
2331031160421A4012700432010-06-01 04:52:57.0002010-06-01 04:53:00.00091417502809141155155Main Menu1
2341041160421A4012900432010-06-01 04:54:50.0002010-06-01 04:57:02.00091417706119141155155Main Menu1Product and promotion0
2351043160421A4012900432010-06-01 04:54:50.0002010-06-01 04:57:02.000914177061191411551550Agent Transfer1Product and promotion0
2361042160421A4012900432010-06-01 04:54:50.0002010-06-01 04:57:02.000914177061191411551551Product and promotionMain Menu0Agent Transfer0
2371051160421A4012C00432010-06-01 04:59:28.0002010-06-01 05:00:06.00091414990089141155155Main Menu1
2381065160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551557Previous Menu1Language Option1Wrong Entry1
2391069160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551551Repeat Offer Detail1Product and promotion1
2401061160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.00091417706119141155155Main Menu9Repeat Menu1
2411062160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551559Repeat MenuMain Menu4TPIN & Language change1
2421063160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551554TPIN & Language change9Repeat Menu1Language Option1
2431068160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551551Product and promotion8Main Menu1Repeat Offer Detail1
2441064160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551551Language Option4TPIN & Language change7Previous Menu1
2451066160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551551Wrong Entry7Previous Menu8Main Menu1
2461067160421A4012E00432010-06-01 04:59:54.0002010-06-01 05:01:54.000914177061191411551558Main Menu1Wrong Entry1Product and promotion1
2471091160421A4013400432010-06-01 05:02:37.0002010-06-01 05:02:46.00091416946949141155155Main Menu1
2481071160421A4013000432010-06-01 05:00:46.0002010-06-01 05:03:03.00091414990089141155155Main Menu2
2491101160421A4013700432010-06-01 05:04:12.0002010-06-01 05:04:25.00091416610739141155155Main Menu1
2501081160421A4013200432010-06-01 05:02:11.0002010-06-01 05:04:54.00091417706119141155155Main Menu0Agent Transfer0
2511082160421A4013200432010-06-01 05:02:11.0002010-06-01 05:04:54.000914177061191411551550Agent TransferMain Menu0
2521111160421A4013900432010-06-01 05:06:07.0002010-06-01 05:07:56.00091417706119141155155Main Menu0Agent Transfer0
2531112160421A4013900432010-06-01 05:06:07.0002010-06-01 05:07:56.000914177061191411551550Agent TransferMain Menu0
2541121160421A4013C00432010-06-01 05:09:52.0002010-06-01 05:10:48.00091414928819141155155Main Menu1Product and promotion1
2551122160421A4013C00432010-06-01 05:09:52.0002010-06-01 05:10:48.000914149288191411551551Product and promotionMain Menu0Agent Transfer1
2561123160421A4013C00432010-06-01 05:09:52.0002010-06-01 05:10:48.000914149288191411551550Agent Transfer1Product and promotion1
2571131160421A4013E00432010-06-01 05:11:21.0002010-06-01 05:15:50.00091417154849141155155Main Menu1Product and promotion0
2581132160421A4013E00432010-06-01 05:11:21.0002010-06-01 05:15:50.000914171548491411551551Product and promotionMain Menu1Repeat Offer Detail0
2591133160421A4013E00432010-06-01 05:11:21.0002010-06-01 05:15:50.000914171548491411551551Repeat Offer Detail1Product and promotion0Agent Transfer0
2601134160421A4013E00432010-06-01 05:11:21.0002010-06-01 05:15:50.000914171548491411551550Agent Transfer1Repeat Offer Detail0
2611151160421A4014600432010-06-01 05:19:49.0002010-06-01 05:19:52.00091337084659133198198Main Menu1
2621161160421A4014900432010-06-01 05:21:17.0002010-06-01 05:21:18.00091337084659133198198Main Menu1
2631141160421A4014400432010-06-01 05:18:22.0002010-06-01 05:23:01.00091413193209141155155Main Menu1Product and promotion0
2641142160421A4014400432010-06-01 05:18:22.0002010-06-01 05:23:01.000914131932091411551551Product and promotionMain Menu9Repeat Menu0
2651143160421A4014400432010-06-01 05:18:22.0002010-06-01 05:23:01.000914131932091411551559Repeat Menu1Product and promotion0Agent Transfer0
2661144160421A4014400432010-06-01 05:18:22.0002010-06-01 05:23:01.000914131932091411551550Agent Transfer9Repeat Menu0
2671172160421A4014B00432010-06-01 05:25:28.0002010-06-01 05:28:07.000914156407691411551552Handset or RUIM lostMain Menu1Wrong Entry1
2681173160421A4014B00432010-06-01 05:25:28.0002010-06-01 05:28:07.000914156407691411551551Wrong Entry2Handset or RUIM lost1Wrong Entry1
2691171160421A4014B00432010-06-01 05:25:28.0002010-06-01 05:28:07.00091415640769141155155Main Menu2Handset or RUIM lost1
2701174160421A4014B00432010-06-01 05:25:28.0002010-06-01 05:28:07.000914156407691411551551Wrong Entry1Wrong Entry1
2711182160421A4014D00432010-06-01 05:28:23.0002010-06-01 05:29:11.00091416011909141155155#Wrong EntryMain Menu1
2721181160421A4014D00432010-06-01 05:28:23.0002010-06-01 05:29:11.00091416011909141155155Main Menu#Wrong Entry1
2731192160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551551Product and promotionMain Menu2Other Offer Details2
2741193160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551552Other Offer Details1Product and promotion5Wrong Entry2
2751194160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551555Wrong Entry2Other Offer Details5Wrong Entry2
2761195160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551555Wrong Entry5Wrong Entry5Wrong Entry2
2771198160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551557Previous Menu7Previous Menu2
2781191160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.00091413158129141155155Main Menu1Product and promotion2
2791196160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551555Wrong Entry5Wrong Entry7Previous Menu2
2801197160421A4014F00432010-06-01 05:30:38.0002010-06-01 05:32:33.000914131581291411551557Previous Menu5Wrong Entry7Previous Menu2
2811211160421A4015300432010-06-01 05:35:07.0002010-06-01 05:35:49.00091414113259141155155Main Menu1
2821203160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551552How to Recharge & extend Validity3Account2Paper Coupon2
2831205160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551551Wrong Entry2Paper Coupon1Wrong Entry2
2841207160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551557Previous Menu1Wrong Entry2
2851201160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.00091416910979141155155Main Menu3Account2
2861202160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551553AccountMain Menu2How to Recharge & extend Validity2
2871204160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551552Paper Coupon2How to Recharge & extend Validity1Wrong Entry2
2881206160421A4015100432010-06-01 05:33:25.0002010-06-01 05:36:02.000914169109791411551551Wrong Entry1Wrong Entry7Previous Menu2
2891232160421A4015700432010-06-01 05:35:57.0002010-06-01 05:37:25.000914141132591411551553AccountMain Menu2How to Recharge & extend Validity1
2901233160421A4015700432010-06-01 05:35:57.0002010-06-01 05:37:25.000914141132591411551552How to Recharge & extend Validity3Account2Paper Coupon1
2911234160421A4015700432010-06-01 05:35:57.0002010-06-01 05:37:25.000914141132591411551552Paper Coupon2How to Recharge & extend Validity1
2921231160421A4015700432010-06-01 05:35:57.0002010-06-01 05:37:25.00091414113259141155155Main Menu3Account1
2931221160421A4015500432010-06-01 05:35:39.0002010-06-01 05:37:35.00091413124429141155155Main Menu1Product and promotion0
2941222160421A4015500432010-06-01 05:35:39.0002010-06-01 05:37:35.000914131244291411551551Product and promotionMain Menu0Agent Transfer0
2951223160421A4015500432010-06-01 05:35:39.0002010-06-01 05:37:35.000914131244291411551550Agent Transfer1Product and promotion0
2961241160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.00091416910979141155155Main Menu3Account2
2971242160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551553AccountMain Menu2How to Recharge & extend Validity2
2981245160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551551Wrong Entry2Paper Coupon1Wrong Entry2
2991246160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551551Wrong Entry1Wrong Entry7Previous Menu2
3001247160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551557Previous Menu1Wrong Entry2Wrong Entry2
30112410160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551551Wrong Entry1Wrong Entry1Wrong Entry2
3021244160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551552Paper Coupon2How to Recharge & extend Validity1Wrong Entry2
3031248160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551552Wrong Entry7Previous Menu1Wrong Entry2
30412412160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551557Previous Menu1Wrong Entry2
3051243160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551552How to Recharge & extend Validity3Account2Paper Coupon2
3061249160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551551Wrong Entry2Wrong Entry1Wrong Entry2
30712411160421A4015900432010-06-01 05:36:31.0002010-06-01 05:37:56.000914169109791411551551Wrong Entry1Wrong Entry7Previous Menu2
3081261160421A4015E00432010-06-01 05:38:51.0002010-06-01 05:38:59.00091413217399141155155Main Menu1
3091252160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551553AccountMain Menu1Know your tariff1
3101253160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551551Know your tariff3Account1Tariff info1
3111255160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551552Wrong Entry1Tariff info7Previous Menu1
3121256160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551557Previous Menu2Wrong Entry1Wrong Entry1
31312513160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551555Wrong Entry9Repeat Menu5Wrong Entry1
3141259160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551558Main Menu7Previous Menu1Product and promotion1
3151251160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.00091418155089141155155Main Menu3Account1
31612510160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551551Product and promotion8Main Menu2Other Offer Details1
31712511160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551552Other Offer Details1Product and promotion9Repeat Menu1
31812514160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551555Wrong Entry5Wrong Entry7Previous Menu1
3191254160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551551Tariff info1Know your tariff2Wrong Entry1
3201257160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551551Wrong Entry7Previous Menu7Previous Menu1
3211258160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551557Previous Menu1Wrong Entry8Main Menu1
32212512160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551559Repeat Menu2Other Offer Details5Wrong Entry1
32312515160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551557Previous Menu5Wrong Entry7Previous Menu1
32412516160421A4015B00432010-06-01 05:36:32.0002010-06-01 05:40:40.000914181550891411551557Previous Menu7Previous Menu1
3251271160421A4016000432010-06-01 05:41:05.0002010-06-01 05:41:07.00093919669369133155155Main Menu1
3261281160421A4016200432010-06-01 05:41:35.0002010-06-01 05:42:34.00091417247459141155155Main Menu2Handset or RUIM lost1
3271282160421A4016200432010-06-01 05:41:35.0002010-06-01 05:42:34.000914172474591411551552Handset or RUIM lostMain Menu1
3281291160421A4016400432010-06-01 05:43:23.0002010-06-01 05:43:35.00091417247459141155155Main Menu1
3291301160421A4016600432010-06-01 05:49:51.0002010-06-01 05:51:12.00091414463159141155155Main Menu0Agent Transfer0
3301302160421A4016600432010-06-01 05:49:51.0002010-06-01 05:51:12.000914144631591411551550Agent TransferMain Menu0
3311312160421A4016900432010-06-01 05:51:25.0002010-06-01 05:52:01.000914144631591411551550Agent TransferMain Menu0
3321311160421A4016900432010-06-01 05:51:25.0002010-06-01 05:52:01.00091414463159141155155Main Menu0Agent Transfer0
3331322160421A4016B00432010-06-01 05:51:45.0002010-06-01 05:54:42.000914150483191411551551Product and promotionMain Menu0Agent Transfer0
3341321160421A4016B00432010-06-01 05:51:45.0002010-06-01 05:54:42.00091415048319141155155Main Menu1Product and promotion0
3351323160421A4016B00432010-06-01 05:51:45.0002010-06-01 05:54:42.000914150483191411551550Agent Transfer1Product and promotion0
3361342160421A4017200432010-06-01 05:55:29.0002010-06-01 05:56:41.000914176854791411551553AccountMain Menu3know the services activated in your account1
3371341160421A4017200432010-06-01 05:55:29.0002010-06-01 05:56:41.00091417685479141155155Main Menu3Account1
3381343160421A4017200432010-06-01 05:55:29.0002010-06-01 05:56:41.000914176854791411551553know the services activated in your account3Account1
3391331160421A4016E00432010-06-01 05:52:24.0002010-06-01 05:57:36.00091414463159141155155Main Menu0Agent Transfer0
3401332160421A4016E00432010-06-01 05:52:24.0002010-06-01 05:57:36.000914144631591411551550Agent TransferMain Menu0
3411361160421A4017700432010-06-01 05:58:15.0002010-06-01 05:58:38.00091337039019133155155Main Menu1
3421351160421A4017500432010-06-01 05:57:55.0002010-06-01 05:59:18.00091415994769141155155Main Menu1Product and promotion2
3431352160421A4017500432010-06-01 05:57:55.0002010-06-01 05:59:18.000914159947691411551551Product and promotionMain Menu0Agent Transfer2
3441353160421A4017500432010-06-01 05:57:55.0002010-06-01 05:59:18.000914159947691411551550Agent Transfer1Product and promotion2
3451371160421A4017900432010-06-01 05:59:35.0002010-06-01 06:00:30.00091413671509141155155Main Menu3Account2
3461372160421A4017900432010-06-01 05:59:35.0002010-06-01 06:00:30.000914136715091411551553AccountMain Menu2
3471401160421A4018000432010-06-01 06:01:19.0002010-06-01 06:01:21.00091414398359141155155Main Menu1
3481421160421A4018400432010-06-01 06:02:01.0002010-06-01 06:02:05.00091415957499141155155Main Menu1
3491395160421A4017D00432010-06-01 05:59:54.0002010-06-01 06:02:43.000914142828891411551558Main Menu2Wrong Entry1
3501391160421A4017D00432010-06-01 05:59:54.0002010-06-01 06:02:43.00091414282889141155155Main Menu1Product and promotion1
3511394160421A4017D00432010-06-01 05:59:54.0002010-06-01 06:02:43.000914142828891411551552Wrong Entry9Repeat Menu8Main Menu1
3521392160421A4017D00432010-06-01 05:59:54.0002010-06-01 06:02:43.000914142828891411551551Product and promotionMain Menu9Repeat Menu1
3531393160421A4017D00432010-06-01 05:59:54.0002010-06-01 06:02:43.000914142828891411551559Repeat Menu1Product and promotion2Wrong Entry1
3541411160421A4018200432010-06-01 06:01:48.0002010-06-01 06:03:18.00091413325619141155155Main Menu1
3551431160421A4018600432010-06-01 06:03:45.0002010-06-01 06:04:17.00091416434799141155155Main Menu1
3561442160421A4018800432010-06-01 06:04:43.0002010-06-01 06:06:54.000914150483191411551550Agent TransferMain Menu0
3571441160421A4018800432010-06-01 06:04:43.0002010-06-01 06:06:54.00091415048319141155155Main Menu0Agent Transfer0
3581491160421A4019400432010-06-01 06:06:54.0002010-06-01 06:07:07.00091414018189141155155Main Menu1
3591451160421A4018A00432010-06-01 06:05:12.0002010-06-01 06:07:29.00091413131269141155155Main Menu2
3601481160421A4019100432010-06-01 06:06:32.0002010-06-01 06:07:29.00091413656529141155155Main Menu2
3611383160421A4017B00432010-06-01 05:59:43.0002010-06-01 06:08:38.000913370009091331551550Agent Transfer3Account0
3621381160421A4017B00432010-06-01 05:59:43.0002010-06-01 06:08:38.00091337000909133155155Main Menu3Account0
3631382160421A4017B00432010-06-01 05:59:43.0002010-06-01 06:08:38.000913370009091331551553AccountMain Menu0Agent Transfer0
3641462160421A4018D00432010-06-01 06:05:28.0002010-06-01 06:08:39.000914170194691411551550Agent TransferMain Menu0
3651461160421A4018D00432010-06-01 06:05:28.0002010-06-01 06:08:39.00091417019469141155155Main Menu0Agent Transfer0
3661472160421A4018F00432010-06-01 06:06:06.0002010-06-01 06:10:04.000914143169191411551550Agent TransferMain Menu0
3671471160421A4018F00432010-06-01 06:06:06.0002010-06-01 06:10:04.00091414316919141155155Main Menu0Agent Transfer0
3681512160421A4019A00432010-06-01 06:08:35.0002010-06-01 06:10:44.000914150021091411551550Agent TransferMain Menu0
3691511160421A4019A00432010-06-01 06:08:35.0002010-06-01 06:10:44.00091415002109141155155Main Menu0Agent Transfer0
3701541160421A401A500432010-06-01 06:10:39.0002010-06-01 06:11:07.00091416581689141155155Main Menu1
3711561160421A401AA00432010-06-01 06:11:12.0002010-06-01 06:11:15.00091417608639141155155Main Menu1
3721571160421A401AE00432010-06-01 06:12:15.0002010-06-01 06:12:22.00091414389659141055255Main Menu1
3731503160421A4019600432010-06-01 06:07:12.0002010-06-01 06:13:06.000914136565291411551550Agent Transfer1Product and promotion0
3741502160421A4019600432010-06-01 06:07:12.0002010-06-01 06:13:06.000914136565291411551551Product and promotionMain Menu0Agent Transfer0
3751501160421A4019600432010-06-01 06:07:12.0002010-06-01 06:13:06.00091413656529141155155Main Menu1Product and promotion0
3761552160421A401A800432010-06-01 06:11:11.0002010-06-01 06:13:44.000914150021091411551550Agent TransferMain Menu0
3771551160421A401A800432010-06-01 06:11:11.0002010-06-01 06:13:44.00091415002109141155155Main Menu0Agent Transfer0
3781522160421A4019C00432010-06-01 06:09:03.0002010-06-01 06:14:14.000914145434891411551550Agent TransferMain Menu0
3791521160421A4019C00432010-06-01 06:09:03.0002010-06-01 06:14:14.00091414543489141155155Main Menu0Agent Transfer0
3801591160421A401B500432010-06-01 06:13:13.0002010-06-01 06:14:22.00091413325619141155155Main Menu1
3811532160421A401A100432010-06-01 06:10:09.0002010-06-01 06:15:05.000954259715291331551551Product and promotionMain Menu2Other Offer Details0
3821533160421A401A100432010-06-01 06:10:09.0002010-06-01 06:15:05.000954259715291331551552Other Offer Details1Product and promotion0
3831531160421A401A100432010-06-01 06:10:09.0002010-06-01 06:15:05.00095425971529133155155Main Menu1Product and promotion0
3841602160421A401B700432010-06-01 06:13:23.0002010-06-01 06:17:43.000914168886691411551550Agent TransferMain Menu0
3851601160421A401B700432010-06-01 06:13:23.0002010-06-01 06:17:43.00091416888669141155155Main Menu0Agent Transfer0
3861633160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Language Option4TPIN & Language change7Previous Menu2
3871636160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry1Wrong Entry7Previous Menu2
3881639160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
38916310160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu4Wrong Entry2
39016315160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
39116316160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
3921631160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.00091417717539141155155Main Menu4TPIN & Language change2
3931632160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551554TPIN & Language changeMain Menu1Language Option2
3941634160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu1Language Option1Wrong Entry2
3951637160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
3961638160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
39716311160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551554Wrong Entry1Wrong Entry7Previous Menu2
39816314160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
3991635160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu1Wrong Entry2
40016312160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551557Previous Menu4Wrong Entry1Wrong Entry2
40116313160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
40216317160421A401C100432010-06-01 06:15:34.0002010-06-01 06:17:49.000914177175391411551551Wrong Entry7Previous Menu2
4031611160421A401BB00432010-06-01 06:14:28.0002010-06-01 06:18:19.00091414297079141155155Main Menu1Product and promotion0
4041612160421A401BB00432010-06-01 06:14:28.0002010-06-01 06:18:19.000914142970791411551551Product and promotionMain Menu0Agent Transfer0
4051613160421A401BB00432010-06-01 06:14:28.0002010-06-01 06:18:19.000914142970791411551550Agent Transfer1Product and promotion0
4061661160421A401CB00432010-06-01 06:18:07.0002010-06-01 06:19:11.00095425971529133155155Main Menu2
4071693160421A401D200432010-06-01 06:19:53.0002010-06-01 06:20:06.000914174406991411551551Repeat Offer Detail1Product and promotion1
4081691160421A401D200432010-06-01 06:19:53.0002010-06-01 06:20:06.00091417440699141155155Main Menu1Product and promotion1
4091692160421A401D200432010-06-01 06:19:53.0002010-06-01 06:20:06.000914174406991411551551Product and promotionMain Menu1Repeat Offer Detail1
4101683160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Language Option4TPIN & Language change7Previous Menu2
4111689160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
41216810160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
41316816160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
41416819160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
41516832160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
41616835160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
41716838160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu7Previous Menu2
4181681160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.00091417717539141155155Main Menu4TPIN & Language change2
4191684160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Language Option1Wrong Entry2
4201685160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
42116814160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
42216815160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
42316820160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
42416821160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
42516826160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.00091417717539141155155*Wrong Entry1Wrong Entry1Wrong Entry2
42616827160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry*Wrong Entry7Previous Menu2
42716830160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
42816831160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
4291682160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551554TPIN & Language changeMain Menu1Language Option2
4301688160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
43116811160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
43216817160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
43316818160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
43416824160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
43516833160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
43616834160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
4371686160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
4381687160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
43916812160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
44016813160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
44116822160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
44216823160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
44316825160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu*Wrong Entry2
44416828160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry1Wrong Entry2
44516829160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551551Wrong Entry7Previous Menu7Previous Menu2
44616836160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu1Wrong Entry7Previous Menu2
44716837160421A401CF00432010-06-01 06:18:45.0002010-06-01 06:20:14.000914177175391411551557Previous Menu7Previous Menu7Previous Menu2
4481703160421A401D500432010-06-01 06:20:25.0002010-06-01 06:20:46.00091417717539141155155#Wrong Entry#Wrong Entry0Agent Transfer0
4491701160421A401D500432010-06-01 06:20:25.0002010-06-01 06:20:46.00091417717539141155155Main Menu#Wrong Entry0
4501702160421A401D500432010-06-01 06:20:25.0002010-06-01 06:20:46.00091417717539141155155#Wrong EntryMain Menu#Wrong Entry0
4511704160421A401D500432010-06-01 06:20:25.0002010-06-01 06:20:46.000914177175391411551550Agent Transfer#Wrong Entry0
4521651160421A401C700432010-06-01 06:17:25.0002010-06-01 06:20:56.00091415624769141155155Main Menu0Agent Transfer0
4531652160421A401C700432010-06-01 06:17:25.0002010-06-01 06:20:56.000914156247691411551550Agent TransferMain Menu0
4541711160421A401D800432010-06-01 06:20:55.0002010-06-01 06:21:29.00091417717539141155155Main Menu0Agent Transfer0
4551712160421A401D800432010-06-01 06:20:55.0002010-06-01 06:21:29.000914177175391411551550Agent TransferMain Menu0
4561582160421A401B000432010-06-01 06:12:37.0002010-06-01 06:21:49.000914169109791411551550Agent TransferMain Menu0
4571581160421A401B000432010-06-01 06:12:37.0002010-06-01 06:21:49.00091416910979141155155Main Menu0Agent Transfer0
4581731160421A401DD00432010-06-01 06:21:56.0002010-06-01 06:22:11.00091413943839141155155Main Menu1
4591753160421A401E100432010-06-01 06:22:44.0002010-06-01 06:23:28.000913371887791331551553Wrong Entry1Product and promotion1Wrong Entry1
4601754160421A401E100432010-06-01 06:22:44.0002010-06-01 06:23:28.000913371887791331551551Wrong Entry3Wrong Entry1Wrong Entry1
4611752160421A401E100432010-06-01 06:22:44.0002010-06-01 06:23:28.000913371887791331551551Product and promotionMain Menu3Wrong Entry1
4621751160421A401E100432010-06-01 06:22:44.0002010-06-01 06:23:28.00091337188779133155155Main Menu1Product and promotion1
4631755160421A401E100432010-06-01 06:22:44.0002010-06-01 06:23:28.000913371887791331551551Wrong Entry1Wrong Entry1
4641621160421A401BE00432010-06-01 06:14:35.0002010-06-01 06:23:33.00091337372009133155155Main Menu1Product and promotion0
4651622160421A401BE00432010-06-01 06:14:35.0002010-06-01 06:23:33.000913373720091331551551Product and promotionMain Menu0Agent Transfer0
4661623160421A401BE00432010-06-01 06:14:35.0002010-06-01 06:23:33.000913373720091331551550Agent Transfer1Product and promotion0
4671763160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.000914139438391411551557Previous Menu1Product and promotion7Previous Menu0
4681762160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.000914139438391411551551Product and promotionMain Menu7Previous Menu0
4691761160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.00091413943839141155155Main Menu1Product and promotion0
4701765160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.000914139438391411551552Wrong Entry7Previous Menu2Handset or RUIM lost0
4711766160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.000914139438391411551552Handset or RUIM lost2Wrong Entry0
4721764160421A401E300432010-06-01 06:22:49.0002010-06-01 06:24:12.000914139438391411551557Previous Menu7Previous Menu2Wrong Entry0
4731771160421A401E800432010-06-01 06:23:56.0002010-06-01 06:24:18.00091417977059141155155Main Menu1
4741742160421A401DF00432010-06-01 06:22:33.0002010-06-01 06:25:37.000914130506091411551552Handset or RUIM lostMain Menu0
4751741160421A401DF00432010-06-01 06:22:33.0002010-06-01 06:25:37.00091413050609141155155Main Menu2Handset or RUIM lost0
4761781160421A401EB00432010-06-01 06:25:35.0002010-06-01 06:25:38.00091414798189141155155Main Menu1
4771791160421A401ED00432010-06-01 06:25:38.0002010-06-01 06:25:44.00091416839069141155155Main Menu1
4781671160421A401CD00432010-06-01 06:18:44.0002010-06-01 06:26:04.00091414528029141155155Main Menu3Account0
4791672160421A401CD00432010-06-01 06:18:44.0002010-06-01 06:26:04.000914145280291411551553AccountMain Menu0Agent Transfer0
4801673160421A401CD00432010-06-01 06:18:44.0002010-06-01 06:26:04.000914145280291411551550Agent Transfer3Account0
4811722160421A401DA00432010-06-01 06:21:21.0002010-06-01 06:26:24.000914175632391411551559Repeat MenuMain Menu0Agent Transfer0
4821721160421A401DA00432010-06-01 06:21:21.0002010-06-01 06:26:24.00091417563239141155155Main Menu9Repeat Menu0
4831723160421A401DA00432010-06-01 06:21:21.0002010-06-01 06:26:24.000914175632391411551550Agent Transfer9Repeat Menu0
4841811160421A401F100432010-06-01 06:26:24.0002010-06-01 06:26:37.00091410251549141455455Main Menu2
4851642160421A401C500432010-06-01 06:17:18.0002010-06-01 06:26:54.000913370849691331551551Product and promotionMain Menu1Repeat Offer Detail0
4861645160421A401C500432010-06-01 06:17:18.0002010-06-01 06:26:54.000913370849691331551550Agent Transfer1Wrong Entry0
4871643160421A401C500432010-06-01 06:17:18.0002010-06-01 06:26:54.000913370849691331551551Repeat Offer Detail1Product and promotion1Wrong Entry0
4881644160421A401C500432010-06-01 06:17:18.0002010-06-01 06:26:54.000913370849691331551551Wrong Entry1Repeat Offer Detail0Agent Transfer0
4891641160421A401C500432010-06-01 06:17:18.0002010-06-01 06:26:54.00091337084969133155155Main Menu1Product and promotion0
4901831160421A401F500432010-06-01 06:26:49.0002010-06-01 06:27:01.00091410251549141455455Main Menu2
4911861160421A401FC00432010-06-01 06:27:12.0002010-06-01 06:27:25.00091410251549141455455Main Menu2
4921803160421A401EF00432010-06-01 06:26:05.0002010-06-01 06:27:34.000404012464791331551552Wrong Entry2Handset or RUIM lost9Repeat Menu0
4931805160421A401EF00432010-06-01 06:26:05.0002010-06-01 06:27:34.000404012464791331551550Agent Transfer9Repeat Menu0
4941802160421A401EF00432010-06-01 06:26:05.0002010-06-01 06:27:34.000404012464791331551552Handset or RUIM lostMain Menu2Wrong Entry0
4951801160421A401EF00432010-06-01 06:26:05.0002010-06-01 06:27:34.00040401246479133155155Main Menu2Handset or RUIM lost0
4961804160421A401EF00432010-06-01 06:26:05.0002010-06-01 06:27:34.000404012464791331551559Repeat Menu2Wrong Entry0Agent Transfer0
4971871160421A401FE00432010-06-01 06:27:19.0002010-06-01 06:28:23.00091419220589141155155Main Menu2Handset or RUIM lost0
4981872160421A401FE00432010-06-01 06:27:19.0002010-06-01 06:28:23.000914192205891411551552Handset or RUIM lostMain Menu0
4991901160421A4020700432010-06-01 06:28:16.0002010-06-01 06:28:29.00091410251549141455455Main Menu2
5001821160421A401F300432010-06-01 06:26:40.0002010-06-01 06:28:42.00091413149649141155155Main Menu1Product and promotion0
5011822160421A401F300432010-06-01 06:26:40.0002010-06-01 06:28:42.000914131496491411551551Product and promotionMain Menu0Agent Transfer0
5021823160421A401F300432010-06-01 06:26:40.0002010-06-01 06:28:42.000914131496491411551550Agent Transfer1Product and promotion0
5031881160421A4020200432010-06-01 06:28:01.0002010-06-01 06:28:50.00091415893239141155155Main Menu1
5041922160421A4020B00432010-06-01 06:28:37.0002010-06-01 06:28:50.000914102515491414554552Handset or RUIM lostMain Menu2
5051921160421A4020B00432010-06-01 06:28:37.0002010-06-01 06:28:50.00091410251549141455455Main Menu2Handset or RUIM lost2
5061961160421A4021500432010-06-01 06:29:48.0002010-06-01 06:29:48.00091418034219141155155Main Menu1
5071951160421A4021300432010-06-01 06:29:45.0002010-06-01 06:29:49.00091416881689141155155Main Menu1
5081911160421A4020900432010-06-01 06:28:28.0002010-06-01 06:29:51.00091415596269141155155Main Menu1
5091841160421A401F700432010-06-01 06:26:50.0002010-06-01 06:30:12.00091418287319141155155Main Menu0Agent Transfer0
5101842160421A401F700432010-06-01 06:26:50.0002010-06-01 06:30:12.000914182873191411551550Agent TransferMain Menu0
5111974160421A4021700432010-06-01 06:29:57.0002010-06-01 06:30:19.000914180342191411551553Offer 32Other Offer Details1
5121971160421A4021700432010-06-01 06:29:57.0002010-06-01 06:30:19.00091418034219141155155Main Menu1Product and promotion1
5131973160421A4021700432010-06-01 06:29:57.0002010-06-01 06:30:19.000914180342191411551552Other Offer Details1Product and promotion3Offer 31
5141972160421A4021700432010-06-01 06:29:57.0002010-06-01 06:30:19.000914180342191411551551Product and promotionMain Menu2Other Offer Details1
5151891160421A4020400432010-06-01 06:28:10.0002010-06-01 06:30:53.00091416637129141155155Main Menu0Agent Transfer0
5161892160421A4020400432010-06-01 06:28:10.0002010-06-01 06:30:53.000914166371291411551550Agent TransferMain Menu0
5171931160421A4020E00432010-06-01 06:29:20.0002010-06-01 06:30:55.00091415893239141155155Main Menu0Agent Transfer0
5181932160421A4020E00432010-06-01 06:29:20.0002010-06-01 06:30:55.000914158932391411551550Agent TransferMain Menu0
5192011160421A4022200432010-06-01 06:30:49.0002010-06-01 06:31:18.00091417725799141155155Main Menu0Agent Transfer0
5202012160421A4022200432010-06-01 06:30:49.0002010-06-01 06:31:18.000914177257991411551550Agent TransferMain Menu0
5211982160421A4021B00432010-06-01 06:30:34.0002010-06-01 06:31:39.000914166038791411551551Product and promotionMain Menu1Repeat Offer Detail2
5221983160421A4021B00432010-06-01 06:30:34.0002010-06-01 06:31:39.000914166038791411551551Repeat Offer Detail1Product and promotion0Agent Transfer2
5231981160421A4021B00432010-06-01 06:30:34.0002010-06-01 06:31:39.00091416603879141155155Main Menu1Product and promotion2
5241984160421A4021B00432010-06-01 06:30:34.0002010-06-01 06:31:39.000914166038791411551550Agent Transfer1Repeat Offer Detail2
5251991160421A4021E00432010-06-01 06:30:42.0002010-06-01 06:31:42.00091413734439141155155Main Menu3Account1
5261993160421A4021E00432010-06-01 06:30:42.0002010-06-01 06:31:42.000914137344391411551551Know your tariff3Account1
5271992160421A4021E00432010-06-01 06:30:42.0002010-06-01 06:31:42.000914137344391411551553AccountMain Menu1Know your tariff1
5282041160421A4022800432010-06-01 06:31:11.0002010-06-01 06:31:57.00091413093929141155155Main Menu2Handset or RUIM lost1
5292042160421A4022800432010-06-01 06:31:11.0002010-06-01 06:31:57.000914130939291411551552Handset or RUIM lostMain Menu1
5301941160421A4021000432010-06-01 06:29:22.0002010-06-01 06:32:23.00091410251549141155155Main Menu1Product and promotion0
Viewing 15 posts - 1 through 15 (of 24 total)
You must be logged in to reply to this topic. Login to reply