Sql Last One
Required skills: SQL
(You are to put all your screen snapshots for the items below, each showing the required SQL statements and results, in order, in a single Microsoft Word file. Failure to do so may result in lost points on this assignment.)
Using the fully populated Employee and Job_Title tables and data from Week Three, write queries using SQL UPDATE and DELETE statements. (2-1/2 points each)
Note: As a precaution, you should SELECT all of the data from both of your tables before you perform the following updates (i.e. UPDATE and DELETE statements) as a check that you'll be affecting the correct data! But it's the UPDATE and DELETE statements that actually change the data that you'll be graded on. You don't need to show the results of your "quick check" SELECT, but be sure to include all the SQL and SQL Server responses for your UPDATEs and DELETEs.
· Choose an EEO-1 Classification: Increase all employees' salaries that have the selected EEO-Classification by 10%.
· Increase all employees' salaries by 5%.
· Choose an employee from the employee table and delete this employee.
Using the database and tables from Week Three, write SQL statements to calculate the following. Note that each query must consist of a single SQL statement. (2-1/2 points each)
· Calculate the average salary for all employees.
· Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the maximum salary for all employees.
· Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the minimum salary for all employees.
· (3 point bonus query) – See Weekly Lecture #4 for details. Note that the maximum total score you can receive for Week Four, even adding in this bonus
Using the fully populated Employee and Job_Title tables and data from Week Three, write queries using SQL UPDATE and DELETE statements. (2-1/2 points each)
Note: As a precaution, you should SELECT all of the data from both of your tables before you perform the following updates (i.e. UPDATE and DELETE statements) as a check that you'll be affecting the correct data! But it's the UPDATE and DELETE statements that actually change the data that you'll be graded on. You don't need to show the results of your "quick check" SELECT, but be sure to include all the SQL and SQL Server responses for your UPDATEs and DELETEs.
· Choose an EEO-1 Classification: Increase all employees' salaries that have the selected EEO-Classification by 10%.
· Increase all employees' salaries by 5%.
· Choose an employee from the employee table and delete this employee.
Using the database and tables from Week Three, write SQL statements to calculate the following. Note that each query must consist of a single SQL statement. (2-1/2 points each)
· Calculate the average salary for all employees.
· Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the maximum salary for all employees.
· Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
· Calculate the minimum salary for all employees.
· (3 point bonus query) – See Weekly Lecture #4 for details. Note that the maximum total score you can receive for Week Four, even adding in this bonus
Posted In:SQL |
Related projects:
Another Redesign...the Last One Was Not Good 2
design...then show me the "look" first. Once the design is approved then you can add the content.
IMPRESS ME....I HAVE TO IMPRESS THIS CLIENT!!!!!
This project must be able to be edited in dreamweaver once completed.
Additional Info (Added 12/1/2010 at 15:11 EST)...System Message: This is a reposting of project Another Redesign...The Last one was not good (1289511750).
IMPRESS ME....I HAVE TO IMPRESS THIS CLIENT!!!!!
This project must be able to be edited in dreamweaver once completed.
Additional Info (Added 12/1/2010 at 15:11 EST)...System Message: This is a reposting of project Another Redesign...The Last one was not good (1289511750).
This is the last one get it right
last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exerciseone last exercise
CSV file generator
='01') AND (parent.status_flg='c') AND (parent.doe > [doe_data])
The connection string :
DSN=TASS;UID=<XXXXX>;APP=2007 Microsoft Office system;WSID=USERNAME;DATABASE=tass;Network=DBMSSOCN;UseProcForPrepare=0
The completed application needs to take the username and password for the SQL connection at runtime.
Additionally the application needs to have options to set the parent.doe parameter which is a date in the format of DDMMYYYY.
The connection string :
DSN=TASS;UID=<XXXXX>;APP=2007 Microsoft Office system;WSID=USERNAME;DATABASE=tass;Network=DBMSSOCN;UseProcForPrepare=0
The completed application needs to take the username and password for the SQL connection at runtime.
Additionally the application needs to have options to set the parent.doe parameter which is a date in the format of DDMMYYYY.
Debugging Php Scripts
I will discuss once I have chosen a programmer or team with a great track record/feedback and that can produce good solid code with no bugs and good security so there can be no exploits in any of the scripts. Any competent programmer can do what I need with no problems.
When messaging me explain your qualifications and give me some examples.
When you bid, bid on first item only (first paragraph above). The rest will be discussed and paid appropriately!
When messaging me explain your qualifications and give me some examples.
When you bid, bid on first item only (first paragraph above). The rest will be discussed and paid appropriately!
fully copy ebay + ceo customizable, sql
As title says I want you to copy the whole website + its functions + its ceo + its sql(empty one). The website name I want is www.ebay.co.uk
To meet my requirements I want a full copy of ebay.co.uk.
I want my website to be fully customizable in ceo.
if you have already copy ebay please pm me with the work you have done already
If you need more info dont hesitate to contact me.
To meet my requirements I want a full copy of ebay.co.uk.
I want my website to be fully customizable in ceo.
if you have already copy ebay please pm me with the work you have done already
If you need more info dont hesitate to contact me.
copy website + ceo + sql (ebay)
its functions + its ceo + its sql(empty one). The website name I want is www.ebay.co.uk
To meet my requirements I want a full copy of ebay.co.uk. If you want you can offer me a different companies(websites) that do the same job(service) as ebay.co.uk
I am also familiar with wordpress so if you can provide this website in wordpress its also acceptable.
If you need more info dont hesitate to contact me.
Thanks
To meet my requirements I want a full copy of ebay.co.uk. If you want you can offer me a different companies(websites) that do the same job(service) as ebay.co.uk
I am also familiar with wordpress so if you can provide this website in wordpress its also acceptable.
If you need more info dont hesitate to contact me.
Thanks
copy website + ceo + sql
ctions + its ceo + its sql(empty one). The website name I want is www.giffgaff.com
To meet my requirements I want a full copy of giffgaff.com. If you want you can offer me a different companies(websites) that do the same job(service) as giffgaff.com
I am also familiar with wordpress so if you can provide this website in wordpress its also acceptable.
If you need more info dont hesitate to contact me.
Thanks
To meet my requirements I want a full copy of giffgaff.com. If you want you can offer me a different companies(websites) that do the same job(service) as giffgaff.com
I am also familiar with wordpress so if you can provide this website in wordpress its also acceptable.
If you need more info dont hesitate to contact me.
Thanks
Facebook app to get check ins at venue
have a input box next to each group that allows me to enter a message to be posted on their wall.
For example I would next to "CHECKED IN LAST WEEK ONLY" there would be a box where I can write a message. When I click send it will write on all of the users walls that were in that group.
It is a simple app that does NOT need to store any data on an SQL server. It should not take very long for a skilled developer
Thanks!
For example I would next to "CHECKED IN LAST WEEK ONLY" there would be a box where I can write a message. When I click send it will write on all of the users walls that were in that group.
It is a simple app that does NOT need to store any data on an SQL server. It should not take very long for a skilled developer
Thanks!
Simple Converting g1948.com to be DB driven 1-2012
mers. The module has to set CustomerId to each new customer in a sequence, not automatic, numbering method (1,2,3.. etc). So if we have 4 customers that the last one is with CustomerId = 8 then the next should have CustomerId =9. When new customer want to register, pls say how would you code (what sql or other method) to find the new CustomerId you should use?
3. Please provide info/answers regarding all issues mentioned above
3. Please provide info/answers regarding all issues mentioned above
Websites integration with ClickBank.com
br>
One MS SQL database is for braindumps.biz exlcusively.
The last MS SQL database is used for customer management of examsuites.com
current we have set up one account at clickbank.com for certifydumps.com and examsuites.com , its info will be provided to successful bidder only.
We need this project on priority. Only those freelances should apply who are familiar with clickbank integration and sales model.
One MS SQL database is for braindumps.biz exlcusively.
The last MS SQL database is used for customer management of examsuites.com
current we have set up one account at clickbank.com for certifydumps.com and examsuites.com , its info will be provided to successful bidder only.
We need this project on priority. Only those freelances should apply who are familiar with clickbank integration and sales model.
Fix and error and install new modules on Oscommerce webstore
ure when we need upgrades. So consider it as the potentially long term cooperation.
In order to complete this project you MUST have good knowledge of Oscommerce as a developer and you MUST have strong php programming skills. Please do not bid if you are not sure what to do or have poor skills.
Please provide samples of your previous work if you have anything to show.
Thank you
In order to complete this project you MUST have good knowledge of Oscommerce as a developer and you MUST have strong php programming skills. Please do not bid if you are not sure what to do or have poor skills.
Please provide samples of your previous work if you have anything to show.
Thank you
Fix Menu And Add One Page
with red text in the site but actually your account is successfully created.I just need one simple text to notify the members that they account has been created without problems.
My site use .tpl system so this won't be hard for someone with good experience.
And last one item is open for discussions - I receive spam through my contact form,I have doubts that my previous coder did something and I need good solution for this problem.
Thanks for your bids
My site use .tpl system so this won't be hard for someone with good experience.
And last one item is open for discussions - I receive spam through my contact form,I have doubts that my previous coder did something and I need good solution for this problem.
Thanks for your bids
Upgrade the use of old DB ASP in a simple guest book
each new customer in a sequence, not automatic, numbering method (1,2,3.. etc). So if we have 4 customers that the last one is with CustomerId = 8 then the next should have CustomerId =9. When new customer want to register, pls say how would you code (what sql or other method) to find the new CustomerId you should use ?
3. Please provide info/answers regarding all issues mentioned above
3. Please provide info/answers regarding all issues mentioned above
Simple PHP - MySql site
e information and many photos.
The last one will be a photo gallery where only administrators would up photos.
It doesn´t even matter if you want to use phpnuke, my_egallery... any already done script.
I don´t speak english very well so the work can be difficult.
I already have a english speaker graphic designer but I will accept if you would like to do the graphics too (tell me on comment when you post your bid).
The last one will be a photo gallery where only administrators would up photos.
It doesn´t even matter if you want to use phpnuke, my_egallery... any already done script.
I don´t speak english very well so the work can be difficult.
I already have a english speaker graphic designer but I will accept if you would like to do the graphics too (tell me on comment when you post your bid).
New function on my site and repearing.
Additional information submitted: 12/29/2009 at 7:58 EST:
Repearing> forgot to write) at the top of the page there is a button called nyeset bruger, when guest create username, it does not appear in this box, it works for 3 days ago, not yet. it is like disabled
New function on my site and repearing
e a profesional one my site was developed
first with: www.digitaldreamdesign.net = they wasssssssssss veryyyyyyyyy professional
seconed: www.smartinfosys.net = They working haaaard to develop a good site for you, they try very very very hard but you can se that the page still doent work good, and there is many error , thats why i shall pay extra for this one
I hope the next one do it like www.digitaldreamdesign.net
first with: www.digitaldreamdesign.net = they wasssssssssss veryyyyyyyyy professional
seconed: www.smartinfosys.net = They working haaaard to develop a good site for you, they try very very very hard but you can se that the page still doent work good, and there is many error , thats why i shall pay extra for this one
I hope the next one do it like www.digitaldreamdesign.net
csv import using class asp
Additional files submitted:
Example.csv
db_structure.GIF
Create one new report and one tweaked report for Creloaded
complete the task in time. If you deliver only a half finished product you will not get paid.
Additional files submitted:
grid.png
Additional files submitted:
grid.png
Review articles plus one super Squidoo article.
bidding should end in 24 hours and I will choose a winner within hours. I need at least the first 12 articles within 18 hours and the last one not much later than that. The sooner the better (I will have a much larger order, 50+ articles) as this is a test drive of sorts. Let me know what you think of the time constraints or if you can get this all done in half the time. ALL ARTICLES MUST BE FRESH AND UNIQUE. I HOLD ALL RIGHTS ONCE SUBMITTED. Thank you.
Interspire Moding and customising
gif" alt=" " width="834" height="1"/>
Additional files submitted:
01.jpg
02.jpg
03.jpg
