I am looking for SQL experts for different RDBMSs which can write some useful query examples for my website [url removed, login to view] Please have a look at the website to get an idea of what I am after. Specifically [url removed, login to view] So basically I am after SQL recipes. This means you must provide a question as well as the answer(s). In your bid please let me know which RDBMS you are familiar with. I am basically looking for queries that took you a while to figure out, or even ones that you find yourself always repeating to others. You must provide the context the query is used for (i.e. its purpose) as well as a little summary. The more explanations you can provide the better. I will be accepting mutliple bids. Please let me know how many new queries you can provide me and the price for all of them. You must be the copyright holder of these queries and they must be original (preferably taken from your everyday work.) The successfull bidders will retain the copyright of their queries, but you will accept to post the queries on my website. (You will have to register first.) If you can write or have already written SQL related articles, please indicate how much you would be willing to sell them for (alternatively you could use this to promote a service or a product with a link back to your website.) Again, please indicate which RDBMS you are an expert in. Thanks!
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
* * *This broadcast message was sent to all bidders on Saturday May 20, 2006 10:51:43 AM:
Thank you for your bids.
This is just to let you know that I will select the winning bidders on Monday.
* * *This broadcast message was sent to all bidders on Saturday May 20, 2006 2:58:05 PM:
Here are some questions I have been asked, which I believe are relevant to all of you:
1) I am always interested in new questions and answers. For $5 to $10 dollars, the questions would have to be of very good quality. (Most questions and answers should not take more than 5 minutes to enter into the webstie as it is essentially a copy and paste type job.)
2) The questions that need pictures would probably be better as "articles". I already have an "article" section on the website, and will soon be adding file upload functionality as well.
3) Evaluating the quality of questions is a little difficult. I will be accepting several bids. After that I will have a good idea who is good and who is not good. Those who are good I will contact again to write articles and post more questions.
4) Any question and answer would be good. SELECT, UPDATE, DELETE, Triggers, Functions etc... the more different type of questions the better :-) (If the question and answer is long it may be better to put them as an article.)
> so if my query clashes with somebody else query ....
> how would we handle this situation.
Either you provide the answer if you have a different solution (or one that is specific to a RDBMS) or think of another question and answer.
> And also will be able to write and give you articles
> on SQL / RDBMS..... if you can specify some areas
> which you would accept articles on.
I will accept any articles that are relevant to SQL professionals. The best prospects for articles are the ones that you find yourself explaining to many people at your work place. Concepts or "tips and tricks" that you have discovered and make your work a lot easier and faster.
* * *This broadcast message was sent to all bidders on Tuesday May 23, 2006 8:17:25 AM:
I will be selecting a few bids today. I will then create another bid and invite those of you who were not selected today to bid again. I am sorry for the inconvenience, but that is the only way I can work around the system.
* * *This broadcast message was sent to all bidders on Tuesday May 23, 2006 10:02:38 AM:
Let me explain what is going on.
Rentacoder actually does have a good way of dealing with multiple bids.
I was waiting for them to broadcast the last message before selecting the wiinig bidders. It took them over 7 hours to process the broadcast, that is why things have been a bit slow in happening.
Any way I went ahead (even before the broadcast was processed) and selected the winning bidders. What RAC does is convert all your bids into private auctions. This is good for me as it allows me to track each bid individually now. (However I am not sure what you see on your end. If you did not get an email please check "My bids" on your RAC member page.)
You do not have to bid again. If you have left a comment I will be replying to you shortly.
Hope this helps clarify things.