Hi I have a query which I use in SSRS report builder 2016 to display results in a chart. Query is ok but I would like a column being pivot in the query and have never done this before. Should be less than an hours work and your need to work via Any Desk on my system to change the query. Get in touch if you can help. Thanks, John
I have 2 Spreadsheets that I have attached - Data from these 2 spreadsheets will need to fill in the 3rd spreadsheet.
...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 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.
This is an existing /running website built using Java, Jsp, Angular js, Query, and MongodB as backend. It needs to have My Eclipse, Tomcat 7 and JDK 7 to run, We need to enhance its look and feel and few very essential functionality as mentioned below. Working experience on any payment gateway (credit card, debit card, ACH transfer processing) would
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
I have two queries that work individually. The first query creates a list of records. The second query selects the latest entry for each id of the first query. I want them joined so that it will operate as a single query.
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...