Fragensteller
Column Store Index (Batch Vs Row)
-
Hi folks,
Could some1 please tell me when SQL Server uses Row Store Execution mode and when it uses Batch mode.
I have a table which have following schema, and I am running this code.
I don't know why I am getting row mode in execution instead of batch.
My column store index contains all the columns.
Shed some light please.
Thanks
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
- Verschoben Kalman Toth Donnerstag, 31. Oktober 2013 23:54 Not t-sql.
Frage
Alle Antworten
-
Guessing time :-(
PLEASE POST DDL+DML!
* maybe this general response will help you: Batch mode processing can operate on many rows at a time—a batch—rather than one row at a time, as is typical with row-mode processing, the type used for most online transactional processing (OLTP) operations...the advantages of batch processing can be realized only if you’re joining, filtering, or aggregating large data sets. Without these elements, batch processing is not possible.
https://www.simple-talk.com/sql/database-administration/columnstore-indexes-in-sql-server-2012/
[Personal Site] [Blog] [Facebook]
- Bearbeitet pituachMVP Donnerstag, 31. Oktober 2013 13:09
-
I am moving it to Data Warehousing.
Kalman Toth Database & OLAP Architect IPAD SELECT Query Video Tutorial 3.5 Hours
New Book / Kindle: Exam 70-461 Bootcamp: Querying Microsoft SQL Server 2012 -
PLEASE POST DDL+DML!
USE [DM_CRM] GO /****** Object: Table [db_datareader].[TEMPFORUM] Script Date: 11/1/2013 11:48:22 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [db_datareader].[TEMPFORUM]( [Messageid] [varchar](50) NULL, [Recipient] [varchar](50) NULL, [Sender] [varchar](50) NULL, [Sent_On] [varchar](50) NULL, [Received_On] [varchar](50) NULL, [Operator] [varchar](50) NULL, [Text] [varchar](8000) NULL, [Sender_Txt] [varchar](50) NULL, [SMS_Split] [varchar](50) NULL, [Status] [varchar](50) NULL, [Reason_of_failure] [varchar](50) NULL, [Circle] [varchar](100) NULL, [Sent_On_DATE] [datetime] NULL, [Received_On_DATE] [datetime] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135710', N'9886624049', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135711', N'9886621250', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135712', N'9886621074', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102488', N'9341063777', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102489', N'9341024564', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102491', N'9341005237', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102497', N'9243824983', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102499', N'9243700592', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102502', N'9243497623', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102503', N'9243471511', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102504', N'9243454221', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102507', N'9243447425', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102510', N'9243437955', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102512', N'9243434400', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102513', N'9243425214', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102514', N'9243424644', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102515', N'9243424185', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'TATACDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102517', N'8892073323', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRCEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102518', N'8892043646', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRCEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102519', N'8892030126', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRCEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102521', N'8892012125', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRCEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Network Error ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102523', N'8884998884', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102525', N'8884994111', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102526', N'8884987378', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102527', N'8884981242', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102528', N'8884949249', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102531', N'8884913484', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102534', N'8884881854', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102535', N'8884803201', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102536', N'8884799176', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102537', N'8884789269', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102539', N'8884747650', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102540', N'8884696463', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102541', N'8884688333', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102542', N'8884687500', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102543', N'8884634447', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102546', N'8884586478', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102547', N'8884569341', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102550', N'8884410182', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102554', N'8884400766', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Barring', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102557', N'8884382777', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102560', N'8884291719', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102563', N'8884260111', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102564', N'8884237999', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102565', N'8884223300', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102566', N'8884223054', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102567', N'8884211148', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102568', N'8884194194', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102570', N'8884154121', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102574', N'8884136999', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102575', N'8884124491', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102577', N'9742280178', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102578', N'9742278728', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Invalid Number ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102579', N'9742277725', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102582', N'9742264602', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102583', N'9742262442', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102584', N'9742261492', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102585', N'9742260681', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102588', N'9742239847', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102598', N'9742191711', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102599', N'9742174003', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102600', N'9742156312', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102603', N'9742137216', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'VODAFONE', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102682', N'9379356566', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102683', N'9379333939', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102689', N'9379099110', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102698', N'9346672820', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'AndhraPradesh', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102699', N'9353891891', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102700', N'9353069017', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102701', N'9353012526', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102704', N'9343944666', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801102705', N'9343866007', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'RELIANCECDMA', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135774', N'9686182942', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135777', N'9686155443', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135779', N'9686129948', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135780', N'9686127214', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135784', N'9731020110', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135785', N'9731018039', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135786', N'9731012972', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135787', N'9731011662', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135789', N'9731003231', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135803', N'9686965777', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135804', N'9686963957', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135805', N'9686955603', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135810', N'9686913912', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135816', N'9686888656', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135817', N'9686877991', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135818', N'9686866887', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135821', N'9686860817', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135822', N'9686856778', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135824', N'9686840005', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135825', N'9686832993', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135826', N'9686828310', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801135828', N'9686776543', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Invalid Number ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138306', N'9686684700', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Failed', N'Absent Subscriber ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138307', N'9686683324', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138309', N'9686677569', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138310', N'9686676509', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138312', N'9686665936', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO INSERT [db_datareader].[TEMPFORUM] ([Messageid], [Recipient], [Sender], [Sent_On], [Received_On], [Operator], [Text], [Sender_Txt], [SMS_Split], [Status], [Reason_of_failure], [Circle], [Sent_On_DATE], [Received_On_DATE]) VALUES (N'801138313', N'9686664213', N'BAJAJF', N'Oct 26 2013 1:50PM', N'Oct 26 2013 1:53PM', N'AIRTEL', N'Dear Customer, Bajaj Finserv now comes closer to you with a new branch at Srishiva Complex, Rajaji Nagar.', N'2327', N'1', N'Delivered', N' ', N'Karnataka', CAST(0x0000A26300E3F760 AS DateTime), CAST(0x0000A26300000000 AS DateTime)) GO
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
-
...
Could some1 please tell me when SQL Server uses Row Store Execution mode and when it uses Batch mode.
I have a table which have following schema, and I am running this code.
I don't know why I am getting row mode in execution instead of batch.
..
Your query runs with MAX DOP = 1
Only queries that run using parallel threads can use batch mode. That's a primer.
More restrictions apply.
For more information: http://technet.microsoft.com/en-us/library/gg492088.aspx
Andreas Wolter | Microsoft Certified Master SQL Server
Blog: www.insidesql.org/blogs/andreaswolter
Web: www.andreas-wolter.com | www.SarpedonQualityLab.com -
Andreas.Wolter, I wrote that afterwards. Actual code does not have the query hint.
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
-
Andreas.Wolter, I wrote that afterwards. Actual code does not have the query hint.
..
that is confusing for people, since it says "...I am running this code..."
Could you provide the corrected setup including all details (Index + query)?
Because except that query hint, the index scan should run in batch mode.
+ make sure it really does run in row more without the hint, and you indeed have multiple processor cores available (meaning: check the sql server configuration as well)
Andreas Wolter | Microsoft Certified Master SQL Server
Blog: www.insidesql.org/blogs/andreaswolter
Web: www.andreas-wolter.com | www.SarpedonQualityLab.com -
1. You don't have any Index on your table (as your DDL show.. this is part of why we need YOUR DDL), Moreover NO COLUMN STORE INDEX!
2 Your Query is an image and we can't copy it! i will not write it myself in the 5 min i have break at work, and i am coming here to help as many people as i can.
* If this is not your DDL, and NOT your query, and not your DML, and not your Execution plan (as this is the plan for the query i suppose)... then how can we help you?!?
** Please do not ask us to perform unnecessary operations, at the expense of helping others. Our time is our free time and we come to help others on our free time. Invest a little of your question, at least half of what you want us to help you invest :-)
[Personal Site] [Blog] [Facebook]
- Bearbeitet pituachMVP Freitag, 1. November 2013 17:21
