New to SQL SERVER DEVELOPMENT

  • 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

  • I think it would help if we had a little better explanation of why you are doing what you are doing? What is the end purpose that you are trying to achive? Can you post your table schemas for all of the tables that you are using as well as some sample data for each table. Also, a brief explaation of what each table is used for? What is the purpose of storing the duplicates in their own table? Oh yea, please also post any work that you have already done.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • This is also a good article on how to ask for help:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply