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 |
|
drjames
Starting Member
3 Posts |
 Posted - 2006-11-19 : 19:59:59
|
| Hello!My name is Dr. James Triton. I am working on a research program for an unnamed University. Without getting into too much detail, I was wondering if any lower level college (or perhaps late high-school, depending on the strength of your Computer Science program) would be interested in filling out a few SQL queries, making an ER model or DDLs for a database.Here is some example questions:1. List each employee's first name, middle initial, and last name, concatenated to form a single value, as well as how many years they have been working for the company. An example name would appear as "JOHN Q SMITH". Sort the output by descending number of employment years. (HINT: create a column alias.) 2. List all of the job functions (such as "CLERK"), and the last names of all employees associated with each function. Order the output alphabetically by the functions. (HINT: there are a total of seven different functions.)3. List the last name of every manager, along with the last names of the employees that the manager manages. Create column aliases "MANAGER" and "EMPLOYEE", and order the output by manager last name.(there are 15 such queries)The table for these is located here: Please email me if you are interested!~Dr. James Triton~Edit : Links removed. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-19 : 20:32:54
|
| That’s a really pathetic attempt to get someone to do your homework.You should really be ashamed of yourself.CODO ERGO SUM |
 |
|
|
drjames
Starting Member
3 Posts |
Posted - 2006-11-19 : 20:47:44
|
| You should respect your elders, and not be so naive. If I could not complete these, I doubt very much that I would have written them for my class. Your comment doesn't help anyone and I suggest you keep to yourself unless you intent to help.~Dr. James Triton~ |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-19 : 21:00:22
|
| Do you think you're the first freeloader who couldn't get their homework done to try something like this?You should put some effort into studying.CODO ERGO SUM |
|
|
|
drjames
Starting Member
3 Posts |
Posted - 2006-11-19 : 22:06:35
|
| I am not 'freeloading,' I know this material. You should put some effort into being useful.~Dr. James Triton~ |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-11-19 : 22:45:44
|
| Well now, given that Michael is a valuable member of this community, and you are asking what appears to be homework, and I can find no record of your name at your "unnamed University"... I'm going to side with Michael on this one.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
|
|
Any college students in the house?