...new table off the excel sheet we run a query to capture unique values using combined Inst and Mid query to extract unique string from excel field. I am encountering a challenge that the table I create from the above query has hidden charachters (?) I only see this after I export it to a text file. I need a query value to clean this up. I have tried
i have a sum query i need that a group by field should be based on a if statement purpose = i have two warehouse's but dont want each item to show double only if its not there in the first do i want it to show from the 2nd job will be done by loggin in remotely its a query based on other query the whole structure might need to be redone should
I need a SQL expert to create a query for me that will display a category list for me in a specific format. I will provide more details to a qualified bidder. Project budget: $30 Delivery Time frame: 1 hour
I am looking for people who can ge...am looking for people who can get me Direct Client (No Brokers, No consultants, No Middle-man) who outsource telemarketing campaign for my call center. It should be B2C(Business to Customer) process only. For example i am looking for clients who outsource Health insurance senior, auto insurance, final expense etc.
I have a php page that is taking a long time to execute and in addition in some cases its timing out. I need the mysql query optimized. ** Note: Plz only bid if you can start now Give me a guideline of how you will manage to do it. Provide of how long you think it will take you For your convenience, I've uploaded the file
Looking for someone to create a simple table that pulls and displays pre-sale and on-sale events from [login to view URL] via their API. Had one created by someone using Pythonanywhere but no longer have access to it. Should be a fairly simple project. You can use any language you prefer. I just care about the end result.
I have a mysql query that with large data sets does not complete. I need a mysql expert to tell me where the bottlenecks are and revise to complete faster. With the largest data set, current run time for a limit of 5 rows is over 3 minutes. With all rows 9,000 plus it does not complete. Attached is the query code. I know some variables are missing
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
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...
Hi I am after a company that can provide full service like, Website Design/ Website Maintenance/ Creative Design/ Marketing Strategies, SEO / SEM / SMO and Google Analytics & Reporting. We have current work and new work all the time so we are looking for a long term relationship for ongoing work. Please contact me only if you offer all of these services at a cost effect price, all work is in N...
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
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
I need web developers with expertise in wp, HTML, CSS to outsource my projects. I am basically outsourcing jobs. I need lowest rates possible for static, responsive web designs.
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...
...employee was fired for her engagement to a Pepsi employee.” "A Chinese woman stripped naked in a mall in 2015 because her boyfriend refused to buy her an iPhone 6.“ YOUR TASK: Outsource best facts in the internet, by finding the facts on various websites, such as Reddit, Facebook and such. You need to find the facts that got a lot of engagement and interest
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
Here is an example of the service [login to view URL] I will be offering to my clients. I am looking to pay outsourcer a monthly retainer for providing this service. The services are helping clients get 20 - 30 highly qualified prospects each using Linkedin. The client will be paying for Linkedin Sales Navigator and any automation tools.
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
I'm looking for a .NET/C# developer to learn/build into an existing .NET/WPF console the ability to run/monitor ...execution of a utility that queries data and formats output. The system uses 0MQ messaging to communicate between components. The database is MongoDB, but MS/SQL skills may be needed to format output for SQL-based analytics applications.
i want to have an application written for the attached api that will run a query every fifteen minutes on ~35 airports and every time a plane is delayed for more than 1 hour, 2 hours, and 3 hours (either taking off or arrival) to send me an email for the flight which is delayed saying "#name of embarkation airport# #airline company# #flight number#
I just need a new query built in MS Access db. I have 'visitors by month' in one table yyyymm and customer orders by yyyy-mm-dd hh:mm:ss. I want an Access query built that can count the orders by yyyymm and show the visitors by yyyymm. Can you do it? I need quick turnaround. 1 hour max.
Hi, I am looking for an expert SQL query designer who can develop a SQL query as per our requirement. We need to calculate Last 30 edited for each row in a table. For example, for for 31, it should be from 1-30, for row 32 it should be from row 2-31, something like this. See attached excel for example. It's quite urgent, so serious and experienced
we want to take best time result for our query.. at the attachment you can find our sample code. Sample code description: when you click load data button, we are keeping data in "list object". when we click problem1 button , we are query this "list object" with with "where" and we are creating "new list object" this process is taking 8 seco...
I need an sql query that will format all phone numbers in a table column and remove any characters(parentheses, dashes, and dots), and leave only numbers. I think there's 2 tables this needs to be done in.