RE: INSERTED DUPLICATE RECORDS

SSC Guru

Points: 1003863

November 22, 2007 at 8:05 pm

The vb program will split the strings and remove unnecessary values such as 0's, and converts strings to datetime.

Yep... you're right... database sure can't do any of that 😉 And, I'm sure that the VB program does it with much more speed... 😀

I enforce the "no duplicates" via my vb program and it is working

Ummm... so you checked the table for duplicates, eh? And the table has a Primary Key, or at least a unique index to double check for you, huh?

Dave is correct... either you have duplicates or the report code is wrong. You need to check both.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)