| |
|
|
Job Summary:
|
| |
| Job Type: |
Project |
| Budget: |
$ 20-100 |
| Attached
Files: |
(None) |
| |
|
| Status: |
Closed for bidding
|
| |
|
|
|
Buyer Summary:
|
| |
| Username: |
|
| Feedback Score: |
12
reviews
|
| Award Reliability: |
2 posted 1 paid |
| |
|
| Location: |
Nevada, Las Vegas, United States
|
| Member Since: |
June 10, 2008 |
| |
|
|
|
| Invited Users: |
There are no invited users
|
Description
1) Write a SQL statement that creates a stored procedure with one int input parameter. The stored procedure selects the supplierId field and the total of all Count field values for each group of supplierId's from the Part table. The Part table was defined in week 3's assignment. Only rows with their Count total, or sum, greater than the value specified in the input parameter should be returned. Hint: Each returned record has a unique SupplierID value, since we are dealing with groups.
2- Write a SQL statement that creates a stored procedure that adds a new record to the Part table, and returns the value of the newly created PartID PK in an out parameter. The field values of the record to be added should be passed into the stored proc as input parameters. The assumption here is that the Part table has its PartID PK field as an idendity field, or surrogate PK, meaning a numeric field that is auto-generated by the db system.
3- Write a SQL statement that creates a user defined function that returns an int value. This int return value is obtained by subtracting the lowest Count field value from the highest Count field value of the Part table. You could enter dummy test records in the Part table if you are running/testing this function in SQL Server.
4- Create an Update trigger on the Part table that raises an error string if the Count field of the updated row has a
higher value than the value prior to the Update. In other words, the new value cannot be larger than the older value. If the trigger fires and after the error string is displayed, the Update operation should be rolled back. The exact text of the error string is up to you to define.
Reminder
You may not start working in this and any request before
your bid is accepted. Users who violate this policy
may have their accounts permanently suspended.
|
|
|
Dhaka,
BD
location |
US$20
bid amount
|
(38
reviews)
feedback |
1 day(s)
delivery time |
|
| |
Hello,
I agree to do the project only for 20$. Please allow me 1 day since I have a problem in my internet connection and I have to submit it to you tomorrow through cybercafe.
Let me know what you think.
Thanks
Bid Time: 08-08-2008 04:44
|
|
|
|
|
|
|
|
| |
| Get the Free
Step-by-Step Guide on How to Use GetACoder |
The act of
outsourcing jobs has become easy in the past few years
thanks to GetACoder. However, our team aims at making the
whole process even easier. So, it has now come the time to
provide you with a step-by-step guidance on how to use this
service and succeed in the outsourcing world totally for
FREE.
It doesn't matter if you are a more experienced user or a
novice; using GetACoder will become even simpler with the
help of this E-book. There are two major sections: a Buyers
section and a Coders section.
Buyers will learn:
- How to outsource safely
- How to pick the best freelancers
- How to manage time and money
Coders will learn:
- How to get the best jobs
- How to secure their payments
- How to build a long-lasting relationship with buyers
...and MUCH MORE
Clear examples and pictures illustrating key situations,
great tips and real testimonies of some of our best users...
all in this Outsourcing Guide. So don't loose the
outstanding opportunity to download GetACoder FREE E-book.
|
 |
|
 GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online. One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day. Thousands of Satisfied Customers - Submit/View Quotes
| - | We, EBoys are small group of people trying to get some quality work from the world of information. So we decided to go with GAC because we liked the simple, easy interface and amount of projects posted. Now, we are doing really well. We have got lot of projects through them. Most important part is, when you need support or you have any complains about any user, you can just email GAC support and you will have response within couple of days, and that too really, really prompt. Last but not least, the payment processing, they are really prompt in that, you will never loose your money unless you cross your legal boundaries. We are really thankful to GAC for providing us this wonderful opportunity to develop our small firm and meet various clients out there in the universe. - | | - | This is a great opportunity for me and other freelancers. We can work here without any waste of time. - | | - | GetACoder is simply amazing! - |
|
|
| |
© 2004-2012 GetACoder. All rights reserved. |
|
