SQL jobs

need php with my sql 3 pages project , need registration and login , drawing polygon from basic data provided by unique user. and save with date, present drawing by date daily weekly monthly, with all result.

*** PLEASE SEE ATTACHED FILE FOR FULL BUG DESCRIPTION I have a view (daily_schedule) that returns a list of all bus passengers that need to be picked up on a given day (monday - sunday). When a user is picked up, a record is written to a table named "trip_history". This table contains a date/timestamp for that ride. 2 rides are allowed per day/per rider - the ride to their destination and their ride home. Each Union statement represents a day of the week. Only one SELECT statement should run per day depending on the day of week (MON-SUN). Each SELECT has a CASE option in it. This CASE logic is meant to determine if a passenger has already been transported on the bus in the morning/AM (first case statement) or the afternoon/PM (second case statement). If the statement execution happens in the AM and the passenger already has a "trip" record recored for an AM ride, the query should return "TRANSPORTED" for the pickup_status. Likewise, if the statement execution happens in the PM, the query should also return "TRANSPORTED" for the pickup_status. Otherwise, the pickup_status should be NULL. File Attachments: 1. BUG [login to view URL] 2. All .SQL files needed

Hi, The code what i need is Simple: 1. I have two tables called as Sequence and the Newsfeed The newsfeed PK ID is the key which also exists in the sequence table and sequence is stored in newsfeed table, even the sequence table has the sorting order too but that s not used. now what i am trying is: select * from newsfeed where id in (select fk from sequence where pkid = 1000) - if the internal sub query has some records it will give me a some values maybe 5 or 10 records or sometime 1 and if it does not have any record it will return me nothing, now if it returns me nothing, i will do another query which is like this select * from newsfeed where id = 1000 and it will return me the value then based upon o am getting the sortorder of the id from the newsfeed table. and then it gives me the record of that table with sortorder here comes the tricky part: sortorder: ID 25 5252 26 5255 i am deleting the 5252 record and that 5252 sortorder is 25 so i am deleting 25 and then before 25 its 24 and after 35 it is 26 so what i want s the sorting f the records which are after the deleted records: so it will be like this; sortorder: ID 25 5252 - because this has been deleted 25 5255 and so on so the sequence will be have to fixed. i showed an example of 1 record but if there are more records then that needs to be fixed too, anyone who bids please understand this structure because this is what i have to do, a udf or single query or stored proc will work here Thanks Max i can pay is $15 Canadian Dollars

Current production database, sampling database.

I need to develope a system that will be used in a copy/print store. I need to be able to do Estimating, Invoicing, Job Tickets, Shipping and a Database to load pricing for store products. I need it to be installed on a server and web-based that way it can be accessed by PC Computer, Mac, Mobile Devices and Tablets. It need to integrate with UPS, Fedex using API, also need to export reports to Quickbooks. If you have any other questions feel free to contact me. This would be an ongoing development.

We have a software product running but need an upgrade. Written in Sunbelt PLB. Using Fixed Length text data files Want to move data to an SQL data base and create a multiple platform software solution. There are lots of accounting transactions and communication as well as workflow involved. The current system uses over 500 separate progs and over 400 text files. We need this developed in a record time line.

We have a software product running but need an upgrade. Written in Sunbelt PLB. Using Fixed Length text data files Want to move data to an SQL data base and create a multiple platform software solution. There are lots of accounting transactions and communication as well as workflow involved. The current system uses over 500 separate progs and over 400 text files. We need this developed in a record time line.

I need a Mathematics, MySQL expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers.

Hi Trivikram, here is a small project for your sketches and ideas about [login to view URL]

Hello I need to create website based on other website. All pages will be the same. There are around 50 pages on the website but all text and few photos - mostly copy and paste. I will need to add database in the site so people can enter tracking number and search and find the info of my database. I should have the ability to DELETE EDIT any thing in the database. I will provide you with design of the database. So in other words, the only you thing you have to do is integrating the database all other things will be copy and paste. if you read everything and are interested, please apply to this job and write the following phrase ( I read all details and I am interested in working). Also write estimation on time needed to complete the job. Any bid that exceeds the budget will not be considered.

I've got a problem with encoding in my SQL database. It has got encoding problems and needs characters replaced. You should be able to automate it and fix it pretty easily. German "Umlaute" (unicode characters) are messed up and need to be fixed. The problem is defnetly in the database.

Hi Kevin L., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need an Android app. I would like it designed and built.

I need you to develop some software for me. I would like this software to be developed using SQL. I have attached the requirements. This is going to be very general but of course will be keep updating once production starts and also per developer requirements.

Tenemos un cliente que tiene un Exchange Server en un SBS. L o que se requiere es pasar la base de datos de exchange actual a la nueva versión, así como dejarlo completamente configurado y puesto en marcha

I work in the audit sector. I require a database of audit entities (one particular business eg Fordham School, Kings Mart). The database can be in any language,format but needs to be simple to use for end users. A user should be able to able to add an entity to the database. The properties of the audit entity will be nature of business (once added will be saved and available for use later on for any other entity) audit period ([login to view URL]) audit observations (each entity may have any number of observations, can be added and edited as preferred) internal reference number for system for each objection. for each observation, there should be an option to update it, so future compliance can be added to the observation, without changing the original.(appending compliance and answers to the observation) observations will be rich text format paragraphs,tables,bullets the entire data should be capable of being exported to csv format.

I need Clinic Management System Project

[login to view URL] En el link esta la documentación y el código de la plataforma, se requiere instalarla y evaluar las funcionalidades en un ambiente de prueba, para esto se debe solucionar el hecho de que no se proporciona el script de la base de datos, posteriormente actualizar las versiones y resolver los errores no críticos en la instalación. Se necesita esta actividad para el 25 de Junio.

Main Tasks: 1. Preprocessing of databases. 2. Connection of databases - solution (partially solved). 3. Create a scalable, easy to update data warehouse, with all connected databases (MySQL, Oracle etc.) 4. Data visualization (construction of web application or use of Powerbi, Tableau etc.) Before collaboration, a phone call or Hangouts meeting is needed so that we discuss further details and check collaboration feasibility.

I am using sql server 2012. My client is using Oracle 11g r2. When data will insert in Oracle DB, same data should be trigger in my sql server DB.