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
 How to move duplicate data into other tble

Author  Topic 

pankaj2910
Starting Member

31 Posts
Posted - 2013-12-10 : 19:47:44
We need to move duplicate data from this sheet to other table also having issue that sometime verifiedmemberID is null as well as verifiermembername is null and also having the values in BCP authorisationcode as well as FPoveridecode but transactionmode/bcpmode is 'n' and also having condition that transactionmode/bcpmode is 'y' but bcpauthorisationcode is blank.
Please help me to design the query on followoing conditions.

MemberStatecode MemberDistrictCode URN CompanyCode HeadMemberID HeadMemberName PatientID PatientName PatientGender PatientAge TerminalID HospitalCode RegistrationNo BlockingUserDate UnblockingInvoiceNo DischargeInvoiceNo DischargeDesc DischargeUserDate AmoutClaimed TransactionMode/BCPMode UnspecifiedAuthCode UnspecifiedAuthDate BCPAuthorizationCode BCPAuthorizationDate FPOverideCode FPOverideDate CSN FPFailureCount VerifiedMemberID Version UploadDateTime TransactionCode VerifiedMemberName ProcedureCode
09 17 09170105312000291 14 1 BABLU 2 sarita 1 30 091503 09015040 3001204201309015040001 12/04/2013 14:28:46 3031204201309015040001 FTP WITH L.P. & CYSTOCEAL 16/04/2013 11:33:45 6000 N 06001705190000000109AB68 NULL 2 Version:2.3.3 Released On: 04/02/2013 01/05/2013 12:15:51 303 sarita 6
09 17 09170105312000291 14 1 BABLU 2 sarita 1 30 091503 09015040 3001204201309015040001 12/04/2013 14:28:46 3031204201309015040001 FTP WITH L.P. & CYSTOCEAL 16/04/2013 11:33:45 7500 N 06001705190000000109AB68 NULL 2 Version:2.3.3 Released On: 04/02/2013 01/05/2013 12:15:51 303 sarita 6
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 60 160110 16001020 3002905201316001020007 NULL N 060019080F0000000005495F22562265 1 NULL Version:2.3.3 Released On: 04/02/2013 29/05/2013 15:15:11 300 NULL NULL
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 60 160110 16001020 3002905201316001020007 29/05/2013 15:54:31 500 N 060019080F0000000005495F22562265 2 NULL Version:2.3.3 Released On: 04/02/2013 29/05/2013 16:46:35 301 NULL 18
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 60 160110 16001020 3002905201316001020007 29/05/2013 15:54:31 500 N 060019080F0000000005495F22562265 2 2 Version:2.3.3 Released On: 04/02/2013 29/05/2013 16:46:35 301 KAJAL RANI DEB 18
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 65 160113 16001027 3001305201316001027006 13/05/2013 14:20:25 1000 N 060019080F0000000005495F22562265 4 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 16:45:52 301 KAJAL RANI DEB 18
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 65 160113 16001027 3001305201316001027006 13/05/2013 14:20:25 1000 N 060019080F0000000005495F22562265 4 NULL Version:2.3.3 Released On: 04/02/2013 13/05/2013 16:45:52 301 NULL 18
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 65 160113 16001027 3001305201316001027006 13/05/2013 14:20:25 3031305201316001027006 pain 14/05/2013 16:38:57 500 N 060019080F0000000005495F22562265 NULL 2 Version:2.3.3 Released On: 04/02/2013 14/05/2013 16:40:13 303 KAJAL RANI DEB 18
16 05 16050500112050776 14 1 PULIN DEB 1 PULIN DEB 1 60 160110 16001020 3002905201316001020007 29/05/2013 15:54:31 3032905201316001020007 fever 01/06/2013 12:58:16 1500 Y 060019080F0000000005495F22562265 NULL 2 Version:2.3.3 Released On: 04/02/2013 07/06/2013 13:22:14 303 KAJAL RANI DEB 18
09 66 09660512212000415 02 1 JOGINDAR MORYA 1 JOGINDAR MORYA 1 35 01 09066056 3000204201309066056001 02/04/2013 12:55:00 3020204201309066056001 17000 N 060019030106000000013F9322252234 NULL 1 Version:2.3 Released On: 13/12/2012 03/04/2013 15:18:10 302 JOGINDAR MORYA 7
09 66 09660512212000415 02 1 JOGINDAR MORYA 1 JOGINDAR MORYA 1 35 01 09066056 3000204201309066056001 02/04/2013 13:12:56 3020204201309066056001 9187 N 060019030106000000013F9322252234 NULL 1 Version:2.3 Released On: 13/12/2012 03/04/2013 15:18:10 302 JOGINDAR MORYA 7
09 66 09660512212000415 02 1 JOGINDAR MORYA 1 JOGINDAR MORYA 1 35 01 09066056 3000204201309066056001 02/04/2013 13:43:48 3030204201309066056001 ot 03/04/2013 08:42:17 17000 N 060019030106000000013F9322252234 NULL 1 Version:2.3 Released On: 13/12/2012 03/04/2013 15:18:10 303 JOGINDAR MORYA 7
09 66 09660512212000415 02 1 JOGINDAR MORYA 2 SHIMLA DEVI 2 32 01 09066056 3000404201309066056002 04/04/2013 18:38:00 7500 N 060019030106000000013F9322252234 NULL 2 Version:2.3.3 Released On: 04/02/2013 05/04/2013 06:41:28 301 SHIMLA DEVI 8
09 66 09660512212000415 02 1 JOGINDAR MORYA 2 SHIMLA DEVI 2 32 01 09066056 3000404201309066056002 04/04/2013 18:40:43 5250 N 060019030106000000013F9322252234 NULL 2 Version:2.3.3 Released On: 04/02/2013 05/04/2013 06:41:28 301 SHIMLA DEVI 8
09 66 09660512212000415 02 1 JOGINDAR MORYA 2 SHIMLA DEVI 2 32 01 09066056 3000404201309066056002 04/04/2013 18:38:00 3030404201309066056002 ot 05/04/2013 06:50:47 7500 N 060019030106000000013F9322252234 NULL 2 Version:2.3.3 Released On: 04/02/2013 05/04/2013 06:56:54 303 SHIMLA DEVI 8
09 66 09660512212000415 02 1 JOGINDAR MORYA 2 SHIMLA DEVI 2 32 01 09066056 3000404201309066056002 04/04/2013 18:40:43 3030404201309066056002 ot 05/04/2013 06:50:47 5250 N 060019030106000000013F9322252234 NULL 2 Version:2.3.3 Released On: 04/02/2013 05/04/2013 06:56:54 303 SHIMLA DEVI 8
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 1 F LALTHUAMLUAIA 1 73 1506013 15006013 3000503201315006013014 14/01/2013 12:52:39 3030503201315006013014 General Ward- Unspecified 24/01/2013 12:55:59 7000 N 0600190D0B0700000002516222672276 1 2 Version:2.3.3 Released On: 04/02/2013 05/03/2013 15:22:49 303 K ROZAMI 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 1 F LALTHUAMLUAIA 1 73 1506013 15006013 3000503201315006013014 14/01/2013 12:52:39 3030503201315006013014 General Ward- Unspecified 24/01/2013 12:55:59 7000 N 0600190D0B0700000002516222672276 1 NULL Version:2.3.3 Released On: 04/02/2013 05/03/2013 15:22:49 303 NULL 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 32 1506013 15006013 3000503201315006013015 05/03/2013 13:02:31 7000 N 0600190D0B0700000002516222672276 1 NULL Version:2.3.3 Released On: 04/02/2013 05/03/2013 15:22:49 301 NULL 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 32 1506013 15006013 3000503201315006013015 05/03/2013 13:02:31 7000 N 0600190D0B0700000002516222672276 1 2 Version:2.3.3 Released On: 04/02/2013 05/03/2013 15:22:49 301 K ROZAMI 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 32 1506013 15006013 3000503201315006013015 05/03/2013 13:02:31 3030503201315006013015 Plasmodium falciparum malaria 15/03/2013 12:12:28 7000 Y 0600190D0B0700000002516222672276 1 NULL Version:2.3.3 Released On: 04/02/2013 16/03/2013 13:43:34 303 NULL 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 32 1506013 15006013 3000503201315006013015 05/03/2013 13:02:31 3030503201315006013015 Plasmodium falciparum malaria 15/03/2013 12:12:28 7000 Y 0600190D0B0700000002516222672276 1 2 Version:2.3.3 Released On: 04/02/2013 16/03/2013 13:43:34 303 K ROZAMI 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 30 1506001 15006014 3001903201315006014001 19/03/2013 10:28:40 10500 N 0600190D0B0700000002516222672276 NULL 4 Version:2.3.3 Released On: 04/02/2013 19/03/2013 10:30:05 301 F LALROHLIMI 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 4 F LALROHLIMI 2 30 1506001 15006014 3001903201315006014001 19/03/2013 10:28:40 3031903201315006014001 Malaria PF with HTN 26/03/2013 10:52:57 4900 N 0600190D0B0700000002516222672276 NULL 4 Version:2.3.3 Released On: 04/02/2013 26/03/2013 10:54:50 303 F LALROHLIMI 18
15 06 15062204812000747 04 1 F LALTHUAMLUAIA 1 F LALTHUAMLUAIA 1 73 1506013 15006013 3001805201315006013004 08/05/2013 11:13:19 3031805201315006013004 Hypertension 18/05/2013 11:15:02 7000 N 0600190D0B0700000002516222672276 NULL 1 Version:2.3.3 Released On: 04/02/2013 18/05/2013 11:28:45 303 F LALTHUAMLUAIA 18
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3000305201315003044005 03/05/2013 10:52:41 3030305201315003044005 ca.oesophagus 07/05/2013 12:00:22 2800 Y 141E0642771300002A00000011271600 2 1 Version:2.3.3 Released On: 04/02/2013 07/05/2013 14:24:35 303 DARNEIHKUNGI 18
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3000305201315003044005 03/05/2013 10:52:41 3030305201315003044005 ca.oesophagus 07/05/2013 12:00:22 2800 Y 141E0642771300002A00000011271600 2 NULL Version:2.3.3 Released On: 04/02/2013 07/05/2013 14:24:35 303 NULL 18
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3000905201315003044002 09/05/2013 11:13:29 3030905201315003044002 ca.oesophagus 09/05/2013 11:15:36 1800 N 141E0642771300002A00000011271600 NULL 1 Version:2.3.3 Released On: 04/02/2013 09/05/2013 15:39:10 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3000905201315003044002 09/05/2013 11:13:29 3030905201315003044002 ca.oesophagus 09/05/2013 11:15:36 900 N 141E0642771300002A00000011271600 NULL 1 Version:2.3.3 Released On: 04/02/2013 09/05/2013 15:39:10 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3001005201315003044008 10/05/2013 11:48:12 3031005201315003044008 Ca. Oesaphagus 10/05/2013 11:49:51 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 10/05/2013 14:17:59 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3001005201315003044008 10/05/2013 11:48:12 3031005201315003044008 Ca. Oesaphagus 10/05/2013 11:49:51 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 10/05/2013 14:17:59 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002005201315003028001 20/05/2013 15:27:03 3032005201315003028001 ca oesophagus 20/05/2013 15:34:21 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 20/05/2013 15:36:25 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002005201315003028001 20/05/2013 15:27:03 3032005201315003028001 ca oesophagus 20/05/2013 15:34:21 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 20/05/2013 15:36:25 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002105201315003028001 21/05/2013 11:11:55 3032105201315003028001 ca oesophagus 21/05/2013 11:14:23 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 21/05/2013 11:16:06 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002105201315003028001 21/05/2013 11:11:55 3032105201315003028001 ca oesophagus 21/05/2013 11:14:23 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 21/05/2013 11:16:06 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002205201315003028001 22/05/2013 12:26:24 3032205201315003028001 ca oesophagus 22/05/2013 12:28:08 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 22/05/2013 12:29:35 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002205201315003028001 22/05/2013 12:26:24 3032205201315003028001 ca oesophagus 22/05/2013 12:28:08 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 22/05/2013 12:29:35 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002305201315003028001 23/05/2013 11:49:34 3032305201315003028001 ca oesophagus 23/05/2013 11:51:29 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 23/05/2013 11:53:08 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002305201315003028001 23/05/2013 11:49:34 3032305201315003028001 ca oesophagus 23/05/2013 11:51:29 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 23/05/2013 11:53:08 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002405201315003028001 24/05/2013 11:57:51 3032405201315003028001 ca oesophagus 24/05/2013 11:59:33 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 24/05/2013 12:01:20 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002405201315003028001 24/05/2013 11:57:51 3032405201315003028001 ca oesophagus 24/05/2013 11:59:33 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 24/05/2013 12:01:20 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002505201315003028002 25/05/2013 12:04:00 3032505201315003028002 ca oesophagus 25/05/2013 12:05:39 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 25/05/2013 12:07:20 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002505201315003028002 25/05/2013 12:04:00 3032505201315003028002 ca oesophagus 25/05/2013 12:05:39 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 25/05/2013 12:07:20 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 44 1503002 15003044 3000305201315003044005 03/05/2013 10:52:41 2800 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 03/05/2013 14:28:44 301 NULL 18
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002705201315003028001 27/05/2013 11:34:11 3032705201315003028001 ca oesophagus 27/05/2013 11:35:54 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 27/05/2013 11:38:09 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002705201315003028001 27/05/2013 11:34:11 3032705201315003028001 ca oesophagus 27/05/2013 11:35:54 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 27/05/2013 11:38:09 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002905201315003028001 29/05/2013 11:22:02 3032905201315003028001 ca oesophagus 29/05/2013 11:24:14 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 29/05/2013 11:26:18 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002905201315003028001 29/05/2013 11:22:02 3032905201315003028001 ca oesophagus 29/05/2013 11:24:14 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 29/05/2013 11:26:18 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3003005201315003028001 30/05/2013 12:28:11 3033005201315003028001 ca oesophagus 30/05/2013 12:30:35 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 30/05/2013 12:32:34 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3003005201315003028001 30/05/2013 12:28:11 3033005201315003028001 ca oesophagus 30/05/2013 12:30:35 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 30/05/2013 12:32:34 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002805201315003028001 28/05/2013 12:16:37 3032805201315003028001 ca oesophagus 28/05/2013 12:18:17 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 28/05/2013 12:19:49 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3002805201315003028001 28/05/2013 12:16:37 3032805201315003028001 ca oesophagus 28/05/2013 12:18:17 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 28/05/2013 12:19:49 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000606201315003028001 06/06/2013 11:25:10 3030606201315003028001 ca oesophagus 06/06/2013 11:26:55 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 06/06/2013 11:28:41 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000606201315003028001 06/06/2013 11:25:10 3030606201315003028001 ca oesophagus 06/06/2013 11:26:55 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 06/06/2013 11:28:41 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000706201315003028001 07/06/2013 12:10:39 3030706201315003028001 ca oesophagus 07/06/2013 12:12:44 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 07/06/2013 12:14:48 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000706201315003028001 07/06/2013 12:10:39 3030706201315003028001 ca oesophagus 07/06/2013 12:12:44 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 07/06/2013 12:14:48 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000806201315003028001 08/06/2013 13:41:24 3030806201315003028001 ca oesophagus 08/06/2013 13:43:14 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 08/06/2013 13:45:00 303 NULL 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3000806201315003028001 08/06/2013 13:41:24 3030806201315003028001 ca oesophagus 08/06/2013 13:43:14 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 08/06/2013 13:45:00 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3001006201315003028001 10/06/2013 11:38:35 3031006201315003028001 ca oesophagus 10/06/2013 11:40:39 1200 N 141E0642771300002A00000011271600 1 1 Version:2.3.3 Released On: 04/02/2013 10/06/2013 11:42:29 303 DARNEIHKUNGI 15
15 03 15030301012001770 04 1 DARNEIHKUNGI 3 VANLALVENA 1 45 1503021 15003028 3001006201315003028001 10/06/2013 11:38:35 3031006201315003028001 ca oesophagus 10/06/2013 11:40:39 1200 N 141E0642771300002A00000011271600 1 NULL Version:2.3.3 Released On: 04/02/2013 10/06/2013 11:42:29 303 NULL 15
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3030305201322022002001 fevar 10/05/2013 16:24:15 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 10/05/2013 17:11:07 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 NULL Version:2.3.3 Released On: 04/02/2013 10/05/2013 17:11:07 303 NULL 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 1 Version:2.3.3 Released On: 04/02/2013 10/05/2013 17:11:07 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3030305201322022002001 fevar 10/05/2013 16:24:15 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:01:38 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 NULL Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:01:38 303 NULL 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 1 Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:01:38 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3030305201322022002001 fevar 10/05/2013 16:24:15 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 27/05/2013 10:34:15 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 NULL Version:2.3.3 Released On: 04/02/2013 27/05/2013 10:34:15 303 NULL 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 1 Version:2.3.3 Released On: 04/02/2013 27/05/2013 10:34:15 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3030305201322022002001 fevar 10/05/2013 16:24:15 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 31/05/2013 17:06:32 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 NULL Version:2.3.3 Released On: 04/02/2013 31/05/2013 17:06:32 303 NULL 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 1 Version:2.3.3 Released On: 04/02/2013 31/05/2013 17:06:32 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 03/05/2013 13:56:41 301 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3500 N 0600190A1F0800000008339322632272 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/05/2013 17:00:37 301 SURAJMANIYA 19
22 22 22220605112001125 02 1 BHARDWAJ 1 BHARDWAJ 1 33 12345 22022002 3000305201322022002001 03/05/2013 10:35:07 3030305201322022002001 fevar 10/05/2013 16:24:15 3500 N 0600190A1F0800000008339322632272 NULL 1 Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:03:30 303 BHARDWAJ 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 NULL Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:03:30 303 NULL 19
22 22 22220605112001125 02 1 BHARDWAJ 2 SURAJMANIYA 2 30 12345 22022002 3000405201322022002007 04/05/2013 14:09:00 3030405201322022002007 fevar 10/05/2013 16:27:42 3500 Y 0600190A1F0800000008339322632272 1 1 Version:2.3.3 Released On: 04/02/2013 16/05/2013 16:03:30 303 BHARDWAJ 19
09 74 09740200112061008 14 1 SALEEM 3 faryad 1 7 102103 09074005 3000204201309074005002 NULL N 141D47CADA1100004F00000011271600 4 NULL Version:2.3.3 Released On: 04/02/2013 02/04/2013 12:48:30 300 NULL NULL
09 74 09740200112061008 14 1 SALEEM 3 faryad 1 7 102103 09074005 3000204201309074005002 02/04/2013 13:08:06 3000 N 141D47CADA1100004F00000011271600 4 NULL Version:2.3.3 Released On: 04/02/2013 02/04/2013 14:02:13 301 NULL 18
09 74 09740200112061008 14 1 SALEEM 3 faryad 1 7 102103 09074005 3000204201309074005002 02/04/2013 13:08:06 3030204201309074005002 Pyrexia(UI)-Pneumonia?Pulm Kochs with Anaemia 12/04/2013 13:17:14 5000 N UPMSF140373 12/04/2013 13:18:55 141D47CADA1100004F00000011271600 13 NULL Version:2.3.3 Released On: 04/02/2013 12/04/2013 13:21:21 303 NULL 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 2500 N 141D47CADA1100004F00000011271600 9 NULL Version:2.3.3 Released On: 04/02/2013 17/04/2013 12:02:05 301 NULL 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 2500 N 141D47CADA1100004F00000011271600 9 2 Version:2.3.3 Released On: 04/02/2013 17/04/2013 12:02:05 301 Spouse of SALEEM 18
09 74 09740200112061008 14 1 SALEEM 3 faryad 1 7 102103 09074005 3000204201309074005002 02/04/2013 13:08:06 3030204201309074005002 Pyrexia(UI)-Pneumonia?Pulm Kochs with Anaemia 12/04/2013 13:17:14 5000 N UPMSF140373 12/04/2013 13:18:55 141D47CADA1100004F00000011271600 13 NULL Version:2.3.3 Released On: 04/02/2013 03/05/2013 16:07:44 303 NULL 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 3031704201309074005001 COPD with Pyrexia (PUO) 24/04/2013 10:17:57 3500 Y 141D47CADA1100004F00000011271600 5 NULL Version:2.3.3 Released On: 04/02/2013 24/04/2013 10:24:37 303 NULL 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 3031704201309074005001 COPD with Pyrexia (PUO) 24/04/2013 10:17:57 3500 Y 141D47CADA1100004F00000011271600 5 2 Version:2.3.3 Released On: 04/02/2013 24/04/2013 10:24:37 303 Spouse of SALEEM 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 3031704201309074005001 COPD with Pyrexia (PUO) 24/04/2013 10:17:57 3500 Y 141D47CADA1100004F00000011271600 5 NULL Version:2.3.3 Released On: 04/02/2013 03/05/2013 16:07:44 303 NULL 18
09 74 09740200112061008 14 1 SALEEM 4 alijan 1 75 102103 09074005 3001704201309074005001 17/04/2013 11:54:23 3031704201309074005001 COPD with Pyrexia (PUO) 24/04/2013 10:17:57 3500 Y 141D47CADA1100004F00000011271600 5 2 Version:2.3.3 Released On: 04/02/2013 03/05/2013 16:07:44 303 Spouse of SALEEM 18
22 02 22020319712000362 02 1 CHAMRA RAM 1 CHAMRA RAM 1 40 1 22002084 3002004201322002084002 20/04/2013 11:40:06 2250 N 060019080F00000001092F4A22572266 NULL 1 Version:2.3.3 Released On: 04/02/2013 20/04/2013 15:33:13 301 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 1 22002084 3002004201322002084003 20/04/2013 11:55:31 2250 N 060019080F00000001092F4A22572266 NULL 2 Version:2.3.3 Released On: 04/02/2013 20/04/2013 15:33:13 301 safiyano 18
22 02 22020319712000362 02 1 CHAMRA RAM 1 CHAMRA RAM 1 40 1 22002084 3002004201322002084002 20/04/2013 11:40:06 3032004201322002084002 UTI 23/04/2013 11:09:34 2250 N 060019080F00000001092F4A22572266 NULL 1 Version:2.3.3 Released On: 04/02/2013 29/04/2013 14:19:13 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 1 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 NULL Version:2.3.3 Released On: 04/02/2013 29/04/2013 14:19:13 303 NULL 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 1 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 1 Version:2.3.3 Released On: 04/02/2013 29/04/2013 14:19:13 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 1 CHAMRA RAM 1 40 12345 22002084 3002004201322002084002 20/04/2013 11:40:06 3032004201322002084002 UTI 23/04/2013 11:09:34 2250 N 060019080F00000001092F4A22572266 NULL 1 Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 12345 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 1 Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 12345 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 NULL Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 NULL 18
22 02 22020319712000362 02 1 CHAMRA RAM 1 CHAMRA RAM 1 40 12345 22002084 3002004201322002084002 20/04/2013 11:40:06 3032004201322002084002 UTI 23/04/2013 11:09:34 2250 N 060019080F00000001092F4A22572266 NULL 1 Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 12345 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 1 Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 CHAMRA RAM 18
22 02 22020319712000362 02 1 CHAMRA RAM 2 safiyano 2 35 12345 22002084 3002004201322002084003 20/04/2013 11:55:31 3032004201322002084003 UTI 23/04/2013 11:18:30 2250 Y 060019080F00000001092F4A22572266 1 NULL Version:2.3.3 Released On: 04/02/2013 14/05/2013 11:40:10 303 NULL 18
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 40 01 09063024 3000403201309063024005 04/03/2013 09:20:39 15750 N 0600190D0B08000000065C4A22822291 NULL 3 Version:2.3.3 Released On: 04/02/2013 04/03/2013 09:23:07 301 kamlawati 5
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 40 01 09063024 3000403201309063024005 04/03/2013 09:20:39 3020403201309063024005 15750 N 0600190D0B08000000065C4A22822291 NULL NULL Version:2.3.3 Released On: 04/02/2013 06/03/2013 04:18:39 302 NULL 5
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 32 01 09063026 3002003201309063026001 NULL N 0600190D0B08000000065C4A22822291 NULL 3 Version:2.3.3 Released On: 04/02/2013 20/03/2013 12:43:08 300 kamlawati NULL
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 32 01 09063026 3002003201309063026001 21/03/2013 11:20:46 3032003201309063026001 hysterctomy vaginal & cyctocele anterior repa 26/03/2013 09:55:11 7500 Y 0600190D0B08000000065C4A22822291 NULL 3 Version:2.3.3 Released On: 04/02/2013 26/03/2013 10:19:51 303 kamlawati 6
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 32 01 09063026 3002003201309063026001 21/03/2013 11:20:46 3032003201309063026001 hysterctomy vaginal & cyctocele anterior repa 26/03/2013 09:55:11 937 Y 0600190D0B08000000065C4A22822291 NULL 3 Version:2.3.3 Released On: 04/02/2013 26/03/2013 10:19:51 303 kamlawati 6
09 63 09631801612001875 02 2 TINA 3 kamlawati 2 32 01 09063026 3002003201309063026001 21/03/2013 11:20:46 3032003201309063026001 hysterctomy vaginal & cyctocele anterior repa 26/03/2013 09:55:11 10000 Y 0600190D0B08000000065C4A22822291 NULL 3 Version:2.3.3 Released On: 04/02/2013 26/03/2013 10:19:51 303 kamlawati 6
22 23 22230300112122945 02 1 PARSHOTTAM 3 SARDA 2 7 1 22023003 3001303201322023003008 13/03/2013 13:09:41 3031303201322023003008 enteric fever 18/03/2013 13:15:42 3750 Y 0600171F1B00000002025B5222212230 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/05/2013 13:53:53 303 KUNTI 18
22 23 22230300112122945 02 1 PARSHOTTAM 3 SARDA 2 7 1 22023003 3001303201322023003008 13/03/2013 13:09:41 3031303201322023003008 enteric fever 18/03/2013 13:15:42 3750 Y 0600171F1B00000002025B5222212230 NULL 2 Version:2.3.3 Released On: 04/02/2013 18/03/2013 13:43:37 303 KUNTI 18
22 23 22230300112122945 02 1 PARSHOTTAM 3 SARDA 2 7 1 22023003 3001303201322023003008 13/03/2013 13:09:41 3031303201322023003008 enteric fever 18/03/2013 13:15:42 3750 Y 0600171F1B00000002025B5222212230 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/05/2013 13:53:53 303 KUNTI 18
32 08 32082200113008117 13 1 George 1 LEELA PAULOSE 2 63 1 32008037 3002505201332008037021 25/05/2013 13:43:52 3032505201332008037021 DM2 27/05/2013 13:37:43 1000 Y 06001D0B0305000001073B8330893098 NULL 1 Version:2.5.3 Released On: 26/04/2013 27/05/2013 13:41:02 303 LEELA PAULOSE 18
32 08 32082200113008117 13 1 George 1 LEELA PAULOSE 2 63 1 32008037 3002505201332008037021 25/05/2013 13:43:52 3032505201332008037021 DM2 27/05/2013 13:37:43 1000 Y 06001D0B0305000001073B8330893098 NULL 1 Version:2.5.3 Released On: 26/04/2013 27/05/2013 13:41:08 303 LEELA PAULOSE 18
32 08 32082200113008117 13 1 George 1 LEELA PAULOSE 2 63 1 32008037 3002505201332008037021 25/05/2013 13:43:52 3032505201332008037021 DM2 27/05/2013 13:37:43 1000 Y 06001D0B0305000001073B8330893098 NULL 1 Version:2.5.3 Released On: 26/04/2013 27/05/2013 13:41:15 303 LEELA PAULOSE 18
32 08 32082200113008117 13 1 George 1 LEELA PAULOSE 2 63 1 32008037 3002505201332008037021 25/05/2013 13:43:52 3032505201332008037021 DM2 27/05/2013 13:37:43 1000 Y 06001D0B0305000001073B8330893098 NULL 1 Version:2.5.3 Released On: 26/04/2013 27/05/2013 13:41:25 303 LEELA PAULOSE 18
32 08 32082200113008117 13 1 George 1 LEELA PAULOSE 2 63 1 32008037 3002505201332008037021 25/05/2013 13:43:52 3032505201332008037021 DM2 27/05/2013 13:37:43 1000 Y 06001D0B0305000001073B8330893098 NULL 1 Version:2.5.3 Released On: 26/04/2013 27/05/2013 13:41:32 303 LEELA PAULOSE 18
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 1 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/03/2013 11:04:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 1 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/03/2013 11:04:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 1 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 04/03/2013 11:04:06 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:17:11 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:19:38 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:21:25 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 11/05/2013 15:25:13 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:25:43 303 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 12:20:26 3020303201310005032001 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:04:56 3020303201310005032001 2625 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 302 DASHAMI DEVI 10
10 05 10051700112119649 17 2 DASHAMI DEVI 2 DASHAMI DEVI 2 70 03 10005032 3000303201310005032001 03/03/2013 19:12:41 3030303201310005032001 LE CATARACT 04/03/2013 10:53:41 3500 Y 060017200700000000012B4422272236 NULL 2 Version:2.3.3 Released On: 04/02/2013 13/05/2013 14:26:06 303 DASHAMI DEVI 10

pankajrocks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts
Posted - 2013-12-11 : 05:15:43
What according to you are duplicates? explain with some indicative sample data and also output you desire out of it. No need to post entire data like this which will only add to the confusion.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

webfred
Master Smack Fu Yak Hacker

8781 Posts
Posted - 2013-12-11 : 05:24:36
You can/should put tags [C0DE] [/C0DE] around your text to save your formatting in the posting

Too old to Rock'n'Roll too young to die.
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site