Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Query to select the single record

Author  Topic 

pankaj2910
Starting Member

31 Posts

Posted - 2014-08-18 : 07:40:58
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[testing](
[MemberScode] [varchar](2) NULL,
[MemberS] [varchar](100) NULL,
[MemberDCode] [varchar](2) NULL,
[MemberD] [varchar](100) NULL,
[IDN] [varchar](20) NULL,
[Number] [varchar](50) NULL,
[CCode] [varchar](2) NULL,
[HMID] [int] NULL,
[PatientID] [int] NULL,
[PatientCardGender] [varchar](10) NULL,
[PatientCardAge] [int] NULL,
[PatientGender] [varchar](10) NULL,
[PatientAge] [int] NULL,
[HlCode] [varchar](10) NULL,
[RegistrationNo] [varchar](50) NULL,
[RegistrationUserDate] [varchar](50) NULL,
[RegistrationSystemDate] [varchar](50) NULL,
[BlockingInvoiceNo] [varchar](50) NULL,
[BlockingUserDate] [varchar](50) NULL,
[BlockingSystemDate] [varchar](50) NULL,
[UnblockingInvoiceNo] [varchar](50) NULL,
[UnblockingDesc] [varchar](max) NULL,
[UnblockingSystemDate] [varchar](50) NULL,
[DischargeInvoiceNo] [varchar](50) NULL,
[DischargeUserDate] [varchar](50) NULL,
[DischargeSystemDate] [varchar](50) NULL,
[PackageCode] [varchar](25) NULL,
[ProcedureName] [varchar](max) NULL,
[PackageCost] [varchar](20) NULL,
[NoofDays] [int] NULL,
[AmoutBlocked] [varchar](20) NULL,
[AmoutClaimed] [varchar](20) NULL,
[TMode] [varchar](50) NULL,
[UnspecifiedAuthCode] [varchar](50) NULL,
[UnspecifiedAuthDate] [varchar](50) NULL,
[BCPAuthorizationCode] [varchar](50) NULL,
[BCPAuthorizationDate] [varchar](50) NULL,
[FPOverideCode] [varchar](50) NULL,
[FPOverideDate] [varchar](50) NULL,
[Mortality] [varchar](50) NULL,
[MortalitySummary] [varchar](max) NULL,
[FPFailureCount] [int] NULL,
[VerifiedMemberID] [int] NULL,
[Version] [varchar](250) NULL,
[ID] [int] IDENTITY(1,1) NOT NULL,
[UploadDateTime] [varchar](50) NULL,
[BlockCode] [nvarchar](100) NULL,
[PanchayatCode] [nvarchar](100) NULL,
[VillageCode] [nvarchar](100) NULL,
[TotalAmtBlockedOnCard] [varchar](50) NULL,
[VerifiedMemberName] [varchar](255) NULL,
[OriginalPackageCost] [nvarchar](50) NULL,
[PackageName] [nvarchar](100) NULL,
[ProcedureCode] [nvarchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[testing] ON
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912002753', N'141300/47/2014/00005', N'02', 1, 1, N'1', 57, N'1', 57, N'24001072', N'3000807201424001072001', N'08/07/2014 09:53:47', N'08/07/2014 09:57:34', N'3010807201424001072110', N'08/07/2014 12:31:00', N'08/07/2014 12:35:31', N'', N'', N'', N'3030807201424001072001', N'08/07/2014 17:47:58', N'08/07/2014 17:49:00', N'43', N'OPHTHALMOLOGY', N'4500', NULL, N'4500', N'4500', N'N', N'', N'', N'', N'', N'4513', N'08/07/2014 17:49:00', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 3, N'08/07/2014 17:50:27', N'01002', N'100020046', N'00016000', N'4500', NULL, N'4500', N'Cataract with IOL by Phoco emulsification tech. unilateral', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010207412001392', N'141300/47/2014/00005', N'02', 1, 1, N'1', 46, N'1', 46, N'24001072', N'3001107201424001072001', N'11/07/2014 09:10:02', N'11/07/2014 09:10:52', N'3011107201424001072111', N'11/07/2014 09:15:34', N'11/07/2014 09:16:16', N'', N'', N'', N'3031107201424001072001', N'12/07/2014 07:32:40', N'12/07/2014 07:33:50', N'5', N'OPHTHALMOLOGY', N'2000', 1, N'2000', N'2000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 6, N'12/07/2014 07:35:13', N'01002', N'100020064', N'00018800', N'2000', N'BAJRANGDAS', N'2000', N'Capsulotomy', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010203712003984', N'141300/47/2014/00005', N'02', 1, 2, N'2', 37, N'2', 40, N'24001072', N'3001407201424001072001', N'14/07/2014 16:21:35', N'14/07/2014 16:34:01', N'3011407201424001072112', N'14/07/2014 16:37:06', N'14/07/2014 16:38:15', N'', N'', N'', N'3031407201424001072001', N'15/07/2014 09:34:55', N'15/07/2014 09:37:43', N'15', N'OPHTHALMOLOGY', N'3500', NULL, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 10, N'15/07/2014 09:39:32', N'01002', N'100020034', N'00014500', N'3500', N'JIVATI', N'3500', N'Pterigium + Conjunctival Autograft', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010209612000305', N'141300/47/2014/00005', N'02', 1, 1, N'1', 38, N'1', 38, N'24001072', N'3002207201424001072001', N'22/07/2014 12:01:44', N'22/07/2014 12:03:22', N'3012207201424001072113', N'22/07/2014 12:05:55', N'22/07/2014 12:06:42', N'', N'', N'', N'3032207201424001072001', N'22/07/2014 16:17:28', N'22/07/2014 16:19:04', N'15', N'OPHTHALMOLOGY', N'3500', NULL, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 13, N'22/07/2014 16:20:30', N'01002', N'100020079', N'00015700', N'3500', N'MAVJI', N'3500', N'Pterigium + Conjunctival Autograft', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010209612000305', N'141300/47/2014/00005', N'02', 1, 1, N'1', 38, N'1', 38, N'24001072', N'3002207201424001072001', N'22/07/2014 12:01:44', N'22/07/2014 12:03:22', N'3012207201424001072113', N'22/07/2014 12:05:55', N'22/07/2014 12:06:42', N'', N'', N'', N'3032207201424001072001', N'22/07/2014 16:17:28', N'22/07/2014 16:19:04', N'15', N'OPHTHALMOLOGY', N'3500', NULL, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 14, N'22/07/2014 16:20:31', N'01002', N'100020079', N'00015700', N'3500', N'MAVJI', N'3500', N'Pterigium + Conjunctival Autograft', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010203812001952', N'141300/47/2014/00005', N'02', 1, 7, N'1', 51, N'2', 60, N'24001072', N'3002807201424001072001', N'28/07/2014 10:03:00', N'28/07/2014 10:03:40', N'3012807201424001072114', N'28/07/2014 10:05:39', N'28/07/2014 10:06:32', N'', N'', N'', N'3032807201424001072001', N'28/07/2014 16:23:34', N'28/07/2014 16:25:14', N'43', N'OPHTHALMOLOGY', N'4500', NULL, N'4500', N'4500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 7, N' Version:2.6.0.4 Released On:17/01/2014', 17, N'28/07/2014 16:26:43', N'01002', N'100020035', N'00014600', N'4500', N'BAYABEN', N'4500', N'Cataract with IOL by Phoco emulsification tech. unilateral', N'10')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212024407', N'141300/47/2014/00005', N'02', 1, 1, N'1', 51, N'1', 65, N'24001073', N'3003006201424001073001', N'30/06/2014 10:36:21', N'30/06/2014 10:44:58', N'3013006201424001073385', N'30/06/2014 11:17:31', N'30/06/2014 11:18:26', N'', N'', N'', N'3033006201424001073001', N'03/07/2014 11:21:37', N'03/07/2014 11:22:39', N'1000', N'MEDICAL', N'5000', 5, N'3000', N'3000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 22, N'03/07/2014 11:49:12', N'01008', N'01008', N'04010500', NULL, N'RANBAI', N'5000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212024407', N'141300/47/2014/00005', N'02', 1, 2, N'2', 45, N'2', 60, N'24001073', N'3003006201424001073002', N'30/06/2014 12:29:50', N'30/06/2014 12:31:47', N'3013006201424001073386', N'30/06/2014 12:33:28', N'30/06/2014 12:34:11', N'', N'', N'', N'3033006201424001073002', N'03/07/2014 11:24:50', N'03/07/2014 11:25:51', N'999', N'MEDICAL', N'2500', 5, N'1500', N'1500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 23, N'03/07/2014 11:49:12', N'01008', N'01008', N'04010500', NULL, N'RANBAI', N'2500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212016896', N'141300/47/2014/00005', N'02', 1, 1, N'1', 48, N'1', 3, N'24001073', N'3000307201424001073003', N'03/07/2014 17:19:03', N'03/07/2014 17:20:30', N'3010307201424001073395', N'03/07/2014 18:19:05', N'03/07/2014 18:19:41', N'', N'', N'', N'3030307201424001073003', N'07/07/2014 11:14:32', N'07/07/2014 11:15:18', N'999', N'MEDICAL', N'1500', 3, N'2000', N'2000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 2, 1, N' Version:2.6.0.4 Released On:17/01/2014', 36, N'07/07/2014 17:07:37', N'01008', N'01008', N'04010500', NULL, N'ABBAS', N'1500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212016896', N'141300/47/2014/00005', N'02', 1, 1, N'1', 48, N'1', 3, N'24001073', N'3000307201424001073003', N'03/07/2014 17:19:03', N'03/07/2014 17:20:30', N'3010307201424001073395', N'03/07/2014 18:19:05', N'03/07/2014 18:19:41', N'', N'', N'', N'3030307201424001073003', N'07/07/2014 11:14:32', N'07/07/2014 11:15:18', N'999', N'MEDICAL', N'1500', 3, N'2000', N'2000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 2, 2, N' Version:2.6.0.4 Released On:17/01/2014', 37, N'07/07/2014 17:07:37', N'01008', N'01008', N'04010500', NULL, N'JABETBAI', N'1500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212016896', N'141300/47/2014/00005', N'02', 1, 1, N'1', 48, N'1', 3, N'24001073', N'3000307201424001073003', N'03/07/2014 17:19:03', N'03/07/2014 17:20:30', N'3010307201424001073395', N'03/07/2014 18:19:05', N'03/07/2014 18:19:41', N'', N'', N'', N'3030307201424001073003', N'07/07/2014 11:14:32', N'07/07/2014 11:15:18', N'999', N'MEDICAL', N'1500', 3, N'2000', N'2000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 2, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 38, N'07/07/2014 17:07:37', N'01008', N'01008', N'04010500', NULL, NULL, N'1500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212001118', N'141300/47/2014/00005', N'02', 1, 3, N'1', 48, N'2', 25, N'24001073', N'3000907201424001073001', N'09/07/2014 16:45:52', N'09/07/2014 16:48:39', N'3010907201424001073400', N'09/07/2014 16:50:45', N'09/07/2014 16:51:36', N'', N'', N'', N'3030907201424001073001', N'12/07/2014 10:12:17', N'12/07/2014 10:13:14', N'999', N'MEDICAL', N'2500', 5, N'1500', N'1500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 49, N'12/07/2014 11:16:49', N'01008', N'01008', N'04010500', NULL, NULL, N'2500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212001118', N'141300/47/2014/00005', N'02', 1, 3, N'1', 48, N'2', 25, N'24001073', N'3000907201424001073001', N'09/07/2014 16:45:52', N'09/07/2014 16:48:39', N'3010907201424001073400', N'09/07/2014 16:50:45', N'09/07/2014 16:51:36', N'', N'', N'', N'3030907201424001073001', N'12/07/2014 10:12:17', N'12/07/2014 10:13:14', N'999', N'MEDICAL', N'2500', 5, N'1500', N'1500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, 2, N' Version:2.6.0.4 Released On:17/01/2014', 50, N'12/07/2014 11:16:49', N'01008', N'01008', N'04010500', NULL, N'meramabai', N'2500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212017685', N'141300/47/2014/00005', N'02', 1, 3, N'1', 13, N'1', 10, N'24001073', N'3001107201424001073001', N'11/07/2014 12:20:38', N'11/07/2014 12:40:00', N'3011107201424001073401', N'11/07/2014 12:45:05', N'11/07/2014 12:45:51', N'', N'', N'', N'3031107201424001073001', N'14/07/2014 10:48:31', N'14/07/2014 10:51:14', N'999', N'MEDICAL', N'2500', 5, N'1500', N'1500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 51, N'14/07/2014 11:14:15', N'01008', N'01008', N'04010500', NULL, N'KASAMBHAI', N'2500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010406212036825', N'141300/47/2014/00005', N'02', 1, 1, N'1', 46, N'1', 53, N'24001073', N'3002207201424001073001', N'22/07/2014 17:00:53', N'22/07/2014 17:02:36', N'3012207201424001073406', N'22/07/2014 17:05:32', N'22/07/2014 17:06:13', N'', N'', N'', N'3032207201424001073001', N'31/07/2014 17:11:32', N'31/07/2014 17:12:17', N'1000', N'MEDICAL', N'5000', 5, N'9000', N'9000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, 1, N' Version:2.6.0.4 Released On:17/01/2014', 71, N'31/07/2014 17:23:46', N'01004', N'01004', N'04010300', NULL, N'NAREDRABHAI', N'5000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010406212036825', N'141300/47/2014/00005', N'02', 1, 1, N'1', 46, N'1', 53, N'24001073', N'3002207201424001073001', N'22/07/2014 17:00:53', N'22/07/2014 17:02:36', N'3012207201424001073406', N'22/07/2014 17:05:32', N'22/07/2014 17:06:13', N'', N'', N'', N'3032207201424001073001', N'31/07/2014 17:11:32', N'31/07/2014 17:12:17', N'1000', N'MEDICAL', N'5000', 5, N'9000', N'9000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 72, N'31/07/2014 17:23:46', N'01004', N'01004', N'04010300', NULL, NULL, N'5000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010504212000459', N'141300/47/2014/00005', N'02', 1, 2, N'2', 56, N'2', 60, N'24001084', N'3000507201424001084001', N'05/07/2014 13:56:28', N'05/07/2014 13:58:51', N'301050720142400108422', N'05/07/2014 14:03:31', N'05/07/2014 14:05:36', N'', N'', N'', N'3030507201424001084001', N'11/07/2014 12:23:50', N'11/07/2014 12:25:09', N'84', N'ORTHOPAEDIC', N'7125', 4, N'16625', N'7125', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 79, N'11/07/2014 12:26:27', N'01005', N'100050035', N'00038600', NULL, N'MANGAL', N'9500', N'Fracture - Ulna Internal Fixation', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010504212000459', N'141300/47/2014/00005', N'02', 1, 2, N'2', 56, N'2', 60, N'24001084', N'3000507201424001084001', N'05/07/2014 13:56:28', N'05/07/2014 13:58:51', N'301050720142400108422', N'05/07/2014 14:03:31', N'05/07/2014 14:05:36', N'', N'', N'', N'3030507201424001084001', N'11/07/2014 12:23:50', N'11/07/2014 12:25:09', N'81', N'ORTHOPAEDIC', N'9500', 2, N'16625', N'9500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 80, N'11/07/2014 12:26:27', N'01005', N'100050035', N'00038600', NULL, N'MANGAL', N'9500', N'Fracture - Radius Internal Fixation', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'1875', 2, N'4375', N'1875', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 4, N' Version:2.6.0.4 Released On:17/01/2014', 102, N'17/07/2014 11:38:31', N'01002', N'100020046', N'00016000', NULL, N'JETHA', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'2500', 2, N'4375', N'2500', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 103, N'17/07/2014 11:38:31', N'01002', N'100020046', N'00016000', NULL, N'GORE', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'1875', 2, N'4375', N'1875', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 104, N'17/07/2014 11:38:31', N'01002', N'100020046', N'00016000', NULL, N'GORE', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'2500', 2, N'4375', N'2500', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 4, N' Version:2.6.0.4 Released On:17/01/2014', 105, N'17/07/2014 11:38:31', N'01002', N'100020046', N'00016000', NULL, N'JETHA', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'1875', 2, N'4375', N'1875', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 4, N' Version:2.6.0.4 Released On:17/01/2014', 106, N'17/07/2014 11:38:40', N'01002', N'100020046', N'00016000', NULL, N'JETHA', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'2500', 2, N'4375', N'2500', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 107, N'17/07/2014 11:38:40', N'01002', N'100020046', N'00016000', NULL, N'GORE', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'1875', 2, N'4375', N'1875', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 108, N'17/07/2014 11:38:40', N'01002', N'100020046', N'00016000', NULL, N'GORE', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010204912001286', N'141300/47/2014/00005', N'02', 1, 2, N'2', 40, N'2', 32, N'24001093', N'3001407201424001093001', N'14/07/2014 11:30:44', N'14/07/2014 11:34:57', N'30114072014240010932', N'14/07/2014 11:43:13', N'14/07/2014 11:46:24', N'', N'', N'', N'3031407201424001093001', N'15/07/2014 12:17:59', N'15/07/2014 12:20:40', N'31', N'GYNAECOLOGY', N'2500', 2, N'4375', N'2500', N'Y', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 4, N' Version:2.6.0.4 Released On:17/01/2014', 109, N'17/07/2014 11:38:40', N'01002', N'100020046', N'00016000', NULL, N'JETHA', N'2500', N'Normal Delivery', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010805412000287', N'141300/47/2014/00005', N'02', 1, 1, N'2', 65, N'2', 90, N'24001114', N'3002106201424001114001', N'21/06/2014 12:59:58', N'21/06/2014 13:03:34', N'3012106201424001114224', N'21/06/2014 13:04:29', N'21/06/2014 13:06:03', N'', N'', N'', N'3032106201424001114001', N'02/07/2014 11:29:26', N'02/07/2014 11:32:10', N'1000', N'MEDICAL', N'7000', 7, N'11000', N'11000', N'N', N'', N'', N'', N'', N'4497', N'02/07/2014 11:32:10', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 128, N'02/07/2014 11:33:22', N'01008', N'100080042', N'00085800', N'7000', NULL, N'7000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010805412000287', N'141300/47/2014/00005', N'02', 1, 1, N'2', 65, N'2', 90, N'24001114', N'3002106201424001114001', N'21/06/2014 12:59:58', N'21/06/2014 13:03:34', N'3012106201424001114224', N'21/06/2014 13:04:29', N'21/06/2014 13:06:03', N'', N'', N'', N'3032106201424001114001', N'02/07/2014 11:29:26', N'02/07/2014 11:32:10', N'1000', N'MEDICAL', N'7000', 7, N'11000', N'11000', N'N', N'', N'', N'', N'', N'4497', N'02/07/2014 11:32:10', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 129, N'02/07/2014 11:33:57', N'01008', N'100080042', N'00085800', N'7000', NULL, N'7000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010805412000287', N'141300/47/2014/00005', N'02', 1, 1, N'2', 65, N'2', 90, N'24001114', N'3002106201424001114001', N'21/06/2014 12:59:58', N'21/06/2014 13:03:34', N'3012106201424001114224', N'21/06/2014 13:04:29', N'21/06/2014 13:06:03', N'', N'', N'', N'3032106201424001114001', N'02/07/2014 11:29:26', N'02/07/2014 11:32:10', N'1000', N'MEDICAL', N'7000', 7, N'11000', N'11000', N'N', N'', N'', N'', N'', N'4497', N'02/07/2014 11:32:10', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 130, N'02/07/2014 11:34:06', N'01008', N'100080042', N'00085800', N'7000', NULL, N'7000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212016863', N'141300/47/2014/00005', N'02', 1, 2, N'2', 42, N'2', 55, N'24001114', N'3000207201424001114001', N'02/07/2014 10:31:38', N'02/07/2014 10:32:36', N'3010207201424001114226', N'02/07/2014 10:34:12', N'02/07/2014 10:35:04', N'', N'', N'', N'3030207201424001114001', N'08/07/2014 10:05:36', N'08/07/2014 10:08:08', N'1000', N'MEDICAL', N'4000', 4, N'6000', N'6000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 134, N'08/07/2014 10:08:59', N'01008', N'01008', N'04010500', N'7000', N'rehmatbai', N'4000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010905912001349', N'141300/47/2014/00005', N'02', 1, 9, N'2', 29, N'2', 30, N'24001114', N'3000807201424001114002', N'08/07/2014 12:02:09', N'08/07/2014 12:02:43', N'3010807201424001114229', N'08/07/2014 12:03:36', N'08/07/2014 12:04:19', N'', N'', N'', N'3030807201424001114002', N'11/07/2014 14:31:20', N'11/07/2014 14:32:16', N'1000', N'MEDICAL', N'2000', 2, N'3000', N'3000', N'N', N'', N'', N'', N'', N'4523', N'11/07/2014 14:32:16', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 139, N'11/07/2014 14:33:39', N'01009', N'100090043', N'00090500', N'2000', NULL, N'2000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212019818', N'141300/47/2014/00005', N'02', 1, 1, N'1', 46, N'1', 55, N'24001114', N'3000707201424001114001', N'07/07/2014 12:58:01', N'07/07/2014 13:00:44', N'3010807201424001114227', N'08/07/2014 09:54:19', N'08/07/2014 09:59:44', N'', N'', N'', N'3030707201424001114001', N'14/07/2014 10:41:57', N'14/07/2014 10:43:02', N'999', N'MEDICAL', N'2500', 5, N'3000', N'3000', N'N', N'', N'', N'', N'', N'4532', N'14/07/2014 10:43:02', N'N', N'', 7, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 140, N'14/07/2014 11:20:43', N'01008', N'01008', N'04010500', N'2500', NULL, N'2500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010809212009252', N'141300/47/2014/00005', N'02', 1, 2, N'2', 43, N'2', 40, N'24001114', N'3000807201424001114001', N'08/07/2014 10:15:52', N'08/07/2014 10:17:07', N'3010807201424001114228', N'08/07/2014 10:18:38', N'08/07/2014 10:20:35', N'', N'', N'', N'3030807201424001114001', N'14/07/2014 11:22:18', N'14/07/2014 11:26:40', N'1000', N'MEDICAL', N'3000', 3, N'6000', N'6000', N'N', N'', N'', N'', N'', N'4534', N'14/07/2014 11:26:40', N'N', N'', 4, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 141, N'14/07/2014 11:27:08', N'01008', N'01008', N'04010500', N'3000', NULL, N'3000', N'General Ward- ICU', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'01', N'Kachchh', N'24010603812000501', N'141300/47/2014/00005', N'02', 1, 1, N'1', 33, N'1', 40, N'24001114', N'3001107201424001114001', N'11/07/2014 11:05:21', N'11/07/2014 11:08:07', N'3011107201424001114230', N'11/07/2014 11:10:46', N'11/07/2014 11:11:52', N'', N'', N'', N'3031107201424001114001', N'15/07/2014 11:21:06', N'15/07/2014 12:32:42', N'76', N'GENERAL SURGERY', N'11250', 2, N'11250', N'11250', N'N', N'', N'', N'', N'', N'4543', N'15/07/2014 12:32:42', N'N', N'', 3, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 142, N'15/07/2014 12:33:39', N'01006', N'100060026', N'00054000', N'11250', NULL, N'11250', N'Fissurectomy and Haemorrhoidectomy', N'5')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'17', N'Panch Mahals', N'24171600112011455', N'TAGIRSB0000035000000', N'15', 1, 1, N'1', 43, N'1', 40, N'24001116', N'3001007201424001116001', N'08/07/2014 11:42:24', N'10/07/2014 11:50:28', N'301100720142400111611', N'10/07/2014 12:05:52', N'10/07/2014 12:07:49', N'', N'', N'', N'3031007201424001116001', N'17/07/2014 09:31:33', N'17/07/2014 09:41:37', N'999', N'MEDICAL', N'500', 1, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 153, N'17/07/2014 09:43:45', N'17010', N'17010022', N'01256000', N'500', NULL, N'500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'17', N'Panch Mahals', N'24171600112011455', N'TAGIRSB0000035000000', N'15', 1, 1, N'1', 43, N'1', 40, N'24001116', N'3001007201424001116001', N'08/07/2014 11:42:24', N'10/07/2014 11:50:28', N'301100720142400111611', N'10/07/2014 12:05:52', N'10/07/2014 12:07:49', N'', N'', N'', N'3031007201424001116001', N'17/07/2014 09:31:33', N'17/07/2014 09:41:37', N'999', N'MEDICAL', N'500', 1, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, 2, N' Version:2.6.0.4 Released On:17/01/2014', 154, N'17/07/2014 09:43:45', N'17010', N'17010022', N'01256000', N'500', N'USHA BEN', N'500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'17', N'Panch Mahals', N'24171600112011455', N'TAGIRSB0000035000000', N'15', 1, 1, N'1', 43, N'1', 40, N'24001116', N'3001007201424001116001', N'08/07/2014 11:42:24', N'10/07/2014 11:50:28', N'301100720142400111611', N'10/07/2014 12:05:52', N'10/07/2014 12:07:49', N'', N'', N'', N'3031007201424001116001', N'17/07/2014 09:31:33', N'17/07/2014 09:41:37', N'999', N'MEDICAL', N'500', 1, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, NULL, N' Version:2.6.0.4 Released On:17/01/2014', 155, N'17/07/2014 09:44:55', N'17010', N'17010022', N'01256000', N'500', NULL, N'500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'17', N'Panch Mahals', N'24171600112011455', N'TAGIRSB0000035000000', N'15', 1, 1, N'1', 43, N'1', 40, N'24001116', N'3001007201424001116001', N'08/07/2014 11:42:24', N'10/07/2014 11:50:28', N'301100720142400111611', N'10/07/2014 12:05:52', N'10/07/2014 12:07:49', N'', N'', N'', N'3031007201424001116001', N'17/07/2014 09:31:33', N'17/07/2014 09:41:37', N'999', N'MEDICAL', N'500', 1, N'3500', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', 1, 2, N' Version:2.6.0.4 Released On:17/01/2014', 156, N'17/07/2014 09:44:55', N'17010', N'17010022', N'01256000', N'500', N'USHA BEN', N'500', N'General Ward- Unspecified', N'18')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020801112000729', N'TAGIRSB0000041000000', N'15', 1, 2, N'2', 34, N'2', 38, N'24002118', N'3000407201424002118001', N'04/07/2014 14:18:25', N'04/07/2014 14:19:26', N'301040720142400211823', N'04/07/2014 14:28:56', N'04/07/2014 14:32:53', N'', N'', N'', N'3030407201424002118001', N'04/07/2014 18:09:01', N'04/07/2014 18:10:12', N'36', N'GYNAECOLOGY', N'3500', NULL, N'5843', N'3500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 162, N'04/07/2014 18:25:17', N'02008', N'02008007', N'00174600', N'5843', N'BABUJI', N'3500', N'D&C ( dilatation & Curretage) upto 12 wks', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020801112000729', N'TAGIRSB0000041000000', N'15', 1, 2, N'2', 34, N'2', 38, N'24002118', N'3000407201424002118001', N'04/07/2014 14:18:25', N'04/07/2014 14:19:26', N'301040720142400211823', N'04/07/2014 14:28:56', N'04/07/2014 14:32:53', N'', N'', N'', N'3030407201424002118001', N'04/07/2014 18:09:01', N'04/07/2014 18:10:12', N'27', N'GYNAECOLOGY', N'2343', NULL, N'5843', N'2343', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 163, N'04/07/2014 18:25:17', N'02008', N'02008007', N'00174600', N'5843', N'BABUJI', N'3125', N'Vaginal Tear -Repair', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020802312004809', N'TAGIRSB0000041000000', N'15', 1, 10, N'2', 21, N'2', 24, N'24002118', N'3000607201424002118001', N'06/07/2014 11:58:00', N'06/07/2014 11:59:09', N'301060720142400211824', N'06/07/2014 12:03:20', N'06/07/2014 12:05:38', N'', N'', N'', N'3030607201424002118001', N'10/07/2014 10:27:12', N'10/07/2014 10:28:30', N'51', N'GYNAECOLOGY', N'14000', 4, N'14000', N'14000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 3, N' Version:2.6.0.4 Released On:17/01/2014', 166, N'10/07/2014 10:35:45', N'02008', N'02008018', N'00176300', N'14000', N'CHETAN', N'14000', N'Rupture Uterus , closer and repoar with tubal ligation', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020800112045229', N'TAGIRSB0000041000000', N'15', 1, 2, N'2', 41, N'2', 42, N'24002118', N'3002707201424002118001', N'27/07/2014 13:28:43', N'27/07/2014 13:30:04', N'301270720142400211826', N'27/07/2014 13:38:39', N'27/07/2014 13:41:15', N'', N'', N'', N'3032707201424002118001', N'28/07/2014 13:29:02', N'28/07/2014 13:30:08', N'4', N'GYNAECOLOGY', N'3000', 1, N'4875', N'3000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 170, N'28/07/2014 13:37:19', N'02008', N'02008', N'04020400', N'4875', N'MUKESHBHAI', N'3000', N'Cervical Polypectomy', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020800112045229', N'TAGIRSB0000041000000', N'15', 1, 2, N'2', 41, N'2', 42, N'24002118', N'3002707201424002118001', N'27/07/2014 13:28:43', N'27/07/2014 13:30:04', N'301270720142400211826', N'27/07/2014 13:38:39', N'27/07/2014 13:41:15', N'', N'', N'', N'3032707201424002118001', N'28/07/2014 13:29:02', N'28/07/2014 13:30:08', N'11', N'GYNAECOLOGY', N'1875', NULL, N'4875', N'1875', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 171, N'28/07/2014 13:37:19', N'02008', N'02008', N'04020400', N'4875', N'MUKESHBHAI', N'2500', N'Fractional Curretage', N'6')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020604812002679', N'TAGIRSB0000041000000', N'15', 1, 1, N'1', 41, N'1', 50, N'24002121', N'3002506201424002121001', N'25/06/2014 12:53:52', N'25/06/2014 12:54:31', N'301250620142400212191', N'25/06/2014 13:16:11', N'25/06/2014 13:20:03', N'', N'', N'', N'3032506201424002121001', N'01/07/2014 13:45:37', N'01/07/2014 13:51:40', N'103', N'ORTHOPAEDIC', N'16000', 6, N'16000', N'16000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 172, N'01/07/2014 13:52:32', N'02006', N'02006016', N'00158800', N'16000', N'BHIKHAJI', N'16000', N'Open Reduction Internal Fixation (Large Bone)', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020800112011507', N'TAGIRSB0000041000000', N'15', 1, 1, N'1', 56, N'1', 55, N'24002121', N'3002606201424002121001', N'26/06/2014 19:46:06', N'26/06/2014 19:46:34', N'301260620142400212192', N'26/06/2014 19:49:44', N'26/06/2014 19:51:05', N'', N'', N'', N'3032606201424002121001', N'01/07/2014 20:07:00', N'01/07/2014 20:13:23', N'11', N'COMBINED PACKAGES', N'20000', NULL, N'20000', N'20000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 173, N'01/07/2014 20:14:04', N'02008', N'02008', N'04020400', N'20000', N'CHANPABEN', N'20000', N'Fracture - Fibula Internal Fixation + Fracture - TIBIA Internal Fixation', N'99')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020800212000020', N'TAGIRSB0000041000000', N'15', 1, 3, N'1', 11, N'1', 11, N'24002121', N'3003006201424002121001', N'30/06/2014 12:18:01', N'30/06/2014 12:22:05', N'301300620142400212193', N'30/06/2014 12:37:35', N'30/06/2014 12:41:06', N'', N'', N'', N'3033006201424002121001', N'03/07/2014 12:58:24', N'03/07/2014 13:00:26', N'40', N'ORTHOPAEDIC', N'12000', 3, N'13500', N'12000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 3, N' Version:2.6.0.4 Released On:17/01/2014', 176, N'03/07/2014 13:03:12', N'02008', N'02008002', N'00176200', N'13500', N'BHAVIK', N'12000', N'Closed Reduction and Internal Fixation with K wire', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020800212000020', N'TAGIRSB0000041000000', N'15', 1, 3, N'1', 11, N'1', 11, N'24002121', N'3003006201424002121001', N'30/06/2014 12:18:01', N'30/06/2014 12:22:05', N'301300620142400212193', N'30/06/2014 12:37:35', N'30/06/2014 12:41:06', N'', N'', N'', N'3033006201424002121001', N'03/07/2014 12:58:24', N'03/07/2014 13:00:26', N'140', N'ORTHOPAEDIC', N'1500', NULL, N'13500', N'1500', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 3, N' Version:2.6.0.4 Released On:17/01/2014', 177, N'03/07/2014 13:03:12', N'02008', N'02008002', N'00176200', N'13500', N'BHAVIK', N'2000', N'Close Reduction of Fractures of Limb & P.O.P.', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020805112000718', N'TAGIRSB0000041000000', N'15', 1, 3, N'1', 50, N'1', 55, N'24002121', N'3000107201424002121001', N'01/07/2014 19:30:01', N'01/07/2014 19:48:04', N'301010720142400212194', N'01/07/2014 19:50:31', N'01/07/2014 19:52:24', N'', N'', N'', N'3030107201424002121001', N'07/07/2014 19:56:52', N'07/07/2014 19:58:11', N'103', N'ORTHOPAEDIC', N'16000', 6, N'25000', N'16000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 178, N'07/07/2014 19:59:31', N'02008', N'02008040', N'00181700', N'25000', N'NARESHBHAI', N'16000', N'Open Reduction Internal Fixation (Large Bone)', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020805112000718', N'TAGIRSB0000041000000', N'15', 1, 3, N'1', 50, N'1', 55, N'24002121', N'3000107201424002121001', N'01/07/2014 19:30:01', N'01/07/2014 19:48:04', N'301010720142400212194', N'01/07/2014 19:50:31', N'01/07/2014 19:52:24', N'', N'', N'', N'3030107201424002121001', N'07/07/2014 19:56:52', N'07/07/2014 19:58:11', N'38', N'ORTHOPAEDIC', N'9000', 3, N'25000', N'9000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 1, N' Version:2.6.0.4 Released On:17/01/2014', 179, N'07/07/2014 19:59:31', N'02008', N'02008040', N'00181700', N'25000', N'NARESHBHAI', N'12000', N'Closed Interlocking Tibia + Orif of Fracture Fixation', N'11')
INSERT [dbo].[testing] ([MemberScode], [MemberS], [MemberDCode], [MemberD], [IDN], [Number], [CCode], [HMID], [PatientID], [PatientCardGender], [PatientCardAge], [PatientGender], [PatientAge], [HlCode], [RegistrationNo], [RegistrationUserDate], [RegistrationSystemDate], [BlockingInvoiceNo], [BlockingUserDate], [BlockingSystemDate], [UnblockingInvoiceNo], [UnblockingDesc], [UnblockingSystemDate], [DischargeInvoiceNo], [DischargeUserDate], [DischargeSystemDate], [PackageCode], [ProcedureName], [PackageCost], [NoofDays], [AmoutBlocked], [AmoutClaimed], [TMode], [UnspecifiedAuthCode], [UnspecifiedAuthDate], [BCPAuthorizationCode], [BCPAuthorizationDate], [FPOverideCode], [FPOverideDate], [Mortality], [MortalitySummary], [FPFailureCount], [VerifiedMemberID], [Version], [ID], [UploadDateTime], [BlockCode], [PanchayatCode], [VillageCode], [TotalAmtBlockedOnCard], [VerifiedMemberName], [OriginalPackageCost], [PackageName], [ProcedureCode]) VALUES (N'24', N'GUJARAT', N'02', N'Banas Kantha', N'24020705812002681', N'TAGIRSB0000041000000', N'15', 1, 2, N'2', 50, N'2', 70, N'24002121', N'3000807201424002121001', N'08/07/2014 14:02:09', N'08/07/2014 14:02:36', N'301080720142400212195', N'08/07/2014 14:03:56', N'08/07/2014 14:04:37', N'', N'', N'', N'3030807201424002121001', N'14/07/2014 14:07:19', N'14/07/2014 14:10:53', N'103', N'ORTHOPAEDIC', N'16000', 6, N'16000', N'16000', N'N', N'', N'', N'', N'', N'', N'', N'N', N'', NULL, 2, N' Version:2.6.0.4 Released On:17/01/2014', 183, N'14/07/2014 14:11:43', N'02007', N'02007046', N'00163000', N'16000', N'JUBEDABEN', N'16000', N'Open Reduction Internal Fixation (Large Bone)', N'11')
SET IDENTITY_INSERT [dbo].[testing] OFF


how to select the latest record on the basis of IDN....
Please help

pankajrocks

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-18 : 07:57:40
I guess it depends. What is IDN? Also, how do I know which one is the latest?


Normally I'd do something like:


select top(1) ...
from ...
order by ...


top(1) gets you the first row that is returned after the order by clause. If that's a date, then "ORDER BY myDate Desc" will usually do the trick.
Go to Top of Page

pankaj2910
Starting Member

31 Posts

Posted - 2014-08-18 : 08:14:40
Its a complicate so that I need help...IDN is the Unique number for program

pankajrocks
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-18 : 08:33:03
Ok, so tell me, if you were reading a list on paper of ten rows of this data in no particular order, how would you know which one is the latest? Is there a date or sequence number or something like that you would look for?
Go to Top of Page

pankaj2910
Starting Member

31 Posts

Posted - 2014-08-18 : 09:04:29
Hey an identity field is there. One thing I also mention in that, these are the duplicate records except two fields if you seen, one is FPfailurecount & ID(identity field). I want the last record of that particular date to consider the discharge date.


pankajrocks
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-08-18 : 09:14:28
select *
from (select *, row_number() over (partition by idn order by uploadeddatetime desc) AS rn from dbo.testing) AS d
where rn = 1;


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page
   

- Advertisement -