Sql Query Statements Using Leebooks.sql

Need help with a sql query that involves 3 tables and requires
2 calcualtions within the select statement.

Requirements
Connect via gotomypc
Instant Messenger to communicate quickly

SQL Query Problem - Add, Amend, Delete.

On the Administration page of my website, an Administrator should be able to add, edit, delete entries in the Products and categories, which is a database built in MS Access. They should be able to alter entries in the tables.

I think the Insert, Update, Delete statements need to be tweaked.

I need an MS SQL database query developed for the table attached.

I need a query that will...
Return all columns from the tbl_Recert_Cycle table which are distinct Cert_CustID the the largest Sequence value.

Please see attached tbl_Recert_Cycle.mdb, tbl_Recert_Cycle.jpg and tbl_Recert_Cycle.rtf

Create a small SQL query for us again using MS Access. This project is created specially for a specific freelancer who I want to work with again.

right style="padding-left: 20px; width: 320px">


Additional files submitted: (Files are only available for logged in users)
SQL+query++andnotes.txt

d how it may be involved in the issue of slow load time.
- Your assesment of the task (how you will proceed if chosen, and time frame)
- if required, we can send you the index file through PM.

The chosen provider will have FTP and phpmyadmin access for the test site, and must provide full documentation of file changes, database changes and updates, so that we can implement the fixes ourself on the live site.

Best regards
MD-Import

I have a SQL query thet use "NOT IN" instruction that is a low performant in ACCESS with a large database.
I need to transform this SQL query in a SUBQUERY, perhaps using [%$ ##(at)_Alias], so as to transfer this SQL in a asp page with jet ACCESS to to create a paging script.

I am looking for an individual who can help me in writing sql query - individual should be expert in this field and should have the prior experience in writing query with mid level complexity. Individual has to work with me side by side and hence he should have high speed internet to share the desktop with me. I will provide all conferencing tool to connect.
Currently I am expecting it would be 7-10 hours a week for 2-4 weeks.

until it does what it is supposed to do.

You need very good SQL Server skills and similar ASP.NET C# skills. You will receive access to SDK code and a more detailed description of this task. You will be asked questions regarding SQL Server to prove your knowledge.

If you are successful on this project, an on-going relationship is possible.

Hi

I need an SQL query writing pretty simply.

Wants to look in table 'events' at field 'date' (which is in UNIX time stamp format. e.g. 134850934) and it wants to find all rows which are older than 3 months.

Thanks

ng else (sql task):
for our magento site - http://74.220.215.71/~pearlsco/index.php/

for each product, I want to copy the product - name & description & short description from store id 2 (which is our hebrew language store) to the default store (id 0). we dont need to duplicate the products. only copy this attributes to the store id 2 products.

all we need is the sql query

Hi,

there is something wrong with this sql query but im not sure what.

SELECT fp_poster_id FROM forum_posts WHERE fp_time > fp_time - 30 AND fp_poster_id = $ userid

it wants to find the post user for example user 'A' has posted and see if the the time it was posted is greater than 30 seconds ago.

thanks

Hey

I have made this sql query

SELECT * FROM `users` WHERE `cdays` LIKE '-%'


is it possible then to change field 'cdays' to 1 for all results that query brings?

thanks!

if the scrip-file has a statement to update also other fields only the field in the list would be updated, unless i dont give a list .

The programs has to be to run from a cmnd line with no GUI
It could use some INI files and send the INI file as a parameter to to program
The tables are DBF and ADT tables from http://www.sybase.com/products/databasemanagement/advantagedatabaseserver

a translation from mssql into mysql for this query.

Greetings,
Michael


Additional files submitted:
mssql_query.txt

eview from a table, hence the reason i came up with the Exceeded table and finally the total record count and count after it hit -300 for that session.

I can provide you with a sample database if you need it, ill backup the database and let you restore it on your PC. Ill send you a smaller one though as youll only need a few records id imagine.

Finally we need to consider each monthly search will have up to 70k records so i dont want timing out or crashing.

o needs to include the following details for all orders that are marked as "pending shipment":

OrderID, Order date, ship company name, ship first name, ship last name, ship address1, ship address2, ship city, ship state, ship postal code, ship country, ship phone number, total shipping cost, product code, product name, quantity, product price, total price, order status (being "pending shipment").

Many thanks in advance.

t 1200 entries to update.

CURRENT
smf_members
memberName Jennyb
realName Jenny

phpbb_users
username Jenny
username_clean jenny (note lower case)


DESIRED
smf_members (no change)
memberName Jennyb
realname Jenny

phpbb_users (both changed)
username Jennyb
username_clean jennyb (username made lower case)

Time is of the essence.. please only bid if you can provide the SQL query immediately.

manually exported by me and sent to my fulfillment house for shipment.

More detail: On my website, people can place an order for a nutritional supplement and have it auto shipped every 30 days. So, whenever the 30 days is up (it will be different for every customer), their new order must automatically be placed in with the normal new orders for that day and then I will go in and manually use the saved export file to export all these daily new orders as a CSV.

ITEM_CODE | COST PER ITEM | TOTAL QUANTITY USED
BUCKLE1 | 12 | 24
BUCKLE3 | 11 | 12
LEATHER | 8 | 12.3


NOTE: I do not have the ability to provide access to our database or data. YOu will have to work with me on messenger or via email to have me test this as you work on it.

THIS MUST BE DONE TODAY. I AM ON MSN MESSENGER NOW WAITING TO WORK WITH THE PROGRAMMER CHOSEN.