|
Hello,
I have the following tables:
PROJECTS - project_id, name EMPLOYEES - employee_id, name SALARY - employee_id, date, per_hour HOURS - log_id, project_id, employee_id, date, num_hours
I need to query how much a project is costing. Problem is that ...
Started by majestiq on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Record is inserted into SALARY for an employee, the previous record with the highest date (or better yet.
|
|
What types of programmers tend to be attracted to full-time positions and what types are drawn to contract positions?
Which type are you, and have you swapped between one to another?
Does there come a time in a programmer's life when he/she typically ...
Started by Elijah Manor on
, 16 posts
by 16 people.
Answer Snippets (Read the full thread at stackoverflow):
We have to pay them a little more to keep them happy we can afford health... .
My career has primarily been a full-time employee working for contracting amount per hour more than a full-time employee.
Or IT supervision positions.
|
|
I am trying to build a SQL 2005 database that has a Company data table and an Employee data table. Each company should have an Employee 1, Employee 2, and so on. I realize that each Employee record would have a PK of both their EmployeeID and their CompanyID...
Started by Dan Appleyard on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
It's a 1:many relationship between Employee and Company would have a PK, and ....
Both EmployeeSounds like there's a foreign key in there somewhere .
And Company, assuming that an Employee could only work for one Company at a time.
|
Ask your Facebook Friends
|
I want to find the largest sale for each of my employees (and display the name of the employee). In MySQL, it's pretty straightforward:
select * from employee, sale where employee.id = sale.employee_id group by employee_id order by sale.total desc
This...
Started by altCognito on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I have also aliased the employee table....
From employee e, sale s where e.id = s.employee_id group by e.name order by s.total desc
I have made an assumption that the employee name is in the name column of the employee table.
|
|
Are personal tools that were created by an employee of a company owned by the employee if they were not commissioned by the company he worked for?
The scenario is as follows:
The employee has long since left the company The tools have spread throughout...
Started by Mr. Kraus on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
If the employee ever came back and claimed that you were using their software then the fact that they wrote....
If they were written by an employee in the normal course of their job with you then they belong to your company.
Issue to sidestep.
|
|
When an employee is fired or let go, it is critical to disable their accounts and access to resources immediately. How do you handle this at your organization?
Started by Brett G on
, 8 posts
by 8 people.
Answer Snippets (Read the full thread at serverfault):
Coordinate with HR turn off....
Have the cuff" firing, detail someone to keep an eye on the employee until I/T finishes removing their privileges.
Make it your process to tell I/T before you tell the employee that they have been terminated.
|
|
I'm writing an app that contains the following tables: (1) employee_type, (2) employee and (3) employee_action.
Employee_action is foreign-keyed to employee, and contains a description of what happened and the date of the event, just as you might expect...
Answer Snippets (Read the full thread at stackoverflow):
Representing....
Have you considered introducing a transition (many-to-many) table linking the employee_type and the employee, and then linking the employee action to this transition table? The transition table could chronologically.
|
|
I've fired a number of employees and I've had to cut hours and other things, but I've never had to actually lay someone off before. Sucks. Kid's been here about a year, 21 years old and he just found out about a week ago his wife's expecting their second...
Started by Kburggibbs on
, 11 posts
by 10 people.
Answer Snippets (Read the full thread at yamahafz1oa):
Make sure HR is there with you when you have the conversation with the employee.
I know to.
Make sure HR is there with you when you have the conversation with the employee.
Not supposed to.
|
|
I am writing a C# program to handle scheduling. Now each employee needs the ability have limitations on their schedule for ex:
Sally can only work Monday, Wednesday, Friday from 9am-3pm
Billy can only work Tuesday, Thursday, Sunday from 5pm-9pm
Sally ...
Answer Snippets (Read the full thread at stackoverflow):
Pretty simpleI would suggest giving the ability to store 'time off' as specific dates with time ranges with union rules and employee....
You have an employee a date and a time span.
I want day X from y to z off.
Exceptions.
|
|
Even if you can't make ends meet with your existing salary; you can't take a part-time job (what a ridiculous law)
Times are tough and maybe you are considering taking on a second job to make ends meet. But depending on the terms of your employment, accepting...
Started by ashedfc on
, 15 posts
by 13 people.
Answer Snippets (Read the full thread at smartcanucks):
Now if she was doing this on her ....
The Guidelines were part agree with Scotia here ..since she was handing real estate business cards on company time.
In the cases of several other employees considering part-time jobs as realtors.
|
