SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Adding Data to Tables
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

NFSRacer
Starting Member

1 Posts

Posted - 03/06/2014 :  13:05:42  Show Profile  Reply with Quote
Okay, so I'm currently in an SQL internship, and am running into an issue with a project they've given me. Primarily, he's asking me to try to get a table containing student entry testing information to update with a new column that's supposed to contain the testing dates. This in mind, there is another table that contains testing data, and who's students are grouped by date, the data in each group all coming from the students table. Issue is, I don't know how to get the testing dates from the TestData table into the Students table. There's already a relationship set up between the TestID fields on the TestData table (PK) and the Students table (FK), so I don't think I can set up a new relationship to get it working. Can someone help, please?

maunishq
Yak Posting Veteran

Canada
71 Posts

Posted - 03/06/2014 :  14:44:21  Show Profile  Reply with Quote
I am sorry, but I am not very clear about the situation.
Do you have a table into which you want to get the testing dates column? If not, first create a table.
Then you can insert the column "testing dates" into the new table either by using SELECT INTO... syntax.
It would be best to help you out if you are more clear about the available data on hand.

=======================
Not an Expert, Just a learner.
!_(M)_!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000