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 |
|
avivdeg
Starting Member
1 Post |
 Posted - 2011-06-11 : 06:07:47
|
Hi everybodyI have a big test tomorrow and I need your help.this is my database what they ask me to do is to query the employees names + project name + working hours (avg) and all of that ordered by departmentsHELP ME PLEASEmy hair turend grey  edit: moved to proper forum |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-06-11 : 07:18:10
|
| If I give you the answer do I get the qualification?Not doing your homework for you. What do you have so far and where are you stuck?--Gail ShawSQL Server MVP |
 |
|
|
Amateurtje
Starting Member
5 Posts |
Posted - 2011-06-12 : 10:05:41
|
| isnt it possible to attach the database here so we can play with it and make the query in access?I agree that making somebodies homework can not be the goal... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-12 : 10:33:35
|
| SQLTeam is not a file hosting site, and due to macros and possible viruses I'd feel compelled to remove a link to an Access database file as a security risk.There's enough information in the screenshot to reconstruct the table structures if you choose, and you can populate your own sample data to validate that the query works. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-13 : 07:59:14
|
| Which department? The project department or employee department?Your Employees - Departments link looks interesting.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
URGENT big test tomorrow