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 will provide a list of categories based upon the ebay categories for bulk upload into a Wordpress Woocommerce store. Must have prior experience and knowledge of what plugin to use. The Categories are listed in the CSV List as follows: Motors > Parts & Accessories > ATV Parts Motors > Parts & Accessories > Apparel & Merchandise Motors > Parts &...
i need an app which can register activities and enroll activities for kids. everything in an app will be like a message block, so ...message block, so we have activities block, message block, and social media block and everything can be shared and send through. i also hope there are calendar function so parent can share activities and join together.
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 [ログインして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.
...you to fill in a spreadsheet with data.I need departments, categories and subcategories for a marketplace (sells all product) entered into a an excel spreadsheet along with all the filterable options. This needs to be carefully thought out ensuring all departments/categories/sub categories are entered. Ialready have a file with 80% of the data, which
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