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 |
|
raviteja Chilakamarthi
Starting Member
1 Post |
 Posted - 2008-02-06 : 11:26:34
|
| Hi I am new to the SQL sever development environment.....I was given a project to work on and the problem looks like this....I have a student data table and a HR table that loads student data and Employee data into a Master table.First the Student data and HR data are loaded into SISDATA and HRDATA tables respectively.Then any duplicates in the SIS DATA and HRDATA are filtered into a DUPESID table and DUPEEID table respectively.If there are duplicates between hrdata and sis data tables are loaded into the DUPES table.If there was a student who works as a part time employee and is a student then there is a conflict in the master table with the row missing its student id in the master table........pls help me to resolve this.Do i need to look over the DB design........????pls help me.Thanks in advance Raviteja Chilakamarthi |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-06 : 23:15:12
|
| Looks like homework. |
 |
|
|
|
|
|
SQL DEVELOPMENT PROJECT