YOU NEED EXPERIENCE AND SKILLS WITH Wikidata Query Service! [login to view URL] Task is to create a query at Wikidata (Wikipedia [login to view URL]) and a list of all muncipalities of Germany with the Attributes: - Land: Germany - Muncipality Name - German municipality key (P439) - Mayor of the Municipality (Name) - Adress of the Administration
Task is to create a query at Wikidata (Wikipedia [login to view URL]) and a list of all muncipalities of Germany with the instances: - Land: Germany - Muncipality Name - German municipality key (P439) - Mayor of the Municipality (Name) - Adress of the Administration of the Municipality - vehicle registration plate of the Municipality (optional
Hello, I need a query against an OrientDB graph database. The problem is quite simple, i.e. we need to calculate the cost of an assembly, made of sub-assemblies, made of components, etc. a) we need to know dynamically the cost of the root assembly "mac01" by summing up the cost from the bottom as per .xlsx attached sheed. b) we need to create/update
I currently have an multiple SQL query which I need to update to want i need (may be combine them would ideal) which is used to fill my excel file. I would then like a VBA code which run for multiple query based on the conditions and get the info from SQL server.
MS Access database with multiple tables, each table with one year sales history each, combined to a website query form that will merge data from the fields into reports showing combined totals based on selectable parameters.
...specific database queries/updates that are causing major performance issues for a number of clients. In addition, we are not currently using BIND VARIABLES in either SQL or Oracle and would seek input/guidance on adoption thereof. Our application is an [login to view URL] webforms solution. We are seeking DBA support to help on this. This is a typical query (in Oracle
I need you to develop some software for me. I would like for example someone to acess http://localhost/[login to view URL] and be able to see the data of a query that selected the sales data and display it on that page on a graph and for example have a button that the user can change location of the sale ex: Number of X shirts of certain type sold in
Hi, I have a Tattoo website in word press. I have installed the query manager plugin in admin, found few long queries running. Some query returned above 200 records, some above 40 records. About 20 to 40 queries to be optimized. Thanks.
The attached query is in Informix format. I would like to build on this query. I would like a extra column called 'difference' that does the following - if the user is the same as the previous record it will time-time from previous record. if not then null. I would then like another column called gap. If the 'difference' is greater than 5 minutes
GBL Query - 30-May-2018 Project to search a website using specified search terms and collect information from search results. Query should be automated and an easy scrape for the right user. Project includes 2,500 search terms with an approximate expected 5,000 results. Files included are: 1. Word document with instructions describing the requirements
...populate a MySQL database running on a dedicated Centris server with real estate listing data using the rets standard. The script will have 2 main functions 1. Full database download. Query all active listings (approximately 5000 results) will have to be done in batches and parsed into a MySQL database 2. Update database. The query will search for
I need a android app which uses the ebay API. I will use it on a android tablet. I need it to be able to log into my ebay to get access to just the Sold Items. The app would display a list of the sold items with just the title of the item and a thumbnail image and lastly the user will need to be able to press on the item to just view full screen images
...to search through a wordpress database to return an intelligent search that gives us lessons from an lms that relate to a query that the user types in (in an app - not wordpress) We need to be able to return the results as json We are having issues with the results being very slow to return and it may be that our query is wrong (we believe the issue
Will need some ongoing ad-hoc MS Sequel Server scripts created for matching non-unique csv datasets and outputs generated in various formats . Data-tables likely to have several hundred thousand rows each. Must have local SQL server not cloud-based due to likely urgency. PowerBI knowledge would be desirable so I can explain any schemas easily to you. Due to time difference, would prefer Europe...
Create HTML/jQuery/PHP based product configurator/price query user interface. Form will contain: 1. Inputs info about the product (width/height/additional selections) 2. Inputs about the buyer (name/address/phone/email) Flow: 1. User fills up values about the product, values are stored and previewed (ready for api call for price), once all set clicks
We seach an expert of ejs for data modelling in a browser. The data is received from a query to a mysql database
We serach an expert of ejs for data modelling in a browser. The data is received from a query to a mysql database
Need help to create a query for Postgres to know the number of products on hand, need the internal code, name of the product and the qty on the stock. Using Odoo version 10 and Navicat as query builder. I need a Teamviewer or AnyDesk, so we build the query on my computer. I believe is an easy task for someone who knows the Odoo tables, therefore,
PHP Form, Query Search, Email on Complete, database creation, export into existing excel template
Change 1 - [login to view URL] returns results only from WooCommerce store. Client would like search to return results from both WooCommerce and from WordPress pages. Query page should separate results. Example: Search: "Fire pit" Query page: Heading: "Store results" fire pit result 1 Heading: "Page results" fire pit result 2
Create a table-driven, web application in C#.net 2017, using MVC, Angular 5.0 and Bootstrap. The purpose of the application is to create a data entry/query interface that will allow users to add/change/delete data from a Microsoft SQL Server database. The application should utilize Bootstrap to make it mobile-friendly. The project should be MVC and
I need a basic tsql query for a the attached spreadsheet to produce the desired output. I believe I need a subquery to output file where; Distinct records where the status <> 'Active' Where there are duplicate records with multiple Status I need to output only one record where there are no Status = 'Active' The purpose of the report is to determine
...to create the same query outcome. I have attached 3 files 1) the create table script, 2) a data extract in excel 3) the sql we need to convert. We can connect you with our team in India who are aware of the SQL to assist in any way you need, but we dont have MySQL skills and there for need your help. The outcome needs to be query based results as
Very specifically, I am lookin...Studio for Big Data [login to view URL] that queries this SOAP Web Service [login to view URL] writing the response to a MySQL database. Once setup, I can then use (and customise) the job template at my end.
We need a single mysql query that gets records from 2 related tables. Please read carefully the [login to view URL] file before making the offer. We will provide also the 2 tables .sql files and a result table to show the result fields.
Looking for assistance on google sheets project. Need someone who is good with using google sheets for data mining.
We are looking for someone familiar or with good skills with MongoDB, Mongoose, Node, and Express. The task will be about building a query with about 40 parameters. All of them are non required so the query should work either if you get 1 or 40.
I am looking to learn advanced MS access
I am looking for a help with my database with Query / Report /etc
We are building a web that extract data from mysql, we do select with OR and AND contructs The data must be displayed in the browser as a list
From a Google App engine account, 1. Set up a new postgresql database as described in [login to view URL] That is, create a table with a few rows. 2. Deploy a Google web toolkit project mywebapp on the google cloud platform using ant in command line (not Eclipse) as described in [login to view URL]
I have a Google sheet where I keep the record of my invoices. I need to do a statement by calendar month of those invoices that were not paid by the end of ...where I keep the record of my invoices. I need to do a statement by calendar month of those invoices that were not paid by the end of the month for each month. Need to do it as query preferable.
I have a database of insurance companies. Each record (row) has multiple insurance companies separated by a comma. I need a standardized database where each unique insurance company name occupies a single row. I had a colleague who created a quick macro that scans through records like this and builds a unique table. I lost the macro. Someone who
To create a search query to find keywords / articles from 20 - 50 websites Require in about 2 - 3 days. Sort by keywords Sort by website Sort dates Process 1: Search 20 - 50 websites through Google Process 2: Search 20 - 50 websites direct Please suggest Process 1 or 2, or if both are possible. Optional Able to de-select sites
I am looking to learn advanced MS access