Find Jobs
Hire Freelancers

cross promotions/sql statements

$30-5000 USD

Completed
Posted about 20 years ago

$30-5000 USD

Paid on delivery
Enclosed is the details of the project. Please read carefully before bidding. What this project entails is coming up with various SQL Statements to determine what ads can be cross promoted. The way it is determined whether it goes together is by make, model, and year. The relationship between the tables are given in the attachment. Feel free to ask any questions about the relationships between the tables to get a better understanding on the project. What is needed is a procedure. For the procedure would be to come up with SQL Statements to come up with the list of items to cross promote with the auction. There should be 2 parameters to send to the procedure. The first one should be id (ad id). The second one would be how many to return. Currently it is four. However, it needs to be flexible enough so if more are allowed, it would show more. If there are less than the number for the second parameter, then only that number would be shown. The last part is to update the crosspromotions table so I can simply query it for the list after the procedure runs. Must be as efficient as possible. I am open to suggestions on improving the performance of the database by changing the structure if needed. ## Deliverables The source code only for the procedure. There should be two procedures for the deliverables. The first one would be main to show it calling the other procedure. The SQL Statement must work in Access and SQL Server 7.0. This will be used for SQL Server 7.0. Must be coded with Visual Basic. ## Platform Windows 2000
Project ID: 3088324

About the project

3 proposals
Remote project
Active 20 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$25.50 USD in 2 days
5.0 (5 reviews)
3.8
3.8
3 freelancers are bidding on average $71 USD for this job
User Avatar
See private message.
$84.15 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
See private message.
$102 USD in 2 days
0.0 (2 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
781
Payment method verified
Member since Apr 9, 2002

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.