hi dharmender sir,
Here is the full Script For Data.
USE [IrregationDept_CMS]
GO
/****** Object: Table [dbo].[FINANCIAL_YEAR_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FINANCIAL_YEAR_MS](
[id] [int] NOT NULL,
[FY] [varchar](50) NOT NULL,
[transDate] [datetime] NULL,
[IsDeleted] [char](1) NOT NULL,
[SortOrder] [int] NULL,
CONSTRAINT [PK_FINANCIAL_YEAR_MS] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (10, N'2010-2011', NULL, N'0', 0)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (11, N'2011-2012', NULL, N'0', 1)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (12, N'2012-2013', NULL, N'0', 2)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (13, N'2013-2014', NULL, N'0', 3)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (14, N'2014-2015', NULL, N'0', 4)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (15, N'2015-2016', NULL, N'0', 5)
INSERT [dbo].[FINANCIAL_YEAR_MS] ([id], [FY], [transDate], [IsDeleted], [SortOrder]) VALUES (16, N'2016-2017', NULL, N'0', 6)
/****** Object: Table [dbo].[Prapatra16_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Prapatra16_MS](
[P16Id] [bigint] IDENTITY(1,1) NOT NULL,
[OrganisationId] [int] NULL,
[MandalId] [int] NULL,
[KhandId] [int] NULL,
[FYearId] [bigint] NULL,
[YearId] [int] NULL,
[MonthId] [int] NULL,
[NameOfFasaliHindi] [nvarchar](255) NULL,
[TotalNoOfTello] [bigint] NULL,
[KharifNoOfTello] [bigint] NULL,
[RabiNoOfTello] [bigint] NULL,
[KharifTarget] [numeric](18, 2) NULL,
[TotalTeloInFasali] [numeric](18, 2) NULL,
[TotalTarget] [numeric](18, 2) NULL,
[ProgressTarget] [numeric](18, 2) NULL,
[ProgressDate] [datetime] NULL,
[PercentageOfProgress] [numeric](18, 2) NULL,
[FasaliId] [bigint] NULL,
[CanalId] [bigint] NULL,
[PondId] [bigint] NULL,
[TubewellId] [bigint] NULL,
[TPKharifId] [int] NULL,
[TPRabiId] [int] NULL,
[Remarks] [nvarchar](500) NULL,
[TransDate] [datetime] NULL,
[IsDeleted] [int] NULL,
[UserId] [int] NULL,
[IsSubmitMonitering] [bit] NULL,
[SubmitDate] [datetime] NULL,
CONSTRAINT [PK__Prapatra__CA704BF707C1F487] PRIMARY KEY CLUSTERED
(
[P16Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Prapatra16_MS] ON
INSERT [dbo].[Prapatra16_MS] ([P16Id], [OrganisationId], [MandalId], [KhandId], [FYearId], [YearId], [MonthId], [NameOfFasaliHindi], [TotalNoOfTello], [KharifNoOfTello], [RabiNoOfTello], [KharifTarget], [TotalTeloInFasali], [TotalTarget], [ProgressTarget], [ProgressDate], [PercentageOfProgress], [FasaliId], [CanalId], [PondId], [TubewellId], [TPKharifId], [TPRabiId], [Remarks], [TransDate], [IsDeleted], [UserId], [IsSubmitMonitering], [SubmitDate]) VALUES (8, 1, 3, 8, 15, 2016, 10, N'थिस इस टेस्ट ', 25, 15, 52, CAST(50.00 AS Numeric(18, 2)), CAST(35.00 AS Numeric(18, 2)), CAST(40.00 AS Numeric(18, 2)), CAST(90.00 AS Numeric(18, 2)), CAST(0x0000A41E00015F90 AS DateTime), CAST(44.44 AS Numeric(18, 2)), NULL, NULL, NULL, NULL, NULL, NULL, N'', CAST(0x0000A6A700F31BB9 AS DateTime), 0, 4, 0, NULL)
INSERT [dbo].[Prapatra16_MS] ([P16Id], [OrganisationId], [MandalId], [KhandId], [FYearId], [YearId], [MonthId], [NameOfFasaliHindi], [TotalNoOfTello], [KharifNoOfTello], [RabiNoOfTello], [KharifTarget], [TotalTeloInFasali], [TotalTarget], [ProgressTarget], [ProgressDate], [PercentageOfProgress], [FasaliId], [CanalId], [PondId], [TubewellId], [TPKharifId], [TPRabiId], [Remarks], [TransDate], [IsDeleted], [UserId], [IsSubmitMonitering], [SubmitDate]) VALUES (9, 1, 3, 24, 15, 2016, 10, N'थिस इस नई test', 50, 15, 30, CAST(50.00 AS Numeric(18, 2)), CAST(50.00 AS Numeric(18, 2)), CAST(20.00 AS Numeric(18, 2)), CAST(90.00 AS Numeric(18, 2)), CAST(0x0000A58B0002BF20 AS DateTime), CAST(22.22 AS Numeric(18, 2)), NULL, NULL, NULL, NULL, NULL, NULL, N'', CAST(0x0000A6A700F34232 AS DateTime), 0, 4, 0, NULL)
INSERT [dbo].[Prapatra16_MS] ([P16Id], [OrganisationId], [MandalId], [KhandId], [FYearId], [YearId], [MonthId], [NameOfFasaliHindi], [TotalNoOfTello], [KharifNoOfTello], [RabiNoOfTello], [KharifTarget], [TotalTeloInFasali], [TotalTarget], [ProgressTarget], [ProgressDate], [PercentageOfProgress], [FasaliId], [CanalId], [PondId], [TubewellId], [TPKharifId], [TPRabiId], [Remarks], [TransDate], [IsDeleted], [UserId], [IsSubmitMonitering], [SubmitDate]) VALUES (10, 1, 3, 8, 16, 2016, 10, N'टेस्ट ', 50, 15, 52, CAST(50.00 AS Numeric(18, 2)), CAST(35.00 AS Numeric(18, 2)), CAST(45.00 AS Numeric(18, 2)), CAST(75.00 AS Numeric(18, 2)), CAST(0x0000A5840002BF20 AS DateTime), CAST(60.00 AS Numeric(18, 2)), NULL, NULL, NULL, NULL, NULL, NULL, N'', CAST(0x0000A6A700F3835C AS DateTime), 0, 4, 0, NULL)
INSERT [dbo].[Prapatra16_MS] ([P16Id], [OrganisationId], [MandalId], [KhandId], [FYearId], [YearId], [MonthId], [NameOfFasaliHindi], [TotalNoOfTello], [KharifNoOfTello], [RabiNoOfTello], [KharifTarget], [TotalTeloInFasali], [TotalTarget], [ProgressTarget], [ProgressDate], [PercentageOfProgress], [FasaliId], [CanalId], [PondId], [TubewellId], [TPKharifId], [TPRabiId], [Remarks], [TransDate], [IsDeleted], [UserId], [IsSubmitMonitering], [SubmitDate]) VALUES (11, 1, 3, 8, 15, 2016, 10, N'थिस इस टेस्ट ', 50, 40, 64, CAST(25.00 AS Numeric(18, 2)), CAST(25.00 AS Numeric(18, 2)), CAST(10.00 AS Numeric(18, 2)), CAST(10.00 AS Numeric(18, 2)), CAST(0x0000A58B00004650 AS DateTime), CAST(40.00 AS Numeric(18, 2)), NULL, NULL, NULL, NULL, NULL, NULL, N'अभ्युक्ति', CAST(0x0000A6AA01145A90 AS DateTime), 0, 4, 0, NULL)
INSERT [dbo].[Prapatra16_MS] ([P16Id], [OrganisationId], [MandalId], [KhandId], [FYearId], [YearId], [MonthId], [NameOfFasaliHindi], [TotalNoOfTello], [KharifNoOfTello], [RabiNoOfTello], [KharifTarget], [TotalTeloInFasali], [TotalTarget], [ProgressTarget], [ProgressDate], [PercentageOfProgress], [FasaliId], [CanalId], [PondId], [TubewellId], [TPKharifId], [TPRabiId], [Remarks], [TransDate], [IsDeleted], [UserId], [IsSubmitMonitering], [SubmitDate]) VALUES (12, 1, 3, 8, 16, 2016, 10, N'टेस्ट ', 52, 10, 21, CAST(79.00 AS Numeric(18, 2)), CAST(30.00 AS Numeric(18, 2)), CAST(10.00 AS Numeric(18, 2)), CAST(50.00 AS Numeric(18, 2)), CAST(0x0000A5830002BF20 AS DateTime), CAST(20.00 AS Numeric(18, 2)), NULL, NULL, NULL, NULL, NULL, NULL, N'', CAST(0x0000A6A700F473CB AS DateTime), 1, 4, 0, NULL)
SET IDENTITY_INSERT [dbo].[Prapatra16_MS] OFF
/****** Object: Table [dbo].[Organisation_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Organisation_MS](
[OrganisationId] [int] IDENTITY(1,1) NOT NULL,
[OrganisationName] [varchar](400) NULL,
[OrganisationNameInHindi] [nvarchar](1000) NULL,
[TransDate] [datetime] NULL,
[isDeleted] [bit] NULL,
[IPAddress] [nvarchar](50) NULL,
[UpdateDate] [datetime] NULL,
[UpdateId] [nvarchar](50) NULL,
[IsRevalution] [bit] NOT NULL,
[IsSubmited] [bit] NULL,
[SubmitDate] [datetime] NULL,
CONSTRAINT [PK_Organisation_MS] PRIMARY KEY CLUSTERED
(
[OrganisationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Organisation_MS] ON
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (1, N'(Madhya Ganga) Aligarh', N'मुख्य अभियन्ता (मध्य गंगा नहर परियोजना), अलीगढ़', NULL, NULL, NULL, NULL, NULL, 1, 1, CAST(0x0000A6A300F54B84 AS DateTime))
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (2, NULL, N'पूर्वी गंगा', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (3, NULL, N'राम गंगा', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (4, NULL, N'यमुना (ओखला)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (5, NULL, N'बेतवा', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (6, NULL, N'बेतवा (परियोजना)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (7, NULL, N'बन सागर', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (8, NULL, N'सोन', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (9, NULL, N'कनहर', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (10, NULL, N'शारदा सहायक', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (11, NULL, N'अनुश्रवण एवं समन्वय', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (12, NULL, N'सरयू (I)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (13, NULL, N'सरयू (II)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (14, NULL, N'गंडक', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (15, NULL, N'शारदा', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (16, NULL, N'समझौता', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (17, NULL, N'नलकूप (पूर्वी)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (18, NULL, N'नलकूप (पश्चिमी)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (19, NULL, N'नलकूप (मध्य, लखनऊ)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (20, NULL, N'नलकूप (वाराणसी)', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
INSERT [dbo].[Organisation_MS] ([OrganisationId], [OrganisationName], [OrganisationNameInHindi], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateId], [IsRevalution], [IsSubmited], [SubmitDate]) VALUES (21, NULL, N'उपकरण एवं सामग्री प्रबंधन', NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Organisation_MS] OFF
/****** Object: Table [dbo].[Month_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Month_MS](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Month] [varchar](50) NULL,
[MonthInHindi] [nvarchar](100) NULL,
[isDeleted] [bit] NULL,
[TransDate] [datetime] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Month_MS] ON
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (1, N'January', N'जनवरी', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (2, N'February', N'फ़रवरी', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (3, N'March', N'मार्च', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (4, N'April', N'अप्रैल', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (5, N'May', N'मई', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (6, N'June', N'जून', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (7, N'July', N'जुलाई', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (8, N'August', N'अगस्त', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (9, N'September', N'सितंबर', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (10, N'October', N'अक्टूबर', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (11, N'November', N'नवंबर', NULL, NULL)
INSERT [dbo].[Month_MS] ([Id], [Month], [MonthInHindi], [isDeleted], [TransDate]) VALUES (12, N'December', N'दिसंबर', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Month_MS] OFF
/****** Object: Table [dbo].[Mandal_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Mandal_MS](
[MandalId] [int] IDENTITY(1,1) NOT NULL,
[Mandal] [nvarchar](800) NULL,
[MandalInEnglish] [nvarchar](800) NULL,
[OrganisationId] [int] NULL,
[TransDate] [datetime] NULL,
[isDeleted] [bit] NULL,
[IPAddress] [nvarchar](50) NULL,
[UpdateDate] [datetime] NULL,
[UpdateIP] [nvarchar](50) NULL,
CONSTRAINT [PK_Mandal_MS] PRIMARY KEY CLUSTERED
(
[MandalId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Mandal_MS] ON
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (1, N'अधीक्षण अभियन्ता, मध्य गंगा नहर नि.मं., रूड़की', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (2, N'अधीक्षण अभियंता, मध्य गंगा नहर निर्माण मण्डल, बुलन्दशहर', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (3, N'अधीक्षण अभियंता, सिंचाई निर्माण मण्डल, अलीगढ़', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (4, N'अधीक्षण अभियंता, मध्य गंगा नहर निर्माण मण्डल, मुरादाबाद', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (5, N'अधीक्षण अभियंता, मध्य गंगा नहर निर्माण मण्डल-प्रथम, मेरठ', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (17, N'अधीक्षण अभियन्ता, चतुर्थ मण्डल, सिंचाई कार्य, झांसी', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Mandal_MS] ([MandalId], [Mandal], [MandalInEnglish], [OrganisationId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (18, N'अधीक्षण अभियन्ता, सिचाई कार्य, मण्डल, बांदा', NULL, 5, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Mandal_MS] OFF
/****** Object: Table [dbo].[Khand_MS] Script Date: 10/25/2016 16:58:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Khand_MS](
[KhandId] [int] IDENTITY(1,1) NOT NULL,
[Khand] [nvarchar](800) NULL,
[KhandInEnglish] [nvarchar](800) NULL,
[MandalId] [int] NULL,
[TransDate] [datetime] NULL,
[isDeleted] [bit] NULL,
[IPAddress] [nvarchar](50) NULL,
[UpdateDate] [datetime] NULL,
[UpdateIP] [nvarchar](50) NULL,
CONSTRAINT [PK_Khand_MS] PRIMARY KEY CLUSTERED
(
[KhandId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Khand_MS] ON
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (1, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-1, हरिद्वार', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (2, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-2, हरिद्वार', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (3, N'अधिशासी अभियंता, टी0 एण्ड क्यु0 सी0 डी0 रूड़की', NULL, 1, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (4, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-8, बुलन्दशहर', NULL, 2, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (5, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-14, गढ़मुक्तेश्वर', NULL, 2, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (6, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-13, गढ़मुक्तेश्वर', NULL, 2, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (7, N'अधिशासी अभियन्ता, मध्य गंगा नहर निर्माण खण्ड-11, अलीगढ़', NULL, 3, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (8, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-12, अलीगढ़', NULL, 3, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (9, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-9, सम्भल', NULL, 3, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (11, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-3, अमरोहा', NULL, 4, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (12, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-4, अमरोहा', NULL, 4, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (13, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-15, मुरादाबाद', NULL, 4, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (14, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-5, बिजनौर', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (15, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-6, मेरठ', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (16, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-7, बिजनौर', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (17, N'अधिशासी अभियंता, मध्य गंगा नहर निर्माण खण्ड-10, बुलन्दशहर', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (18, N'अधिशासी अभियंता, सम्पर्क एवं क्रय अधि., ओखला', NULL, 5, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (24, N'अधिशासी अभियंता, मध्य गंगा निर्माण खण्ड-16, चन्दौसी', NULL, 3, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (25, N'अधिशासी अभियंता, झांसी प्रखण्ड, बेतवा', NULL, 17, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (26, N'अधिशासी अभियंता, माताटीला बांध प्रखण्ड, झांसी', NULL, 17, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (27, N'अधिशासी अभियंता, सपरार प्रखण्ड, झांसी', NULL, 17, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (28, N'अधिशासी अभियन्ता, केन नर प्रमुख बांदा', NULL, 18, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[Khand_MS] ([KhandId], [Khand], [KhandInEnglish], [MandalId], [TransDate], [isDeleted], [IPAddress], [UpdateDate], [UpdateIP]) VALUES (29, N'अधिशासी अभियन्ता, सिंचाई खण्ड-3, बांदा', NULL, 18, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[Khand_MS] OFF
/****** Object: Default [DF_Organisation_MS_RevalutionID] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Organisation_MS] ADD CONSTRAINT [DF_Organisation_MS_RevalutionID] DEFAULT ((0)) FOR [IsRevalution]
GO
/****** Object: Default [DF__Prapatra1__Trans__09AA3CF9] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Prapatra16_MS] ADD CONSTRAINT [DF__Prapatra1__Trans__09AA3CF9] DEFAULT (getdate()) FOR [TransDate]
GO
/****** Object: Default [DF__Prapatra1__IsDel__0A9E6132] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Prapatra16_MS] ADD CONSTRAINT [DF__Prapatra1__IsDel__0A9E6132] DEFAULT ((0)) FOR [IsDeleted]
GO
/****** Object: Default [DF_Prapatra16_MS_IsSubmitMonitering] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Prapatra16_MS] ADD CONSTRAINT [DF_Prapatra16_MS_IsSubmitMonitering] DEFAULT ((0)) FOR [IsSubmitMonitering]
GO
/****** Object: ForeignKey [FK_Khand_MS_Mandal_MS] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Khand_MS] WITH CHECK ADD CONSTRAINT [FK_Khand_MS_Mandal_MS] FOREIGN KEY([MandalId])
REFERENCES [dbo].[Mandal_MS] ([MandalId])
GO
ALTER TABLE [dbo].[Khand_MS] CHECK CONSTRAINT [FK_Khand_MS_Mandal_MS]
GO
/****** Object: ForeignKey [FK_Mandal_MS_Organisation_MS] Script Date: 10/25/2016 16:58:28 ******/
ALTER TABLE [dbo].[Mandal_MS] WITH CHECK ADD CONSTRAINT [FK_Mandal_MS_Organisation_MS] FOREIGN KEY([OrganisationId])
REFERENCES [dbo].[Organisation_MS] ([OrganisationId])
GO
ALTER TABLE [dbo].[Mandal_MS] CHECK CONSTRAINT [FK_Mandal_MS_Organisation_MS]
GO