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.
| Author |
Topic |
|
Trafmore
Starting Member
6 Posts |
 Posted - 2007-08-03 : 08:44:35
|
| Hi I am writing an application in VB .net, and on one of my aspx pages I have the user sending some narrative data to a database table. That narrative is written on a cycle basis each cycle has 4 days. The narrative is linked to an individual by ID, the Cycle number and day number. So for example Person A with ID 01 has cycle 1 and the days run from 1 - 4 and cycle 2 is 5 - 8 and so on. I would like to check the database to see if a record exists for an individual before it is inserted to the database and if it is display a message to the user that the record already exists, so I do not have a person with something like cycle 1 day 1 twice. How can I achieve this using VB.Thank You Trafmore |
|
|
|
|
|
Duplicate Record