GROUP BY PROBLEM IN SP

Question

GROUP BY PROBLEM IN SP

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

Amusing, but unhelpful. Now if you could just put in all the commas, quotes, SELECTs etc. to make this a runnable script, we'd have a terrific set of data to test against. I'm sure the problem with the code is trivial.

Edit: misspelling caused by tuesday afternoon irritation.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

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

steveb. SSC-Forever Points: 46733 More actions · Answer 2

if you are having trouble getting the test data into a usable form for help, there is a nice script here that may help.

http://www.sqlservercentral.com/articles/T-SQL/66987/"> http://www.sqlservercentral.com/articles/T-SQL/66987/

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

steveb. (11/16/2010)
if you are having trouble getting the test data into a usable form for help, there is a nice script here that may help.
http://www.sqlservercentral.com/articles/T-SQL/66987/"> http://www.sqlservercentral.com/articles/T-SQL/66987/

Thanks Steve.

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

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

brainblower13 Right there with Babe Points: 719 More actions · Answer 4

select 1, 2 ,1, 1602D021A0830043 ,2010-06-01 00:00:44.000 ,2010-06-01 00:01:34.000, 9141741452 ,9141155155 ,Main Menu, 1 ,Product and promotion, 1

select 2 ,2 ,2, 1602D021A0830043, 2010-06-01 00:00:44.000, 2010-06-01 00:01:34.000, 9141741452 ,9141155155, 1 ,Product and promotion, Main Menu, 2 ,Other Offer Details ,1

select 3, 2, 3,1602D021A0830043, 2010-06-01 00:00:44.000, 2010-06-01 00:01:34.000 ,9141741452 ,9141155155, 2, Other Offer Details ,1 ,Product and promotion ,3, Offer, 3, 1,

select 4 ,2 ,5,1602D021A0830043, 2010-06-01 00:00:44.000, 2010-06-01 00:01:34.000 ,9141741452, 9141155155 ,1 ,Wrong Entry ,3 ,Offer, 3, 1

select 5, 2, 4 ,1602D021A0830043 ,2010-06-01 00:00:44.000, 2010-06-01 00:01:34.000,9141741452, 9141155155 ,3, Offer, 3, 2, Other Offer Details ,1 ,Wrong Entry, 1

select 6 ,4, 1 ,1602D021A0870043, 2010-06-01 00:01:31.000, 2010-06-01 00:02:08.000 ,9141771654, 9141155155, Main Menu ,2 ,Handset or RUIM lost, 1

select 7, 4 ,2 ,1602D021A0870043, 2010-06-01 00:01:31.000, 2010-06-01 00:02:08.000 ,9141771654 ,9141155155 ,2 ,Handset or RUIM lost ,Main Menu ,1

select 8, 6 ,1, 1602D021A08D0043 ,2010-06-01 00:02:20.000, 2010-06-01 00:02:36.000, 9141364118 ,9141155155, Main Menu ,1,

select 9, 5, 2, 1602D021A0890043 ,2010-06-01 00:01:43.000, 2010-06-01 00:02:59.000, 9141741452 ,9141155155, 0 ,Agent Transfer, Main Menu ,0

select 10 ,5, 1, 1602D021A0890043 ,2010-06-01 00:01:43.000 ,2010-06-01 00:02:59.000 ,9141741452 ,9141155155 ,Main Menu ,0, Agent Transfer ,0

select 11, 7 ,1, 1602D021A08F0043, 2010-06-01 00:02:59.000 ,2010-06-01 00:03:04.000, 9141620762 ,9141155155, Main Menu, 1 ,Product and promotion ,2

select 12, 7, 2, 1602D021A08F0043, 2010-06-01 00:02:59.000 ,2010-06-01 00:03:04.000, 9141620762, 9141155155, 1, Product and promotion ,Main Menu ,2, Other Offer Details, 2

select 13, 7, 3 ,1602D021A08F0043 ,2010-06-01 00:02:59.000 ,2010-06-01 00:03:04.000 ,9141620762 ,9141155155, 2 ,Other Offer Details ,1 ,Product and promotion ,0 ,Agent Transfer, 2

select 14, 7, 4 ,1602D021A08F0043, 2010-06-01 00:02:59.000 ,2010-06-01 00:03:04.000, 9141620762 ,9141155155, 0, Agent Transfer ,2, Other Offer Details, 2

select 15 ,1, 3 ,1602D021A0810043 ,2010-06-01 00:00:37.000, 2010-06-01 00:03:08.000 ,9141807828, 9141155155, 0 ,Agent Transfer ,1, Product and promotion, 0

select 16, 1, 1 ,1602D021A0810043 ,2010-06-01 00:00:37.000, 2010-06-01 00:03:08.000, 9141807828 ,9141155155, Main Menu, 1 ,Product and promotion, 0

select 17, 1, 2 ,1602D021A0810043, 2010-06-01 00:00:37.000 ,2010-06-01 00:03:08.000, 9141807828 ,9141155155 ,1 ,Product and promotion, Main Menu ,0, Agent Transfer, 0

select 18, 8 ,1 ,1602D021A0910043, 2010-06-01 00:03:03.000, 2010-06-01 00:03:14.000 ,9141612496, 9141155155 ,Main Menu ,1

select 19, 9 ,1, 1602D021A0930043 ,2010-06-01 00:03:13.000, 2010-06-01 00:03:22.000 ,9141620762, 9141155155, Main Menu ,1, Product and promotion, 2

select 20, 9, 2, 1602D021A0930043 ,2010-06-01 00:03:13.000 ,2010-06-01 00:03:22.000, 9141620762 ,9141155155 ,1 ,Product and promotion ,Main Menu, 2, Other Offer Details, 2

select 21 ,9 ,3, 1602D021A0930043, 2010-06-01 00:03:13.000, 2010-06-01 00:03:22.000, 9141620762 ,9141155155 ,2, Other Offer Details, 1, Product and promotion, 0 ,Agent Transfer, 2

select 22, 9,4 ,1602D021A0930043 ,2010-06-01 00:03:13.000, 2010-06-01 00:03:22.000 ,9141620762 ,9141155155 ,0 ,Agent Transfer, 2 ,Other Offer Details, 2

select 23, 10 ,1 ,1602D021A0960043 2010-06-01 00:03:36.000 2010-06-01 00:03:42.000 9866636057 9133155155 Main Menu 1

24 12 2 1602D021A09A0043 2010-06-01 00:03:49.000 2010-06-01 00:03:59.000 9141620762 9141155155 1 Product and promotion Main Menu 2 Other Offer Details 2

25 12 3 1602D021A09A0043 2010-06-01 00:03:49.000 2010-06-01 00:03:59.000 9141620762 9141155155 2 Other Offer Details 1 Product and promotion 0 Agent Transfer 2

26 12 4 1602D021A09A0043 2010-06-01 00:03:49.000 2010-06-01 00:03:59.000 9141620762 9141155155 0 Agent Transfer 2 Other Offer Details 2

27 12 1 1602D021A09A0043 2010-06-01 00:03:49.000 2010-06-01 00:03:59.000 9141620762 9141155155 Main Menu 1 Product and promotion 2

28 14 1 1602D021A09E0043 2010-06-01 00:04:17.000 2010-06-01 00:04:27.000 9141306605 9141155155 Main Menu 1

29 15 1 1602D021A0A00043 2010-06-01 00:04:19.000 2010-06-01 00:05:02.000 9141620762 9141155155 Main Menu 1 Product and promotion 2

30 15 2 1602D021A0A00043 2010-06-01 00:04:19.000 2010-06-01 00:05:02.000 9141620762 9141155155 1 Product and promotion Main Menu 2 Other Offer Details 2

31 15 3 1602D021A0A00043 2010-06-01 00:04:19.000 2010-06-01 00:05:02.000 9141620762 9141155155 2 Other Offer Details 1 Product and promotion 0 Agent Transfer 2

32 15 4 1602D021A0A00043 2010-06-01 00:04:19.000 2010-06-01 00:05:02.000 9141620762 9141155155 0 Agent Transfer 2 Other Offer Details 2

33 16 1 1602D021A0A30043 2010-06-01 00:05:11.000 2010-06-01 00:05:20.000 9141612496 9141155155 Main Menu 1

34 19 1 1602D021A0A90043 2010-06-01 00:05:55.000 2010-06-01 00:05:56.000 9141302927 9141155155 Main Menu 1

35 18 1 1602D021A0A70043 2010-06-01 00:05:53.000 2010-06-01 00:06:11.000 9141369806 9141155155 Main Menu 1 Product and promotion 1

36 18 2 1602D021A0A70043 2010-06-01 00:05:53.000 2010-06-01 00:06:11.000 9141369806 9141155155 1 Product and promotion Main Menu 1

37 11 2 1602D021A0980043 2010-06-01 00:03:49.000 2010-06-01 00:07:29.000 9141805815 9141155155 2 Handset or RUIM lost Main Menu 0

38 11 1 1602D021A0980043 2010-06-01 00:03:49.000 2010-06-01 00:07:29.000 9141805815 9141155155 Main Menu 2 Handset or RUIM lost 0

39 20 1 1602D021A0AB0043 2010-06-01 00:07:31.000 2010-06-01 00:07:41.000 9141656430 9141155155 Main Menu 1

40 13 3 1602D021A09C0043 2010-06-01 00:04:03.000 2010-06-01 00:08:16.000 9141668823 9141155155 0 Agent Transfer 3 Account 0

41 13 1 1602D021A09C0043 2010-06-01 00:04:03.000 2010-06-01 00:08:16.000 9141668823 9141155155 Main Menu 3 Account 0

42 13 2 1602D021A09C0043 2010-06-01 00:04:03.000 2010-06-01 00:08:16.000 9141668823 9141155155 3 Account Main Menu 0 Agent Transfer 0

43 17 4 1602D021A0A50043 2010-06-01 00:05:23.000 2010-06-01 00:10:53.000 9141357838 9141155155 2 Wrong Entry 9 Repeat Menu 0

44 17 1 1602D021A0A50043 2010-06-01 00:05:23.000 2010-06-01 00:10:53.000 9141357838 9141155155 Main Menu 3 Account 0

45 17 2 1602D021A0A50043 2010-06-01 00:05:23.000 2010-06-01 00:10:53.000 9141357838 9141155155 3 Account Main Menu 9 Repeat Menu 0

46 17 3 1602D021A0A50043 2010-06-01 00:05:23.000 2010-06-01 00:10:53.000 9141357838 9141155155 9 Repeat Menu 3 Account 2 Wrong Entry 0

47 22 1 1602D021A0B50043 2010-06-01 00:10:41.000 2010-06-01 00:11:01.000 9141811407 9141155155 Main Menu 1

48 23 1 1602D021A0C00043 2010-06-01 00:13:02.000 2010-06-01 00:13:20.000 9141564220 9141155155 Main Menu 1

49 3 1 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 Main Menu 1 Product and promotion 0

50 3 7 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 3 Wrong Entry 3 Wrong Entry 7 Previous Menu 0

51 3 11 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 3 Wrong Entry 4 Wrong Entry 7 Previous Menu 0

52 3 12 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 7 Previous Menu 3 Wrong Entry 2 Wrong Entry 0

53 3 14 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 1 Wrong Entry 2 Wrong Entry 0 Agent Transfer 0

54 3 2 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 0

55 3 5 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 1 Wrong Entry 9 Repeat Menu 3 Wrong Entry 0

56 3 8 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 7 Previous Menu 3 Wrong Entry 3 Wrong Entry 0

57 3 9 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 3 Wrong Entry 7 Previous Menu 4 Wrong Entry 0

58 3 13 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 2 Wrong Entry 7 Previous Menu 1 Wrong Entry 0

59 3 15 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 0 Agent Transfer 1 Wrong Entry 0

60 3 3 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 1 Repeat Offer Detail 1 Product and promotion 9 Repeat Menu 0

61 3 4 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 9 Repeat Menu 1 Repeat Offer Detail 1 Wrong Entry 0

62 3 6 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 3 Wrong Entry 1 Wrong Entry 3 Wrong Entry 0

63 3 10 1602D021A0850043 2010-06-01 00:01:04.000 2010-06-01 00:13:59.000 9603256153 9133155155 4 Wrong Entry 3 Wrong Entry 3 Wrong Entry 0

64 24 1 1602D021A0C20043 2010-06-01 00:14:02.000 2010-06-01 00:14:32.000 9141334278 9141155155 Main Menu 1

65 25 2 1602D021A0C90043 2010-06-01 00:16:33.000 2010-06-01 00:16:49.000 9141468393 9141155155 3 Account Main Menu 1

66 25 1 1602D021A0C90043 2010-06-01 00:16:33.000 2010-06-01 00:16:49.000 9141468393 9141155155 Main Menu 3 Account 1

67 26 1 1602D021A0CD0043 2010-06-01 00:16:51.000 2010-06-01 00:19:32.000 9141468393 9141155155 Main Menu 0 Agent Transfer 0

68 26 2 1602D021A0CD0043 2010-06-01 00:16:51.000 2010-06-01 00:19:32.000 9141468393 9141155155 0 Agent Transfer Main Menu 0

69 28 2 1602D021A0D20043 2010-06-01 00:19:26.000 2010-06-01 00:20:34.000 9141555345 9141155155 0 Agent Transfer Main Menu 2

70 28 1 1602D021A0D20043 2010-06-01 00:19:26.000 2010-06-01 00:20:34.000 9141555345 9141155155 Main Menu 0 Agent Transfer 2

71 21 2 1602D021A0B00043 2010-06-01 00:08:45.000 2010-06-01 00:20:47.000 9141668823 9141155155 3 Account Main Menu 0 Agent Transfer 0

72 21 3 1602D021A0B00043 2010-06-01 00:08:45.000 2010-06-01 00:20:47.000 9141668823 9141155155 0 Agent Transfer 3 Account 0

73 21 1 1602D021A0B00043 2010-06-01 00:08:45.000 2010-06-01 00:20:47.000 9141668823 9141155155 Main Menu 3 Account 0

74 31 2 1602D021A0D90043 2010-06-01 00:21:05.000 2010-06-01 00:22:09.000 9141555345 9141155155 0 Agent Transfer Main Menu 2

75 31 1 1602D021A0D90043 2010-06-01 00:21:05.000 2010-06-01 00:22:09.000 9141555345 9141155155 Main Menu 0 Agent Transfer 2

76 30 2 1602D021A0D70043 2010-06-01 00:20:51.000 2010-06-01 00:23:20.000 9141687772 9141155155 3 Account Main Menu 0 Agent Transfer 2

77 30 3 1602D021A0D70043 2010-06-01 00:20:51.000 2010-06-01 00:23:20.000 9141687772 9141155155 0 Agent Transfer 3 Account 2

78 30 1 1602D021A0D70043 2010-06-01 00:20:51.000 2010-06-01 00:23:20.000 9141687772 9141155155 Main Menu 3 Account 2

79 33 1 1602D021A0DF0043 2010-06-01 00:22:32.000 2010-06-01 00:23:21.000 9133711828 9133155155 Main Menu 3 Account 1

80 33 2 1602D021A0DF0043 2010-06-01 00:22:32.000 2010-06-01 00:23:21.000 9133711828 9133155155 3 Account Main Menu 1

81 29 2 1602D021A0D40043 2010-06-01 00:20:12.000 2010-06-01 00:23:24.000 9141662900 9141155155 0 Agent Transfer Main Menu 0

82 29 1 1602D021A0D40043 2010-06-01 00:20:12.000 2010-06-01 00:23:24.000 9141662900 9141155155 Main Menu 0 Agent Transfer 0

83 27 2 1602D021A0CF0043 2010-06-01 00:17:44.000 2010-06-01 00:23:33.000 9141505793 9141155155 0 Agent Transfer Main Menu 0

84 27 1 1602D021A0CF0043 2010-06-01 00:17:44.000 2010-06-01 00:23:33.000 9141505793 9141155155 Main Menu 0 Agent Transfer 0

85 35 1 1602D021A0E30043 2010-06-01 00:23:24.000 2010-06-01 00:23:41.000 9141555345 9141155155 Main Menu 1

86 34 1 1602D021A0E10043 2010-06-01 00:22:33.000 2010-06-01 00:24:03.000 9133706216 9133155155 Main Menu 3 Account 0

87 34 3 1602D021A0E10043 2010-06-01 00:22:33.000 2010-06-01 00:24:03.000 9133706216 9133155155 2 How to Recharge & extend Validity 3 Account 0

88 34 2 1602D021A0E10043 2010-06-01 00:22:33.000 2010-06-01 00:24:03.000 9133706216 9133155155 3 Account Main Menu 2 How to Recharge & extend Validity 0

89 37 1 1602D021A0E90043 2010-06-01 00:24:43.000 2010-06-01 00:24:45.000 9141608157 9141155155 Main Menu 1

90 39 1 1602D021A0ED0043 2010-06-01 00:25:05.000 2010-06-01 00:25:37.000 9141608157 9141155155 Main Menu 1

91 40 1 1602D021A0EF0043 2010-06-01 00:25:17.000 2010-06-01 00:25:40.000 9141671816 9141155155 Main Menu 1

92 38 4 1602D021A0EB0043 2010-06-01 00:24:46.000 2010-06-01 00:25:45.000 9133706216 9133155155 3 Wrong Entry 4 Wrong Entry 2

93 38 1 1602D021A0EB0043 2010-06-01 00:24:46.000 2010-06-01 00:25:45.000 9133706216 9133155155 Main Menu 3 Account 2

94 38 3 1602D021A0EB0043 2010-06-01 00:24:46.000 2010-06-01 00:25:45.000 9133706216 9133155155 4 Wrong Entry 3 Account 3 Wrong Entry 2

95 38 2 1602D021A0EB0043 2010-06-01 00:24:46.000 2010-06-01 00:25:45.000 9133706216 9133155155 3 Account Main Menu 4 Wrong Entry 2

96 36 1 1602D021A0E70043 2010-06-01 00:24:35.000 2010-06-01 00:27:22.000 9141662900 9141155155 Main Menu 0 Agent Transfer 0

97 36 2 1602D021A0E70043 2010-06-01 00:24:35.000 2010-06-01 00:27:22.000 9141662900 9141155155 0 Agent Transfer Main Menu 0

98 32 1 1602D021A0DB0043 2010-06-01 00:21:28.000 2010-06-01 00:28:25.000 9141489894 9141155155 Main Menu 0 Agent Transfer 0

99 32 2 1602D021A0DB0043 2010-06-01 00:21:28.000 2010-06-01 00:28:25.000 9141489894 9141155155 0 Agent Transfer Main Menu 0

100 43 1 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 Main Menu 9 Repeat Menu 1

101 43 4 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 1 Language Option 4 TPIN & Language change 7 Previous Menu 1

102 43 5 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 7 Previous Menu 1 Language Option 1 Wrong Entry 1

103 43 6 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 1 Wrong Entry 7 Previous Menu 9 Repeat Menu 1

104 43 7 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 9 Repeat Menu 1 Wrong Entry 1

105 43 2 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 9 Repeat Menu Main Menu 4 TPIN & Language change 1

106 43 3 1602D021A0F70043 2010-06-01 00:27:15.000 2010-06-01 00:28:56.000 9141738501 9141155155 4 TPIN & Language change 9 Repeat Menu 1 Language Option 1

107 46 1 1602D021A1000043 2010-06-01 00:29:09.000 2010-06-01 00:29:17.000 9141608157 9141155155 Main Menu 1

108 44 2 1602D021A0FC0043 2010-06-01 00:29:05.000 2010-06-01 00:29:21.000 9150000336 9141155155 2 Handset or RUIM lost Main Menu 1

109 44 1 1602D021A0FC0043 2010-06-01 00:29:05.000 2010-06-01 00:29:21.000 9150000336 9141155155 Main Menu 2 Handset or RUIM lost 1

110 41 3 1602D021A0F10043 2010-06-01 00:26:04.000 2010-06-01 00:29:46.000 9133706216 9133155155 0 Agent Transfer 3 Account 0

111 41 1 1602D021A0F10043 2010-06-01 00:26:04.000 2010-06-01 00:29:46.000 9133706216 9133155155 Main Menu 3 Account 0

112 41 2 1602D021A0F10043 2010-06-01 00:26:04.000 2010-06-01 00:29:46.000 9133706216 9133155155 3 Account Main Menu 0 Agent Transfer 0

113 42 1 1602D021A0F30043 2010-06-01 00:26:18.000 2010-06-01 00:31:19.000 9141796173 9141155155 Main Menu 0 Agent Transfer 0

114 42 2 1602D021A0F30043 2010-06-01 00:26:18.000 2010-06-01 00:31:19.000 9141796173 9141155155 0 Agent Transfer Main Menu 0

115 49 1 1602D021A1080043 2010-06-01 00:32:29.000 2010-06-01 00:32:35.000 9141424799 9141155155 Main Menu 1

116 47 2 1602D021A1040043 2010-06-01 00:31:51.000 2010-06-01 00:32:58.000 9141555345 9141155155 0 Agent Transfer Main Menu 2

117 47 1 1602D021A1040043 2010-06-01 00:31:51.000 2010-06-01 00:32:58.000 9141555345 9141155155 Main Menu 0 Agent Transfer 2

118 50 1 1602D021A10B0043 2010-06-01 00:33:25.000 2010-06-01 00:33:33.000 9141424799 9141155155 Main Menu 1

119 51 1 1602D021A10D0043 2010-06-01 00:33:30.000 2010-06-01 00:33:54.000 9141796173 9141155155 Main Menu 1

120 45 2 1602D021A0FE0043 2010-06-01 00:29:06.000 2010-06-01 00:36:26.000 9141738501 9141155155 2 Handset or RUIM lost Main Menu 1 Wrong Entry 0

121 45 1 1602D021A0FE0043 2010-06-01 00:29:06.000 2010-06-01 00:36:26.000 9141738501 9141155155 Main Menu 2 Handset or RUIM lost 0

122 45 3 1602D021A0FE0043 2010-06-01 00:29:06.000 2010-06-01 00:36:26.000 9141738501 9141155155 1 Wrong Entry 2 Handset or RUIM lost 0

123 53 2 1602D021A1110043 2010-06-01 00:34:14.000 2010-06-01 00:36:34.000 9141796173 9141155155 0 Agent Transfer Main Menu 0

124 53 1 1602D021A1110043 2010-06-01 00:34:14.000 2010-06-01 00:36:34.000 9141796173 9141155155 Main Menu 0 Agent Transfer 0

125 55 1 1602D021A1160043 2010-06-01 00:37:45.000 2010-06-01 00:37:47.000 9133716609 9133155155 Main Menu 1

126 54 2 1602D021A1140043 2010-06-01 00:36:55.000 2010-06-01 00:38:13.000 9133700592 9133155155 3 Account Main Menu 0 Agent Transfer 1

127 54 3 1602D021A1140043 2010-06-01 00:36:55.000 2010-06-01 00:38:13.000 9133700592 9133155155 0 Agent Transfer 3 Account 1

128 54 1 1602D021A1140043 2010-06-01 00:36:55.000 2010-06-01 00:38:13.000 9133700592 9133155155 Main Menu 3 Account 1

129 52 1 1602D021A10F0043 2010-06-01 00:34:03.000 2010-06-01 00:39:54.000 9141424799 9141155155 Main Menu 0 Agent Transfer 0

130 52 2 1602D021A10F0043 2010-06-01 00:34:03.000 2010-06-01 00:39:54.000 9141424799 9141155155 0 Agent Transfer Main Menu 0

131 48 2 1602D021A1060043 2010-06-01 00:32:13.000 2010-06-01 00:41:04.000 9141489894 9141155155 0 Agent Transfer Main Menu 0

132 48 1 1602D021A1060043 2010-06-01 00:32:13.000 2010-06-01 00:41:04.000 9141489894 9141155155 Main Menu 0 Agent Transfer 0

133 56 1 1602D021A1190043 2010-06-01 00:41:22.000 2010-06-01 00:43:21.000 9141751828 9141155155 Main Menu 0 Agent Transfer 0

134 56 2 1602D021A1190043 2010-06-01 00:41:22.000 2010-06-01 00:43:21.000 9141751828 9141155155 0 Agent Transfer Main Menu 0

135 61 1 1602D021A1260043 2010-06-01 00:45:59.000 2010-06-01 00:46:36.000 9141321374 9141155155 Main Menu 1

136 60 1 1602D021A1240043 2010-06-01 00:45:39.000 2010-06-01 00:46:41.000 9141555345 9141155155 Main Menu 0 Agent Transfer 2

137 60 2 1602D021A1240043 2010-06-01 00:45:39.000 2010-06-01 00:46:41.000 9141555345 9141155155 0 Agent Transfer Main Menu 2

138 62 1 1602D021A1280043 2010-06-01 00:47:45.000 2010-06-01 00:47:47.000 9133708465 9133198198 Main Menu 1

139 59 1 1602D021A1220043 2010-06-01 00:45:30.000 2010-06-01 00:50:12.000 9141489894 9141155155 Main Menu 0 Agent Transfer 0

140 59 2 1602D021A1220043 2010-06-01 00:45:30.000 2010-06-01 00:50:12.000 9141489894 9141155155 0 Agent Transfer Main Menu 0

141 57 2 1602D021A11C0043 2010-06-01 00:42:57.000 2010-06-01 00:50:29.000 9141706038 9141155155 0 Agent Transfer Main Menu 0

142 57 1 1602D021A11C0043 2010-06-01 00:42:57.000 2010-06-01 00:50:29.000 9141706038 9141155155 Main Menu 0 Agent Transfer 0

143 58 2 1602D021A11E0043 2010-06-01 00:43:09.000 2010-06-01 00:50:29.000 9141412943 9141155155 0 Agent Transfer Main Menu 0

144 58 1 1602D021A11E0043 2010-06-01 00:43:09.000 2010-06-01 00:50:29.000 9141412943 9141155155 Main Menu 0 Agent Transfer 0

145 63 1 1602D021A12A0043 2010-06-01 00:51:26.000 2010-06-01 00:51:33.000 9133708465 9133198198 Main Menu 1

146 64 2 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 4 TPIN & Language change Main Menu 2 Wrong Entry 1

147 64 4 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 8 Main Menu 2 Wrong Entry 4 TPIN & Language change 1

148 64 6 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 2 Wrong Entry 4 TPIN & Language change 1

149 64 5 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 4 TPIN & Language change 8 Main Menu 2 Wrong Entry 1

150 64 1 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 Main Menu 4 TPIN & Language change 1

151 64 3 1602D021A12C0043 2010-06-01 00:58:32.000 2010-06-01 01:00:18.000 9141341216 9141155155 2 Wrong Entry 4 TPIN & Language change 8 Main Menu 1

152 65 1 1602D021A12E0043 2010-06-01 01:01:47.000 2010-06-01 01:02:18.000 9141341216 9141155155 Main Menu 1

153 66 1 1602D021A1300043 2010-06-01 01:02:25.000 2010-06-01 01:03:16.000 9141341216 9141155155 Main Menu 3 Account 1

154 66 5 1602D021A1300043 2010-06-01 01:02:25.000 2010-06-01 01:03:16.000 9141341216 9141155155 6 Wrong Entry 1 Tariff info 1

155 66 2 1602D021A1300043 2010-06-01 01:02:25.000 2010-06-01 01:03:16.000 9141341216 9141155155 3 Account Main Menu 1 Know your tariff 1

156 66 4 1602D021A1300043 2010-06-01 01:02:25.000 2010-06-01 01:03:16.000 9141341216 9141155155 1 Tariff info 1 Know your tariff 6 Wrong Entry 1

157 66 3 1602D021A1300043 2010-06-01 01:02:25.000 2010-06-01 01:03:16.000 9141341216 9141155155 1 Know your tariff 3 Account 1 Tariff info 1

158 67 1 1602D021A1340043 2010-06-01 01:03:46.000 2010-06-01 01:03:50.000 9141341216 9141155155 Main Menu 1

159 68 2 1602D021A1360043 2010-06-01 01:09:20.000 2010-06-01 01:10:43.000 9141796173 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 1

160 68 3 1602D021A1360043 2010-06-01 01:09:20.000 2010-06-01 01:10:43.000 9141796173 9141155155 1 Repeat Offer Detail 1 Product and promotion 1

161 68 1 1602D021A1360043 2010-06-01 01:09:20.000 2010-06-01 01:10:43.000 9141796173 9141155155 Main Menu 1 Product and promotion 1

162 71 1 1602D021A13C0043 2010-06-01 01:11:14.000 2010-06-01 01:13:41.000 9141662270 9141155155 Main Menu 1 Product and promotion 0

163 71 3 1602D021A13C0043 2010-06-01 01:11:14.000 2010-06-01 01:13:41.000 9141662270 9141155155 0 Agent Transfer 1 Product and promotion 0

164 71 2 1602D021A13C0043 2010-06-01 01:11:14.000 2010-06-01 01:13:41.000 9141662270 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

165 70 1 1602D021A13A0043 2010-06-01 01:10:16.000 2010-06-01 01:14:00.000 9133711156 9133155155 Main Menu 3 Account 0

166 70 2 1602D021A13A0043 2010-06-01 01:10:16.000 2010-06-01 01:14:00.000 9133711156 9133155155 3 Account Main Menu 0 Agent Transfer 0

167 70 3 1602D021A13A0043 2010-06-01 01:10:16.000 2010-06-01 01:14:00.000 9133711156 9133155155 0 Agent Transfer 3 Account 0

168 72 3 1602D021A1400043 2010-06-01 01:14:05.000 2010-06-01 01:17:57.000 9141662270 9141155155 1 Repeat Offer Detail 1 Product and promotion 0 Agent Transfer 0

169 72 1 1602D021A1400043 2010-06-01 01:14:05.000 2010-06-01 01:17:57.000 9141662270 9141155155 Main Menu 1 Product and promotion 0

170 72 4 1602D021A1400043 2010-06-01 01:14:05.000 2010-06-01 01:17:57.000 9141662270 9141155155 0 Agent Transfer 1 Repeat Offer Detail 0

171 72 2 1602D021A1400043 2010-06-01 01:14:05.000 2010-06-01 01:17:57.000 9141662270 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 0

172 69 4 1602D021A1380043 2010-06-01 01:10:08.000 2010-06-01 01:19:09.000 9141687268 9141155155 0 Agent Transfer 9 Repeat Menu 0

173 69 1 1602D021A1380043 2010-06-01 01:10:08.000 2010-06-01 01:19:09.000 9141687268 9141155155 Main Menu 1 Product and promotion 0

174 69 3 1602D021A1380043 2010-06-01 01:10:08.000 2010-06-01 01:19:09.000 9141687268 9141155155 9 Repeat Menu 1 Product and promotion 0 Agent Transfer 0

175 69 2 1602D021A1380043 2010-06-01 01:10:08.000 2010-06-01 01:19:09.000 9141687268 9141155155 1 Product and promotion Main Menu 9 Repeat Menu 0

176 73 2 1602D021A1430043 2010-06-01 01:18:03.000 2010-06-01 01:26:41.000 9133701425 9133155155 3 Account Main Menu 3 know the services activated in your account 0

177 73 3 1602D021A1430043 2010-06-01 01:18:03.000 2010-06-01 01:26:41.000 9133701425 9133155155 3 know the services activated in your account 3 Account 0 Agent Transfer 0

178 73 1 1602D021A1430043 2010-06-01 01:18:03.000 2010-06-01 01:26:41.000 9133701425 9133155155 Main Menu 3 Account 0

179 73 4 1602D021A1430043 2010-06-01 01:18:03.000 2010-06-01 01:26:41.000 9133701425 9133155155 0 Agent Transfer 3 know the services activated in your account 0

180 74 1 1602D021A1470043 2010-06-01 01:25:36.000 2010-06-01 01:28:22.000 9133702821 9133155155 Main Menu 3 Account 0

181 74 2 1602D021A1470043 2010-06-01 01:25:36.000 2010-06-01 01:28:22.000 9133702821 9133155155 3 Account Main Menu 0 Agent Transfer 0

182 74 3 1602D021A1470043 2010-06-01 01:25:36.000 2010-06-01 01:28:22.000 9133702821 9133155155 0 Agent Transfer 3 Account 0

183 75 2 1602D021A14A0043 2010-06-01 01:35:29.000 2010-06-01 01:35:52.000 9141335475 9141155155 2 Handset or RUIM lost Main Menu 1

184 75 1 1602D021A14A0043 2010-06-01 01:35:29.000 2010-06-01 01:35:52.000 9141335475 9141155155 Main Menu 2 Handset or RUIM lost 1

185 76 1 1602D021A14C0043 2010-06-01 01:40:21.000 2010-06-01 01:40:39.000 9141919151 9141144144 Main Menu 1

186 77 1 1602D021A14E0043 2010-06-01 01:41:45.000 2010-06-01 01:41:47.000 9141662270 9141155155 Main Menu 1

187 78 1 1602D021A1560043 2010-06-01 01:46:54.000 2010-06-01 01:47:22.000 9141670468 9141155155 Main Menu 1 Product and promotion 1

188 78 2 1602D021A1560043 2010-06-01 01:46:54.000 2010-06-01 01:47:22.000 9141670468 9141155155 1 Product and promotion Main Menu 1

189 79 3 1603D09B22B3002A 2010-06-01 02:00:25.000 2010-06-01 02:03:01.000 9133711156 9133155155 9 Repeat Menu 3 Account 3 Wrong Entry 1

190 79 4 1603D09B22B3002A 2010-06-01 02:00:25.000 2010-06-01 02:03:01.000 9133711156 9133155155 3 Wrong Entry 9 Repeat Menu 3 Wrong Entry 1

191 79 2 1603D09B22B3002A 2010-06-01 02:00:25.000 2010-06-01 02:03:01.000 9133711156 9133155155 3 Account Main Menu 9 Repeat Menu 1

192 79 5 1603D09B22B3002A 2010-06-01 02:00:25.000 2010-06-01 02:03:01.000 9133711156 9133155155 3 Wrong Entry 3 Wrong Entry 1

193 79 1 1603D09B22B3002A 2010-06-01 02:00:25.000 2010-06-01 02:03:01.000 9133711156 9133155155 Main Menu 3 Account 1

194 81 1 1603D09B22BA002A 2010-06-01 02:20:52.000 2010-06-01 02:21:12.000 9141684216 9141155155 Main Menu 1

195 80 2 1603D09B22B7002A 2010-06-01 02:19:12.000 2010-06-01 02:24:26.000 9141813460 9141155155 9 Repeat Menu Main Menu 2 Handset or RUIM lost 0

196 80 1 1603D09B22B7002A 2010-06-01 02:19:12.000 2010-06-01 02:24:26.000 9141813460 9141155155 Main Menu 9 Repeat Menu 0

197 80 3 1603D09B22B7002A 2010-06-01 02:19:12.000 2010-06-01 02:24:26.000 9141813460 9141155155 2 Handset or RUIM lost 9 Repeat Menu 0

198 82 1 160421A400DE0043 2010-06-01 02:29:46.000 2010-06-01 02:29:58.000 9141322524 9141155155 Main Menu 1

199 83 1 160421A400E00043 2010-06-01 02:31:01.000 2010-06-01 02:31:07.000 9141393646 9141155155 Main Menu 1

200 84 1 160421A400E20043 2010-06-01 02:39:10.000 2010-06-01 02:40:25.000 9141362741 9141155155 Main Menu 3 Account 1

201 84 3 160421A400E20043 2010-06-01 02:39:10.000 2010-06-01 02:40:25.000 9141362741 9141155155 1 Know your tariff 3 Account 2 Roaming Tariff 1

202 84 2 160421A400E20043 2010-06-01 02:39:10.000 2010-06-01 02:40:25.000 9141362741 9141155155 3 Account Main Menu 1 Know your tariff 1

203 84 4 160421A400E20043 2010-06-01 02:39:10.000 2010-06-01 02:40:25.000 9141362741 9141155155 2 Roaming Tariff 1 Know your tariff 1

204 85 2 160421A400E40043 2010-06-01 02:40:56.000 2010-06-01 02:43:17.000 9141383740 9141155155 7 Wrong Entry Main Menu 0 Agent Transfer 0

205 85 1 160421A400E40043 2010-06-01 02:40:56.000 2010-06-01 02:43:17.000 9141383740 9141155155 Main Menu 7 Wrong Entry 0

206 85 3 160421A400E40043 2010-06-01 02:40:56.000 2010-06-01 02:43:17.000 9141383740 9141155155 0 Agent Transfer 7 Wrong Entry 0

207 86 1 160421A400F60043 2010-06-01 03:20:35.000 2010-06-01 03:20:56.000 9133701830 9133155155 Main Menu 1

208 87 1 160421A400F80043 2010-06-01 03:20:41.000 2010-06-01 03:20:58.000 9141550244 9141155155 Main Menu 1

209 88 2 160421A400FA0043 2010-06-01 03:21:42.000 2010-06-01 03:21:53.000 9141550244 9141155155 1 Product and promotion Main Menu 1

210 88 1 160421A400FA0043 2010-06-01 03:21:42.000 2010-06-01 03:21:53.000 9141550244 9141155155 Main Menu 1 Product and promotion 1

211 89 1 160421A400FC0043 2010-06-01 03:21:45.000 2010-06-01 03:22:02.000 9133701830 9133155155 Main Menu 1

212 90 1 160421A400FE0043 2010-06-01 03:23:50.000 2010-06-01 03:24:03.000 9141550244 9141144144 Main Menu 1

213 92 1 160421A401020043 2010-06-01 03:30:29.000 2010-06-01 03:30:44.000 9141812212 9141155155 Main Menu 1

214 91 1 160421A401000043 2010-06-01 03:30:18.000 2010-06-01 03:31:06.000 9133718806 9133155155 Main Menu 1

215 93 1 160421A401040043 2010-06-01 03:31:16.000 2010-06-01 03:31:37.000 9133718806 9133198198 Main Menu 1

216 94 1 160421A401060043 2010-06-01 03:34:34.000 2010-06-01 03:34:43.000 9133713283 9133155155 Main Menu 1

217 95 1 160421A401080043 2010-06-01 03:35:11.000 2010-06-01 03:35:14.000 9141340214 9141155155 Main Menu 1

218 96 1 160421A4010D0043 2010-06-01 03:43:11.000 2010-06-01 03:43:23.000 9133701830 9133155155 Main Menu 1

219 97 2 160421A4010F0043 2010-06-01 03:43:38.000 2010-06-01 03:45:26.000 9133701830 9133155155 3 Account Main Menu 1 Know your tariff 1

220 97 5 160421A4010F0043 2010-06-01 03:43:38.000 2010-06-01 03:45:26.000 9133701830 9133155155 1 Wrong Entry 9 Repeat Menu 1

221 97 3 160421A4010F0043 2010-06-01 03:43:38.000 2010-06-01 03:45:26.000 9133701830 9133155155 1 Know your tariff 3 Account 9 Repeat Menu 1

222 97 4 160421A4010F0043 2010-06-01 03:43:38.000 2010-06-01 03:45:26.000 9133701830 9133155155 9 Repeat Menu 1 Know your tariff 1 Wrong Entry 1

223 97 1 160421A4010F0043 2010-06-01 03:43:38.000 2010-06-01 03:45:26.000 9133701830 9133155155 Main Menu 3 Account 1

224 98 1 160421A401190043 2010-06-01 04:12:03.000 2010-06-01 04:13:12.000 9141320484 9141144144 Main Menu 2

225 99 1 160421A4011B0043 2010-06-01 04:16:38.000 2010-06-01 04:17:39.000 9141756758 9141155155 Main Menu 1 Product and promotion 1

226 99 2 160421A4011B0043 2010-06-01 04:16:38.000 2010-06-01 04:17:39.000 9141756758 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 1

227 99 3 160421A4011B0043 2010-06-01 04:16:38.000 2010-06-01 04:17:39.000 9141756758 9141155155 1 Repeat Offer Detail 1 Product and promotion 1

228 100 2 160421A401200043 2010-06-01 04:48:10.000 2010-06-01 04:48:31.000 9141728297 9141155155 0 Agent Transfer Main Menu 1

229 100 1 160421A401200043 2010-06-01 04:48:10.000 2010-06-01 04:48:31.000 9141728297 9141155155 Main Menu 0 Agent Transfer 1

230 101 2 160421A401220043 2010-06-01 04:48:39.000 2010-06-01 04:50:55.000 9141728297 9141155155 0 Agent Transfer Main Menu 0

231 101 1 160421A401220043 2010-06-01 04:48:39.000 2010-06-01 04:50:55.000 9141728297 9141155155 Main Menu 0 Agent Transfer 0

232 102 1 160421A401250043 2010-06-01 04:52:27.000 2010-06-01 04:52:56.000 9141701119 9141155155 Main Menu 1

233 103 1 160421A401270043 2010-06-01 04:52:57.000 2010-06-01 04:53:00.000 9141750280 9141155155 Main Menu 1

234 104 1 160421A401290043 2010-06-01 04:54:50.000 2010-06-01 04:57:02.000 9141770611 9141155155 Main Menu 1 Product and promotion 0

235 104 3 160421A401290043 2010-06-01 04:54:50.000 2010-06-01 04:57:02.000 9141770611 9141155155 0 Agent Transfer 1 Product and promotion 0

236 104 2 160421A401290043 2010-06-01 04:54:50.000 2010-06-01 04:57:02.000 9141770611 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

237 105 1 160421A4012C0043 2010-06-01 04:59:28.000 2010-06-01 05:00:06.000 9141499008 9141155155 Main Menu 1

238 106 5 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 7 Previous Menu 1 Language Option 1 Wrong Entry 1

239 106 9 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 1 Repeat Offer Detail 1 Product and promotion 1

240 106 1 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 Main Menu 9 Repeat Menu 1

241 106 2 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 9 Repeat Menu Main Menu 4 TPIN & Language change 1

242 106 3 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 4 TPIN & Language change 9 Repeat Menu 1 Language Option 1

243 106 8 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 1 Product and promotion 8 Main Menu 1 Repeat Offer Detail 1

244 106 4 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 1 Language Option 4 TPIN & Language change 7 Previous Menu 1

245 106 6 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 1 Wrong Entry 7 Previous Menu 8 Main Menu 1

246 106 7 160421A4012E0043 2010-06-01 04:59:54.000 2010-06-01 05:01:54.000 9141770611 9141155155 8 Main Menu 1 Wrong Entry 1 Product and promotion 1

247 109 1 160421A401340043 2010-06-01 05:02:37.000 2010-06-01 05:02:46.000 9141694694 9141155155 Main Menu 1

248 107 1 160421A401300043 2010-06-01 05:00:46.000 2010-06-01 05:03:03.000 9141499008 9141155155 Main Menu 2

249 110 1 160421A401370043 2010-06-01 05:04:12.000 2010-06-01 05:04:25.000 9141661073 9141155155 Main Menu 1

250 108 1 160421A401320043 2010-06-01 05:02:11.000 2010-06-01 05:04:54.000 9141770611 9141155155 Main Menu 0 Agent Transfer 0

251 108 2 160421A401320043 2010-06-01 05:02:11.000 2010-06-01 05:04:54.000 9141770611 9141155155 0 Agent Transfer Main Menu 0

252 111 1 160421A401390043 2010-06-01 05:06:07.000 2010-06-01 05:07:56.000 9141770611 9141155155 Main Menu 0 Agent Transfer 0

253 111 2 160421A401390043 2010-06-01 05:06:07.000 2010-06-01 05:07:56.000 9141770611 9141155155 0 Agent Transfer Main Menu 0

254 112 1 160421A4013C0043 2010-06-01 05:09:52.000 2010-06-01 05:10:48.000 9141492881 9141155155 Main Menu 1 Product and promotion 1

255 112 2 160421A4013C0043 2010-06-01 05:09:52.000 2010-06-01 05:10:48.000 9141492881 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 1

256 112 3 160421A4013C0043 2010-06-01 05:09:52.000 2010-06-01 05:10:48.000 9141492881 9141155155 0 Agent Transfer 1 Product and promotion 1

257 113 1 160421A4013E0043 2010-06-01 05:11:21.000 2010-06-01 05:15:50.000 9141715484 9141155155 Main Menu 1 Product and promotion 0

258 113 2 160421A4013E0043 2010-06-01 05:11:21.000 2010-06-01 05:15:50.000 9141715484 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 0

259 113 3 160421A4013E0043 2010-06-01 05:11:21.000 2010-06-01 05:15:50.000 9141715484 9141155155 1 Repeat Offer Detail 1 Product and promotion 0 Agent Transfer 0

260 113 4 160421A4013E0043 2010-06-01 05:11:21.000 2010-06-01 05:15:50.000 9141715484 9141155155 0 Agent Transfer 1 Repeat Offer Detail 0

261 115 1 160421A401460043 2010-06-01 05:19:49.000 2010-06-01 05:19:52.000 9133708465 9133198198 Main Menu 1

262 116 1 160421A401490043 2010-06-01 05:21:17.000 2010-06-01 05:21:18.000 9133708465 9133198198 Main Menu 1

263 114 1 160421A401440043 2010-06-01 05:18:22.000 2010-06-01 05:23:01.000 9141319320 9141155155 Main Menu 1 Product and promotion 0

264 114 2 160421A401440043 2010-06-01 05:18:22.000 2010-06-01 05:23:01.000 9141319320 9141155155 1 Product and promotion Main Menu 9 Repeat Menu 0

265 114 3 160421A401440043 2010-06-01 05:18:22.000 2010-06-01 05:23:01.000 9141319320 9141155155 9 Repeat Menu 1 Product and promotion 0 Agent Transfer 0

266 114 4 160421A401440043 2010-06-01 05:18:22.000 2010-06-01 05:23:01.000 9141319320 9141155155 0 Agent Transfer 9 Repeat Menu 0

267 117 2 160421A4014B0043 2010-06-01 05:25:28.000 2010-06-01 05:28:07.000 9141564076 9141155155 2 Handset or RUIM lost Main Menu 1 Wrong Entry 1

268 117 3 160421A4014B0043 2010-06-01 05:25:28.000 2010-06-01 05:28:07.000 9141564076 9141155155 1 Wrong Entry 2 Handset or RUIM lost 1 Wrong Entry 1

269 117 1 160421A4014B0043 2010-06-01 05:25:28.000 2010-06-01 05:28:07.000 9141564076 9141155155 Main Menu 2 Handset or RUIM lost 1

270 117 4 160421A4014B0043 2010-06-01 05:25:28.000 2010-06-01 05:28:07.000 9141564076 9141155155 1 Wrong Entry 1 Wrong Entry 1

271 118 2 160421A4014D0043 2010-06-01 05:28:23.000 2010-06-01 05:29:11.000 9141601190 9141155155 # Wrong Entry Main Menu 1

272 118 1 160421A4014D0043 2010-06-01 05:28:23.000 2010-06-01 05:29:11.000 9141601190 9141155155 Main Menu # Wrong Entry 1

273 119 2 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 1 Product and promotion Main Menu 2 Other Offer Details 2

274 119 3 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 2 Other Offer Details 1 Product and promotion 5 Wrong Entry 2

275 119 4 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 5 Wrong Entry 2 Other Offer Details 5 Wrong Entry 2

276 119 5 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 5 Wrong Entry 5 Wrong Entry 5 Wrong Entry 2

277 119 8 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 7 Previous Menu 7 Previous Menu 2

278 119 1 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 Main Menu 1 Product and promotion 2

279 119 6 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 5 Wrong Entry 5 Wrong Entry 7 Previous Menu 2

280 119 7 160421A4014F0043 2010-06-01 05:30:38.000 2010-06-01 05:32:33.000 9141315812 9141155155 7 Previous Menu 5 Wrong Entry 7 Previous Menu 2

281 121 1 160421A401530043 2010-06-01 05:35:07.000 2010-06-01 05:35:49.000 9141411325 9141155155 Main Menu 1

282 120 3 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 2 How to Recharge & extend Validity 3 Account 2 Paper Coupon 2

283 120 5 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 1 Wrong Entry 2 Paper Coupon 1 Wrong Entry 2

284 120 7 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 7 Previous Menu 1 Wrong Entry 2

285 120 1 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 Main Menu 3 Account 2

286 120 2 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 3 Account Main Menu 2 How to Recharge & extend Validity 2

287 120 4 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 2 Paper Coupon 2 How to Recharge & extend Validity 1 Wrong Entry 2

288 120 6 160421A401510043 2010-06-01 05:33:25.000 2010-06-01 05:36:02.000 9141691097 9141155155 1 Wrong Entry 1 Wrong Entry 7 Previous Menu 2

289 123 2 160421A401570043 2010-06-01 05:35:57.000 2010-06-01 05:37:25.000 9141411325 9141155155 3 Account Main Menu 2 How to Recharge & extend Validity 1

290 123 3 160421A401570043 2010-06-01 05:35:57.000 2010-06-01 05:37:25.000 9141411325 9141155155 2 How to Recharge & extend Validity 3 Account 2 Paper Coupon 1

291 123 4 160421A401570043 2010-06-01 05:35:57.000 2010-06-01 05:37:25.000 9141411325 9141155155 2 Paper Coupon 2 How to Recharge & extend Validity 1

292 123 1 160421A401570043 2010-06-01 05:35:57.000 2010-06-01 05:37:25.000 9141411325 9141155155 Main Menu 3 Account 1

293 122 1 160421A401550043 2010-06-01 05:35:39.000 2010-06-01 05:37:35.000 9141312442 9141155155 Main Menu 1 Product and promotion 0

294 122 2 160421A401550043 2010-06-01 05:35:39.000 2010-06-01 05:37:35.000 9141312442 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

295 122 3 160421A401550043 2010-06-01 05:35:39.000 2010-06-01 05:37:35.000 9141312442 9141155155 0 Agent Transfer 1 Product and promotion 0

296 124 1 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 Main Menu 3 Account 2

297 124 2 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 3 Account Main Menu 2 How to Recharge & extend Validity 2

298 124 5 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 1 Wrong Entry 2 Paper Coupon 1 Wrong Entry 2

299 124 6 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 1 Wrong Entry 1 Wrong Entry 7 Previous Menu 2

300 124 7 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 7 Previous Menu 1 Wrong Entry 2 Wrong Entry 2

301 124 10 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 1 Wrong Entry 1 Wrong Entry 1 Wrong Entry 2

302 124 4 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 2 Paper Coupon 2 How to Recharge & extend Validity 1 Wrong Entry 2

303 124 8 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 2 Wrong Entry 7 Previous Menu 1 Wrong Entry 2

304 124 12 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 7 Previous Menu 1 Wrong Entry 2

305 124 3 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 2 How to Recharge & extend Validity 3 Account 2 Paper Coupon 2

306 124 9 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 1 Wrong Entry 2 Wrong Entry 1 Wrong Entry 2

307 124 11 160421A401590043 2010-06-01 05:36:31.000 2010-06-01 05:37:56.000 9141691097 9141155155 1 Wrong Entry 1 Wrong Entry 7 Previous Menu 2

308 126 1 160421A4015E0043 2010-06-01 05:38:51.000 2010-06-01 05:38:59.000 9141321739 9141155155 Main Menu 1

309 125 2 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 3 Account Main Menu 1 Know your tariff 1

310 125 3 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 1 Know your tariff 3 Account 1 Tariff info 1

311 125 5 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 2 Wrong Entry 1 Tariff info 7 Previous Menu 1

312 125 6 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 7 Previous Menu 2 Wrong Entry 1 Wrong Entry 1

313 125 13 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 5 Wrong Entry 9 Repeat Menu 5 Wrong Entry 1

314 125 9 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 8 Main Menu 7 Previous Menu 1 Product and promotion 1

315 125 1 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 Main Menu 3 Account 1

316 125 10 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 1 Product and promotion 8 Main Menu 2 Other Offer Details 1

317 125 11 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 2 Other Offer Details 1 Product and promotion 9 Repeat Menu 1

318 125 14 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 5 Wrong Entry 5 Wrong Entry 7 Previous Menu 1

319 125 4 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 1 Tariff info 1 Know your tariff 2 Wrong Entry 1

320 125 7 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 1

321 125 8 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 7 Previous Menu 1 Wrong Entry 8 Main Menu 1

322 125 12 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 9 Repeat Menu 2 Other Offer Details 5 Wrong Entry 1

323 125 15 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 7 Previous Menu 5 Wrong Entry 7 Previous Menu 1

324 125 16 160421A4015B0043 2010-06-01 05:36:32.000 2010-06-01 05:40:40.000 9141815508 9141155155 7 Previous Menu 7 Previous Menu 1

325 127 1 160421A401600043 2010-06-01 05:41:05.000 2010-06-01 05:41:07.000 9391966936 9133155155 Main Menu 1

326 128 1 160421A401620043 2010-06-01 05:41:35.000 2010-06-01 05:42:34.000 9141724745 9141155155 Main Menu 2 Handset or RUIM lost 1

327 128 2 160421A401620043 2010-06-01 05:41:35.000 2010-06-01 05:42:34.000 9141724745 9141155155 2 Handset or RUIM lost Main Menu 1

328 129 1 160421A401640043 2010-06-01 05:43:23.000 2010-06-01 05:43:35.000 9141724745 9141155155 Main Menu 1

329 130 1 160421A401660043 2010-06-01 05:49:51.000 2010-06-01 05:51:12.000 9141446315 9141155155 Main Menu 0 Agent Transfer 0

330 130 2 160421A401660043 2010-06-01 05:49:51.000 2010-06-01 05:51:12.000 9141446315 9141155155 0 Agent Transfer Main Menu 0

331 131 2 160421A401690043 2010-06-01 05:51:25.000 2010-06-01 05:52:01.000 9141446315 9141155155 0 Agent Transfer Main Menu 0

332 131 1 160421A401690043 2010-06-01 05:51:25.000 2010-06-01 05:52:01.000 9141446315 9141155155 Main Menu 0 Agent Transfer 0

333 132 2 160421A4016B0043 2010-06-01 05:51:45.000 2010-06-01 05:54:42.000 9141504831 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

334 132 1 160421A4016B0043 2010-06-01 05:51:45.000 2010-06-01 05:54:42.000 9141504831 9141155155 Main Menu 1 Product and promotion 0

335 132 3 160421A4016B0043 2010-06-01 05:51:45.000 2010-06-01 05:54:42.000 9141504831 9141155155 0 Agent Transfer 1 Product and promotion 0

336 134 2 160421A401720043 2010-06-01 05:55:29.000 2010-06-01 05:56:41.000 9141768547 9141155155 3 Account Main Menu 3 know the services activated in your account 1

337 134 1 160421A401720043 2010-06-01 05:55:29.000 2010-06-01 05:56:41.000 9141768547 9141155155 Main Menu 3 Account 1

338 134 3 160421A401720043 2010-06-01 05:55:29.000 2010-06-01 05:56:41.000 9141768547 9141155155 3 know the services activated in your account 3 Account 1

339 133 1 160421A4016E0043 2010-06-01 05:52:24.000 2010-06-01 05:57:36.000 9141446315 9141155155 Main Menu 0 Agent Transfer 0

340 133 2 160421A4016E0043 2010-06-01 05:52:24.000 2010-06-01 05:57:36.000 9141446315 9141155155 0 Agent Transfer Main Menu 0

341 136 1 160421A401770043 2010-06-01 05:58:15.000 2010-06-01 05:58:38.000 9133703901 9133155155 Main Menu 1

342 135 1 160421A401750043 2010-06-01 05:57:55.000 2010-06-01 05:59:18.000 9141599476 9141155155 Main Menu 1 Product and promotion 2

343 135 2 160421A401750043 2010-06-01 05:57:55.000 2010-06-01 05:59:18.000 9141599476 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 2

344 135 3 160421A401750043 2010-06-01 05:57:55.000 2010-06-01 05:59:18.000 9141599476 9141155155 0 Agent Transfer 1 Product and promotion 2

345 137 1 160421A401790043 2010-06-01 05:59:35.000 2010-06-01 06:00:30.000 9141367150 9141155155 Main Menu 3 Account 2

346 137 2 160421A401790043 2010-06-01 05:59:35.000 2010-06-01 06:00:30.000 9141367150 9141155155 3 Account Main Menu 2

347 140 1 160421A401800043 2010-06-01 06:01:19.000 2010-06-01 06:01:21.000 9141439835 9141155155 Main Menu 1

348 142 1 160421A401840043 2010-06-01 06:02:01.000 2010-06-01 06:02:05.000 9141595749 9141155155 Main Menu 1

349 139 5 160421A4017D0043 2010-06-01 05:59:54.000 2010-06-01 06:02:43.000 9141428288 9141155155 8 Main Menu 2 Wrong Entry 1

350 139 1 160421A4017D0043 2010-06-01 05:59:54.000 2010-06-01 06:02:43.000 9141428288 9141155155 Main Menu 1 Product and promotion 1

351 139 4 160421A4017D0043 2010-06-01 05:59:54.000 2010-06-01 06:02:43.000 9141428288 9141155155 2 Wrong Entry 9 Repeat Menu 8 Main Menu 1

352 139 2 160421A4017D0043 2010-06-01 05:59:54.000 2010-06-01 06:02:43.000 9141428288 9141155155 1 Product and promotion Main Menu 9 Repeat Menu 1

353 139 3 160421A4017D0043 2010-06-01 05:59:54.000 2010-06-01 06:02:43.000 9141428288 9141155155 9 Repeat Menu 1 Product and promotion 2 Wrong Entry 1

354 141 1 160421A401820043 2010-06-01 06:01:48.000 2010-06-01 06:03:18.000 9141332561 9141155155 Main Menu 1

355 143 1 160421A401860043 2010-06-01 06:03:45.000 2010-06-01 06:04:17.000 9141643479 9141155155 Main Menu 1

356 144 2 160421A401880043 2010-06-01 06:04:43.000 2010-06-01 06:06:54.000 9141504831 9141155155 0 Agent Transfer Main Menu 0

357 144 1 160421A401880043 2010-06-01 06:04:43.000 2010-06-01 06:06:54.000 9141504831 9141155155 Main Menu 0 Agent Transfer 0

358 149 1 160421A401940043 2010-06-01 06:06:54.000 2010-06-01 06:07:07.000 9141401818 9141155155 Main Menu 1

359 145 1 160421A4018A0043 2010-06-01 06:05:12.000 2010-06-01 06:07:29.000 9141313126 9141155155 Main Menu 2

360 148 1 160421A401910043 2010-06-01 06:06:32.000 2010-06-01 06:07:29.000 9141365652 9141155155 Main Menu 2

361 138 3 160421A4017B0043 2010-06-01 05:59:43.000 2010-06-01 06:08:38.000 9133700090 9133155155 0 Agent Transfer 3 Account 0

362 138 1 160421A4017B0043 2010-06-01 05:59:43.000 2010-06-01 06:08:38.000 9133700090 9133155155 Main Menu 3 Account 0

363 138 2 160421A4017B0043 2010-06-01 05:59:43.000 2010-06-01 06:08:38.000 9133700090 9133155155 3 Account Main Menu 0 Agent Transfer 0

364 146 2 160421A4018D0043 2010-06-01 06:05:28.000 2010-06-01 06:08:39.000 9141701946 9141155155 0 Agent Transfer Main Menu 0

365 146 1 160421A4018D0043 2010-06-01 06:05:28.000 2010-06-01 06:08:39.000 9141701946 9141155155 Main Menu 0 Agent Transfer 0

366 147 2 160421A4018F0043 2010-06-01 06:06:06.000 2010-06-01 06:10:04.000 9141431691 9141155155 0 Agent Transfer Main Menu 0

367 147 1 160421A4018F0043 2010-06-01 06:06:06.000 2010-06-01 06:10:04.000 9141431691 9141155155 Main Menu 0 Agent Transfer 0

368 151 2 160421A4019A0043 2010-06-01 06:08:35.000 2010-06-01 06:10:44.000 9141500210 9141155155 0 Agent Transfer Main Menu 0

369 151 1 160421A4019A0043 2010-06-01 06:08:35.000 2010-06-01 06:10:44.000 9141500210 9141155155 Main Menu 0 Agent Transfer 0

370 154 1 160421A401A50043 2010-06-01 06:10:39.000 2010-06-01 06:11:07.000 9141658168 9141155155 Main Menu 1

371 156 1 160421A401AA0043 2010-06-01 06:11:12.000 2010-06-01 06:11:15.000 9141760863 9141155155 Main Menu 1

372 157 1 160421A401AE0043 2010-06-01 06:12:15.000 2010-06-01 06:12:22.000 9141438965 9141055255 Main Menu 1

373 150 3 160421A401960043 2010-06-01 06:07:12.000 2010-06-01 06:13:06.000 9141365652 9141155155 0 Agent Transfer 1 Product and promotion 0

374 150 2 160421A401960043 2010-06-01 06:07:12.000 2010-06-01 06:13:06.000 9141365652 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

375 150 1 160421A401960043 2010-06-01 06:07:12.000 2010-06-01 06:13:06.000 9141365652 9141155155 Main Menu 1 Product and promotion 0

376 155 2 160421A401A80043 2010-06-01 06:11:11.000 2010-06-01 06:13:44.000 9141500210 9141155155 0 Agent Transfer Main Menu 0

377 155 1 160421A401A80043 2010-06-01 06:11:11.000 2010-06-01 06:13:44.000 9141500210 9141155155 Main Menu 0 Agent Transfer 0

378 152 2 160421A4019C0043 2010-06-01 06:09:03.000 2010-06-01 06:14:14.000 9141454348 9141155155 0 Agent Transfer Main Menu 0

379 152 1 160421A4019C0043 2010-06-01 06:09:03.000 2010-06-01 06:14:14.000 9141454348 9141155155 Main Menu 0 Agent Transfer 0

380 159 1 160421A401B50043 2010-06-01 06:13:13.000 2010-06-01 06:14:22.000 9141332561 9141155155 Main Menu 1

381 153 2 160421A401A10043 2010-06-01 06:10:09.000 2010-06-01 06:15:05.000 9542597152 9133155155 1 Product and promotion Main Menu 2 Other Offer Details 0

382 153 3 160421A401A10043 2010-06-01 06:10:09.000 2010-06-01 06:15:05.000 9542597152 9133155155 2 Other Offer Details 1 Product and promotion 0

383 153 1 160421A401A10043 2010-06-01 06:10:09.000 2010-06-01 06:15:05.000 9542597152 9133155155 Main Menu 1 Product and promotion 0

384 160 2 160421A401B70043 2010-06-01 06:13:23.000 2010-06-01 06:17:43.000 9141688866 9141155155 0 Agent Transfer Main Menu 0

385 160 1 160421A401B70043 2010-06-01 06:13:23.000 2010-06-01 06:17:43.000 9141688866 9141155155 Main Menu 0 Agent Transfer 0

386 163 3 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Language Option 4 TPIN & Language change 7 Previous Menu 2

387 163 6 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 1 Wrong Entry 7 Previous Menu 2

388 163 9 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

389 163 10 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 4 Wrong Entry 2

390 163 15 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

391 163 16 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

392 163 1 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 Main Menu 4 TPIN & Language change 2

393 163 2 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 4 TPIN & Language change Main Menu 1 Language Option 2

394 163 4 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 1 Language Option 1 Wrong Entry 2

395 163 7 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

396 163 8 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

397 163 11 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 4 Wrong Entry 1 Wrong Entry 7 Previous Menu 2

398 163 14 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

399 163 5 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 1 Wrong Entry 2

400 163 12 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 7 Previous Menu 4 Wrong Entry 1 Wrong Entry 2

401 163 13 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

402 163 17 160421A401C10043 2010-06-01 06:15:34.000 2010-06-01 06:17:49.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 2

403 161 1 160421A401BB0043 2010-06-01 06:14:28.000 2010-06-01 06:18:19.000 9141429707 9141155155 Main Menu 1 Product and promotion 0

404 161 2 160421A401BB0043 2010-06-01 06:14:28.000 2010-06-01 06:18:19.000 9141429707 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

405 161 3 160421A401BB0043 2010-06-01 06:14:28.000 2010-06-01 06:18:19.000 9141429707 9141155155 0 Agent Transfer 1 Product and promotion 0

406 166 1 160421A401CB0043 2010-06-01 06:18:07.000 2010-06-01 06:19:11.000 9542597152 9133155155 Main Menu 2

407 169 3 160421A401D20043 2010-06-01 06:19:53.000 2010-06-01 06:20:06.000 9141744069 9141155155 1 Repeat Offer Detail 1 Product and promotion 1

408 169 1 160421A401D20043 2010-06-01 06:19:53.000 2010-06-01 06:20:06.000 9141744069 9141155155 Main Menu 1 Product and promotion 1

409 169 2 160421A401D20043 2010-06-01 06:19:53.000 2010-06-01 06:20:06.000 9141744069 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 1

410 168 3 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Language Option 4 TPIN & Language change 7 Previous Menu 2

411 168 9 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

412 168 10 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

413 168 16 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

414 168 19 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

415 168 32 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

416 168 35 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

417 168 38 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 7 Previous Menu 2

418 168 1 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 Main Menu 4 TPIN & Language change 2

419 168 4 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Language Option 1 Wrong Entry 2

420 168 5 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

421 168 14 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

422 168 15 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

423 168 20 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

424 168 21 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

425 168 26 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 * Wrong Entry 1 Wrong Entry 1 Wrong Entry 2

426 168 27 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry * Wrong Entry 7 Previous Menu 2

427 168 30 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

428 168 31 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

429 168 2 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 4 TPIN & Language change Main Menu 1 Language Option 2

430 168 8 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

431 168 11 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

432 168 17 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

433 168 18 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

434 168 24 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

435 168 33 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

436 168 34 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

437 168 6 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

438 168 7 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

439 168 12 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

440 168 13 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

441 168 22 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

442 168 23 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

443 168 25 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu * Wrong Entry 2

444 168 28 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 1 Wrong Entry 2

445 168 29 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 1 Wrong Entry 7 Previous Menu 7 Previous Menu 2

446 168 36 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 1 Wrong Entry 7 Previous Menu 2

447 168 37 160421A401CF0043 2010-06-01 06:18:45.000 2010-06-01 06:20:14.000 9141771753 9141155155 7 Previous Menu 7 Previous Menu 7 Previous Menu 2

448 170 3 160421A401D50043 2010-06-01 06:20:25.000 2010-06-01 06:20:46.000 9141771753 9141155155 # Wrong Entry # Wrong Entry 0 Agent Transfer 0

449 170 1 160421A401D50043 2010-06-01 06:20:25.000 2010-06-01 06:20:46.000 9141771753 9141155155 Main Menu # Wrong Entry 0

450 170 2 160421A401D50043 2010-06-01 06:20:25.000 2010-06-01 06:20:46.000 9141771753 9141155155 # Wrong Entry Main Menu # Wrong Entry 0

451 170 4 160421A401D50043 2010-06-01 06:20:25.000 2010-06-01 06:20:46.000 9141771753 9141155155 0 Agent Transfer # Wrong Entry 0

452 165 1 160421A401C70043 2010-06-01 06:17:25.000 2010-06-01 06:20:56.000 9141562476 9141155155 Main Menu 0 Agent Transfer 0

453 165 2 160421A401C70043 2010-06-01 06:17:25.000 2010-06-01 06:20:56.000 9141562476 9141155155 0 Agent Transfer Main Menu 0

454 171 1 160421A401D80043 2010-06-01 06:20:55.000 2010-06-01 06:21:29.000 9141771753 9141155155 Main Menu 0 Agent Transfer 0

455 171 2 160421A401D80043 2010-06-01 06:20:55.000 2010-06-01 06:21:29.000 9141771753 9141155155 0 Agent Transfer Main Menu 0

456 158 2 160421A401B00043 2010-06-01 06:12:37.000 2010-06-01 06:21:49.000 9141691097 9141155155 0 Agent Transfer Main Menu 0

457 158 1 160421A401B00043 2010-06-01 06:12:37.000 2010-06-01 06:21:49.000 9141691097 9141155155 Main Menu 0 Agent Transfer 0

458 173 1 160421A401DD0043 2010-06-01 06:21:56.000 2010-06-01 06:22:11.000 9141394383 9141155155 Main Menu 1

459 175 3 160421A401E10043 2010-06-01 06:22:44.000 2010-06-01 06:23:28.000 9133718877 9133155155 3 Wrong Entry 1 Product and promotion 1 Wrong Entry 1

460 175 4 160421A401E10043 2010-06-01 06:22:44.000 2010-06-01 06:23:28.000 9133718877 9133155155 1 Wrong Entry 3 Wrong Entry 1 Wrong Entry 1

461 175 2 160421A401E10043 2010-06-01 06:22:44.000 2010-06-01 06:23:28.000 9133718877 9133155155 1 Product and promotion Main Menu 3 Wrong Entry 1

462 175 1 160421A401E10043 2010-06-01 06:22:44.000 2010-06-01 06:23:28.000 9133718877 9133155155 Main Menu 1 Product and promotion 1

463 175 5 160421A401E10043 2010-06-01 06:22:44.000 2010-06-01 06:23:28.000 9133718877 9133155155 1 Wrong Entry 1 Wrong Entry 1

464 162 1 160421A401BE0043 2010-06-01 06:14:35.000 2010-06-01 06:23:33.000 9133737200 9133155155 Main Menu 1 Product and promotion 0

465 162 2 160421A401BE0043 2010-06-01 06:14:35.000 2010-06-01 06:23:33.000 9133737200 9133155155 1 Product and promotion Main Menu 0 Agent Transfer 0

466 162 3 160421A401BE0043 2010-06-01 06:14:35.000 2010-06-01 06:23:33.000 9133737200 9133155155 0 Agent Transfer 1 Product and promotion 0

467 176 3 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 7 Previous Menu 1 Product and promotion 7 Previous Menu 0

468 176 2 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 1 Product and promotion Main Menu 7 Previous Menu 0

469 176 1 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 Main Menu 1 Product and promotion 0

470 176 5 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 2 Wrong Entry 7 Previous Menu 2 Handset or RUIM lost 0

471 176 6 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 2 Handset or RUIM lost 2 Wrong Entry 0

472 176 4 160421A401E30043 2010-06-01 06:22:49.000 2010-06-01 06:24:12.000 9141394383 9141155155 7 Previous Menu 7 Previous Menu 2 Wrong Entry 0

473 177 1 160421A401E80043 2010-06-01 06:23:56.000 2010-06-01 06:24:18.000 9141797705 9141155155 Main Menu 1

474 174 2 160421A401DF0043 2010-06-01 06:22:33.000 2010-06-01 06:25:37.000 9141305060 9141155155 2 Handset or RUIM lost Main Menu 0

475 174 1 160421A401DF0043 2010-06-01 06:22:33.000 2010-06-01 06:25:37.000 9141305060 9141155155 Main Menu 2 Handset or RUIM lost 0

476 178 1 160421A401EB0043 2010-06-01 06:25:35.000 2010-06-01 06:25:38.000 9141479818 9141155155 Main Menu 1

477 179 1 160421A401ED0043 2010-06-01 06:25:38.000 2010-06-01 06:25:44.000 9141683906 9141155155 Main Menu 1

478 167 1 160421A401CD0043 2010-06-01 06:18:44.000 2010-06-01 06:26:04.000 9141452802 9141155155 Main Menu 3 Account 0

479 167 2 160421A401CD0043 2010-06-01 06:18:44.000 2010-06-01 06:26:04.000 9141452802 9141155155 3 Account Main Menu 0 Agent Transfer 0

480 167 3 160421A401CD0043 2010-06-01 06:18:44.000 2010-06-01 06:26:04.000 9141452802 9141155155 0 Agent Transfer 3 Account 0

481 172 2 160421A401DA0043 2010-06-01 06:21:21.000 2010-06-01 06:26:24.000 9141756323 9141155155 9 Repeat Menu Main Menu 0 Agent Transfer 0

482 172 1 160421A401DA0043 2010-06-01 06:21:21.000 2010-06-01 06:26:24.000 9141756323 9141155155 Main Menu 9 Repeat Menu 0

483 172 3 160421A401DA0043 2010-06-01 06:21:21.000 2010-06-01 06:26:24.000 9141756323 9141155155 0 Agent Transfer 9 Repeat Menu 0

484 181 1 160421A401F10043 2010-06-01 06:26:24.000 2010-06-01 06:26:37.000 9141025154 9141455455 Main Menu 2

485 164 2 160421A401C50043 2010-06-01 06:17:18.000 2010-06-01 06:26:54.000 9133708496 9133155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 0

486 164 5 160421A401C50043 2010-06-01 06:17:18.000 2010-06-01 06:26:54.000 9133708496 9133155155 0 Agent Transfer 1 Wrong Entry 0

487 164 3 160421A401C50043 2010-06-01 06:17:18.000 2010-06-01 06:26:54.000 9133708496 9133155155 1 Repeat Offer Detail 1 Product and promotion 1 Wrong Entry 0

488 164 4 160421A401C50043 2010-06-01 06:17:18.000 2010-06-01 06:26:54.000 9133708496 9133155155 1 Wrong Entry 1 Repeat Offer Detail 0 Agent Transfer 0

489 164 1 160421A401C50043 2010-06-01 06:17:18.000 2010-06-01 06:26:54.000 9133708496 9133155155 Main Menu 1 Product and promotion 0

490 183 1 160421A401F50043 2010-06-01 06:26:49.000 2010-06-01 06:27:01.000 9141025154 9141455455 Main Menu 2

491 186 1 160421A401FC0043 2010-06-01 06:27:12.000 2010-06-01 06:27:25.000 9141025154 9141455455 Main Menu 2

492 180 3 160421A401EF0043 2010-06-01 06:26:05.000 2010-06-01 06:27:34.000 4040124647 9133155155 2 Wrong Entry 2 Handset or RUIM lost 9 Repeat Menu 0

493 180 5 160421A401EF0043 2010-06-01 06:26:05.000 2010-06-01 06:27:34.000 4040124647 9133155155 0 Agent Transfer 9 Repeat Menu 0

494 180 2 160421A401EF0043 2010-06-01 06:26:05.000 2010-06-01 06:27:34.000 4040124647 9133155155 2 Handset or RUIM lost Main Menu 2 Wrong Entry 0

495 180 1 160421A401EF0043 2010-06-01 06:26:05.000 2010-06-01 06:27:34.000 4040124647 9133155155 Main Menu 2 Handset or RUIM lost 0

496 180 4 160421A401EF0043 2010-06-01 06:26:05.000 2010-06-01 06:27:34.000 4040124647 9133155155 9 Repeat Menu 2 Wrong Entry 0 Agent Transfer 0

497 187 1 160421A401FE0043 2010-06-01 06:27:19.000 2010-06-01 06:28:23.000 9141922058 9141155155 Main Menu 2 Handset or RUIM lost 0

498 187 2 160421A401FE0043 2010-06-01 06:27:19.000 2010-06-01 06:28:23.000 9141922058 9141155155 2 Handset or RUIM lost Main Menu 0

499 190 1 160421A402070043 2010-06-01 06:28:16.000 2010-06-01 06:28:29.000 9141025154 9141455455 Main Menu 2

500 182 1 160421A401F30043 2010-06-01 06:26:40.000 2010-06-01 06:28:42.000 9141314964 9141155155 Main Menu 1 Product and promotion 0

501 182 2 160421A401F30043 2010-06-01 06:26:40.000 2010-06-01 06:28:42.000 9141314964 9141155155 1 Product and promotion Main Menu 0 Agent Transfer 0

502 182 3 160421A401F30043 2010-06-01 06:26:40.000 2010-06-01 06:28:42.000 9141314964 9141155155 0 Agent Transfer 1 Product and promotion 0

503 188 1 160421A402020043 2010-06-01 06:28:01.000 2010-06-01 06:28:50.000 9141589323 9141155155 Main Menu 1

504 192 2 160421A4020B0043 2010-06-01 06:28:37.000 2010-06-01 06:28:50.000 9141025154 9141455455 2 Handset or RUIM lost Main Menu 2

505 192 1 160421A4020B0043 2010-06-01 06:28:37.000 2010-06-01 06:28:50.000 9141025154 9141455455 Main Menu 2 Handset or RUIM lost 2

506 196 1 160421A402150043 2010-06-01 06:29:48.000 2010-06-01 06:29:48.000 9141803421 9141155155 Main Menu 1

507 195 1 160421A402130043 2010-06-01 06:29:45.000 2010-06-01 06:29:49.000 9141688168 9141155155 Main Menu 1

508 191 1 160421A402090043 2010-06-01 06:28:28.000 2010-06-01 06:29:51.000 9141559626 9141155155 Main Menu 1

509 184 1 160421A401F70043 2010-06-01 06:26:50.000 2010-06-01 06:30:12.000 9141828731 9141155155 Main Menu 0 Agent Transfer 0

510 184 2 160421A401F70043 2010-06-01 06:26:50.000 2010-06-01 06:30:12.000 9141828731 9141155155 0 Agent Transfer Main Menu 0

511 197 4 160421A402170043 2010-06-01 06:29:57.000 2010-06-01 06:30:19.000 9141803421 9141155155 3 Offer 3 2 Other Offer Details 1

512 197 1 160421A402170043 2010-06-01 06:29:57.000 2010-06-01 06:30:19.000 9141803421 9141155155 Main Menu 1 Product and promotion 1

513 197 3 160421A402170043 2010-06-01 06:29:57.000 2010-06-01 06:30:19.000 9141803421 9141155155 2 Other Offer Details 1 Product and promotion 3 Offer 3 1

514 197 2 160421A402170043 2010-06-01 06:29:57.000 2010-06-01 06:30:19.000 9141803421 9141155155 1 Product and promotion Main Menu 2 Other Offer Details 1

515 189 1 160421A402040043 2010-06-01 06:28:10.000 2010-06-01 06:30:53.000 9141663712 9141155155 Main Menu 0 Agent Transfer 0

516 189 2 160421A402040043 2010-06-01 06:28:10.000 2010-06-01 06:30:53.000 9141663712 9141155155 0 Agent Transfer Main Menu 0

517 193 1 160421A4020E0043 2010-06-01 06:29:20.000 2010-06-01 06:30:55.000 9141589323 9141155155 Main Menu 0 Agent Transfer 0

518 193 2 160421A4020E0043 2010-06-01 06:29:20.000 2010-06-01 06:30:55.000 9141589323 9141155155 0 Agent Transfer Main Menu 0

519 201 1 160421A402220043 2010-06-01 06:30:49.000 2010-06-01 06:31:18.000 9141772579 9141155155 Main Menu 0 Agent Transfer 0

520 201 2 160421A402220043 2010-06-01 06:30:49.000 2010-06-01 06:31:18.000 9141772579 9141155155 0 Agent Transfer Main Menu 0

521 198 2 160421A4021B0043 2010-06-01 06:30:34.000 2010-06-01 06:31:39.000 9141660387 9141155155 1 Product and promotion Main Menu 1 Repeat Offer Detail 2

522 198 3 160421A4021B0043 2010-06-01 06:30:34.000 2010-06-01 06:31:39.000 9141660387 9141155155 1 Repeat Offer Detail 1 Product and promotion 0 Agent Transfer 2

523 198 1 160421A4021B0043 2010-06-01 06:30:34.000 2010-06-01 06:31:39.000 9141660387 9141155155 Main Menu 1 Product and promotion 2

524 198 4 160421A4021B0043 2010-06-01 06:30:34.000 2010-06-01 06:31:39.000 9141660387 9141155155 0 Agent Transfer 1 Repeat Offer Detail 2

525 199 1 160421A4021E0043 2010-06-01 06:30:42.000 2010-06-01 06:31:42.000 9141373443 9141155155 Main Menu 3 Account 1

526 199 3 160421A4021E0043 2010-06-01 06:30:42.000 2010-06-01 06:31:42.000 9141373443 9141155155 1 Know your tariff 3 Account 1

527 199 2 160421A4021E0043 2010-06-01 06:30:42.000 2010-06-01 06:31:42.000 9141373443 9141155155 3 Account Main Menu 1 Know your tariff 1

528 204 1 160421A402280043 2010-06-01 06:31:11.000 2010-06-01 06:31:57.000 9141309392 9141155155 Main Menu 2 Handset or RUIM lost 1

529 204 2 160421A402280043 2010-06-01 06:31:11.000 2010-06-01 06:31:57.000 9141309392 9141155155 2 Handset or RUIM lost Main Menu 1

530 194 1 160421A402100043 2010-06-01 06:29:22.000 2010-06-01 06:32:23.000 9141025154 9141155155 Main Menu 1 Product and promotion 0

Post #1021466

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 5

brainblower13,

Quick question, and please don't take this the wrong way.

Have you ever written an INSERT statement before?

Given the fact that you're trying to cram multiple rows into one SELECT (the later 7/8ths of your data set), have forgotten the quotes for your dates and character fields, and forgotten to separate those fields with commas leads me to believe you're completely new to SQL Server.

Is this true?

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Ken McKelvey SSCoach Points: 18843 More actions · Answer 6

Given your table definition, this should generate some usable test data:

SELECT TOP (100)

'UNION ALL SELECT '

+ CAST(ID AS varchar(20)) + ' AS ID,'

+ CAST(MainID AS varchar(20)) + ' AS MainID,'

+ '''' + SplitID + ''' AS SplitID,'

+ '''' + streamID + ''' AS streamID,'

+ '''' + CONVERT(varchar(23), OfferedTime, 121)+ ''' AS OfferedTime,'

+ '''' + CONVERT(varchar(23), TerminatedTime, 121)+ ''' AS TerminatedTime,'

+ '''' + CallerANI + ''' AS CallerANI,'

+ '''' + CallerDNIS + ''' AS CallerDNIS,'

+ CAST(IVRDigit AS varchar(20)) + ' AS IVRDigit,'

+ '''' + MenuName + ''' AS MenuName,'

+ CAST(PrevIVRDigit AS varchar(20)) + ' AS PrevIVRDigit,'

+ '''' + PrevMenuNAme + ''' AS PrevMenuNAme,'

+ CAST(NextIVRDigit AS varchar(20)) + ' AS PrevIVRDigit,'

+ '''' + NextMenuName + ''' AS PrevMenuNAme,'

+ CAST(IVRDISCONNESTED AS varchar(20)) + ' AS IVRDISCONNESTED'

FROM IVRMENU_SPLIT1

Once you have the test data, show what you want it to look like at the end of the SP.

LutzM SSC Guru Points: 107049 More actions · Answer 7

@brainblower13

Assuming you'll provide some ready to use sample data (based either on the code snippet Ken provided or by following the guidelines in the first article referenced in my signature) we'd still need your expected result based on those sample data together with a description of the business logic that needs to be used.

Please note that you'll limit the number of people trying to help you if you expect us to reverse-engineer your current sprocs with about 300 lines of undocumented code.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Jeff Moden SSC Guru Points: 1004366 More actions · Answer 8

@brainblower13,

If you want help, please read the article at the first link in my signature line below and post both the table creation scripts and the data the way the article describes. It's a very simple thing to do and scripts to help you do it are included.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

brainblower13 Right there with Babe Points: 719 More actions · Answer 9

ya..I am completely new to sql server..Anyway thanks for ur useful information.. I will learn SQL As soon as possible..

Brandie Tarvin SSC Guru Points: 173068 More actions · Answer 10

brainblower13 (11/18/2010)
ya..I am completely new to sql server..Anyway thanks for ur useful information.. I will learn SQL As soon as possible..

And now that we know that, we can tailor our responses to your learning level. We're still happy to help, and if you do as Jeff recommended, that will help us help you with this specific issue.

So please, do repost.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.