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 |
|
messi
Starting Member
47 Posts |
 Posted - 2009-01-14 : 13:18:15
|
| Hello every one,i had a question in interview :the question is employee 1 enter data for client xemployee 2 enter date for client yemployee 3,4 and 5 enter data for client x i want to delete the repeated data entered by employee 3,4,5keep data entered by employee 1any can help plz Messi |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-01-14 : 14:46:32
|
| I can see why they are interviewing. They fired the previous DBA that didn't put any constraints on the database to prevent duplicate data.Be One with the OptimizerTG |
 |
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-01-14 : 15:05:00
|
| ha ha :) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 23:57:33
|
| look for ROW_NUMBER() function in books online |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 23:58:24
|
| or read this articlehttp://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx |
|
|
|
messi
Starting Member
47 Posts |
Posted - 2009-01-15 : 13:38:23
|
| Thanks every one for help... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-15 : 23:20:08
|
| welcome |
|
|
|
|
|
|
qestion in interview