none
Column Store Index (Batch Vs Row)

    Question

  • 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.

    Schema and Code

    I don't know why I am getting row mode in execution instead of batch.

    Execution Plan

    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.

    • Moved by Kalman Toth Thursday, October 31, 2013 11:54 PM Not t-sql.
    Thursday, October 31, 2013 12:37 PM

All replies

  • 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]signature

    • Edited by pituach Thursday, October 31, 2013 1:09 PM
    Thursday, October 31, 2013 1:05 PM
  • 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


    Thursday, October 31, 2013 11:54 PM
  • 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.

    Friday, November 01, 2013 6:20 AM
  • ...

    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.

    Schema and 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

    Friday, November 01, 2013 11:03 AM
  • 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.

    Friday, November 01, 2013 12:55 PM
  • 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

    Friday, November 01, 2013 1:11 PM
  • 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]signature

    • Edited by pituach Friday, November 01, 2013 5:21 PM
    Friday, November 01, 2013 5:08 PM