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 |
|
day92
Starting Member
4 Posts |
 Posted - 2010-12-20 : 19:37:20
|
| I have a quick question, I have three tables I need to compare. The first has the enrollment from 2010 and the 2nd has the enrollment from 2009. I need to compare the change in enrollment from the two. The third has the list of dr and I need to compare that change by a list of Dr's.Does this makes sense?I can attach a sample database if this helps. Oh yeah I have this all in access. |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2010-12-20 : 19:55:24
|
| what do you mean by change of enrollment? Do the tables have a link between them? An entire database isn't needed, but some sample data for each table and what your expected output is would be helpful. If we can write something that translates in to Access that's good, but not guaranteed, as this is a forum for MS SQL Server. Although Access uses an SQL, SQL Server uses t-SQL, which is a bit different.JimEveryday I learn something that somebody else already knew |
 |
|
|
day92
Starting Member
4 Posts |
Posted - 2010-12-21 : 12:04:17
|
| I have data in two different databases - one from 2009 and one from 2010. I want to compare the enrollment change my Physician year over year. Is there a way I can upload a sample database here? |
|
|
|
|
|
|
comparing two tables