Precisamos de um especialista em SQL e Query em SQL. Temos um site desenvolvido em PHP (sem framework) onde ele realiza algumas querys em SQL. Entretanto, os bancos são BEM pesados (cada banco tem em torno de 500mb, com 2 a 3 milhões de linhas) e isso está tornando o site um pouco lento. Precisamos otimizar essas querys e o banco de dados, seja na utilizaçã...
...pontuação deles. A pontuação deles é feita assim: 1 ponto por entrega e são retirados pontos caso haja algum desvio de conduta Precisamos de um calculo automático disso em uma query Informação do folheteamento fica em 2 tabelas no BD 1 Informação das entregas fica em 1 tabela no BD 2 informaç&atil...
SELECT distinct [MISTERCHEFNET].[dbo].[Lojas].[Nome Loja] as 'Loja' ,c.[Código Vendedor] as 'Código Entregador' ,a.[Nome Funcionário] as 'Entregador' ,c.[Data Caixa] ,c.[Data/Hora Vencimento] ,(c.[Tempo Total Entrega] - c.[Tempo Preparo]) as 'Tempo Entrega' ,c.[Tempo Preparo] ,c.[Tempo Total E...
Necessito de um Modulo para Joomla. Funcionalidades: 1) Formulário de Pesquisa com os seguintes campos: Tipo_De_Negocio, Tipo_De_Imovel, Tipologia_Min, Tipologia_Max, Preço_Min, Preço_Max, Distrito, Concelho, Freguesia, Localidade, Referencia. Neste formulário deve ser tidoem conta que: - os campos Tipologia_Min, Tipologia_Max que correspendem a Limite minimo e ...
The project in its first stage consists mainly in information collection about platforms like amazon and technical questions related to it, the end goal of the first stage is report that contains all the needed information for the project. Afterwards, some programming skills are needed, especially web skills, some key-words : API requests ( most likely REST APIs), data processing, etc..
To maintain a level of service and professionalism as expected, by the company, of the jobholder Ensuring that all procedures are documented and updated as required To handle queries relating to data entry in a timely and professional manner (Stop & Fix Queries) Any other duties as assigned by Management
Probate Search State of Connecticut Create a Probate search site for all counties. Need to collect the following fields: 1. Probate Filing (only 1 record per filing) · Probate Case · Probate FileDate · Probate Status · Probate Type · Probate Description · Decedent Case · Decedent FullName · Decedent FirstName &m...
We are looking for someone who enjoys helping others learn and grow, who has a relentlessly positive attitude, who is always a step ahead of those around them, and who can roll with the punches in a dynamic, fast-paced environment.
Hi there, I need a Web Service to be built using PHP or Python. It would be a Scraper that would scrape google images based on a query and provide a link to that image in a REST API. I want to control the limit of results returned in the first request and when the limit is hit, return further results. For example : If there are 50 results in total
I need some help with internet marketing.
we have a drawing that is a set of monkey bars for gym in a private high school in Texas, and we need our drawing stamped by a structural engineer,
The website is fairly easy, 'standard' ASP with '__viewstate' and the usual, so the php-curl script needs to set the cookies and use those variables. The script needs to login, post (or get) a value in a form with a single text input, and get the result, which is 1 sentence, 2 sentences or 3 sentences, always in the same position. The script needs to get the value from a csv fi...
Need little help with coding In Office 2010 I want from Excel make query in Access. The accd is already open. In Excel I code: Public Function GetCollOntvInBoho(Dosnr) As Collection Dim AccessApp As Object, SqlBoho As String, rsBoho As Object, Coll As New Collection Set AccessApp = GetObject("X:[login to view URL]").Application If Not AccessApp
I wan to build an HTML Page, reading from MS SQL view or query with a filter control to filter data, and to be updated from same MS SQL view or table
...Dynamic Query Builder with JSON as input 1)Use Standard SQL in Google Big Query 2)Define your JSON input file . Parse the JSON to form the exact query . When two or more tables are involved Create View and then Query on the view 3)Use filters for where conditions and also keep in mind regarging Aggregate functions while building query . 4)Use
We would like to have a web page which could show our client’s purchased records. The input keywords will correspond to the SQL first and then show the serach results on the web page.
I am a romance author and looking for a query letter to send to literary agents for consideration for representation of sub-rights management. My author website is [login to view URL] and the book I'm submitting for is Sweet Promise, the first standalone novel in a trilogy (the stories of three siblings). I am only looking for someone
Hi Freelancers, I have more then 40 pictures that need to be retouch/color enhancements adding sky if needed etc but result come out should be very professional. this is the first batch of a lot of images. You must make 2 sample before i award you the [login to view URL] write 'READ' if you read this description otherwise you will ignore. EXAMPLE :[login to view URL],+listed+by+Sotheby...
We are looking to hire a Senior Manager, Technical Accounting & Compliance. This position is designed for a strong team player who enjoys researching and analyzing the various technical accounting issues and overseeing compliance work related to internal control. This individual will assist in establishing and maintaining accounting policies, internal control documentation, best practices ...
...a website which we sell online adult professional license courses, which are required to be reported to the state. But right now, we have to use a tool and manually upload a file to the state tool to report our completions and then the state of Florida emails us a confirmation back. We have a MYSQL database and a PHP website that uses Captivate courses
I am buying a land in taluk place in State highway in bagalkot so I want to offer for a partner for 75% sharing it's all 5 crore estimate
Product Overview Utilizing existing MLB Weather query tool database as the source for historical team performance, we will create a predictive analytics tool for current day baseball games for each day of the MLB season, for all active games on that day. Product Deliverables • Responsive web application which provides pre-generated game-day MLB statistical
I making website farmer query system which run on localhost in visual studio(ASP.NET). i have a database on farmer query system which is connect with SQL SERVER . But problem is that answer is not display according to query text . 1. Answer display if i type whole querytext as it is in website . if i use single space and single upper case or lower
title sums it up quite well. We have 100k URLs that look like this [login to view URL] to look up products we offer for a particular make/model. If I understand correctly, google is treating all 100k results from our single asp page as 1 page so each result has virtually no juice. I need a pro that both understands SEO and know hows to convert above urls. but that can 1st advise authoritativel...
Small business with a 750 GB MS SQL db - need online trainer on Query Plans / Query Store to three developors. Must be able to provide this service in 1 - 2 hour sessions in Australian work hours. Have practical examples and database to test on.
I have an issue to query from same table to fetch some data select GuestNote,FName,LName,GuestID,[login to view URL] from Ondemands inner join Users on OnDemands.UserID=[login to view URL] where users.userid=3 and users.password='4201' and status='1' this return : FName,LName for userID=3 and return the GuestID which has FName,LName from same UserTable
***** No c/panel logins given don't ask.. Project for files only.. ***** Won't hire you if you can't abide...in-line in safari but scroller menu is there.. And in Chrome all images are inline but missing scroll menu.. Need the CSS fixed for multi browser.. Fix #2. Need to create a query and fetch the date uploaded like the format you see in shot...
Gate and garage motor control. Motors control the gate and garage door. Both garage and gate have two limit switches(located ...anywhere inbetween the travel to the two limit switches. if the serial key 'S' has been pressed 2. Add code for system to detect this new STOP state and wait for next serial input. .(this code already has state detection)
Real State Site: only design and bootstrap template. No need to add functionality Landing Page: -Search property by: type, operation, by location -Search on map -List of newest properties Main Page: list of properties, plus map. Filters to search properties Other pages: The company Agents Services
Hello, I need to start google adwords and fb and instagram campaign for real state landing page for inquiries.
I need a formula/query in Access that will give me the same result as the attached excel file for column B. This would be in an update query where B would be the calculated field. In excel, the formula would be Countif(B$2:B2,B2) and would drag down so that the result would show the number of times that field has been seen above. I have millions of
This positio...transactions, and automated services using a consultative approach to uncover needs interviewing and processing loan applications that lead to the sale of Sun East products. UNITED STATE ONLY***AND MUST BE PROFICIENT IN THE USE OF COMPUTER SOFTWARES. [Removed by Freelancer.com Admin] We'll be waiting to hear from you. Kind Regards.
I need someone to write a query to map a score to a letter grade and that letter grade to a gpa and then print out that gpa. The score is not stored in a database it is generated from a formula in the report card file but the letter grade and gpa are stored in the database in a grade scale and each grade scale has a school id. The correct grading
***** No c/panel logins given don't ask.. Project for files only.. ***** Won't hire you if...would display and it does display but with some errors....Also my input for that link to get it added to DB is not fetching properly, possibly id name not correct but insert query may be right. See Shots. Pages are in my Admin panel so i'll do the testing.
Create a usable database to easily allow our customer service reps to find gear across the country that we need to sub-rent. Have to be able to add items and "v...easily allow our customer service reps to find gear across the country that we need to sub-rent. Have to be able to add items and "vendors" of that gear. Searchable by city/state and item
Hello How are you? I am looking for senior graphic designers based in USA. If you are not from USA, don't apply. I will decline. Please apply with your recent works. Thanks.