Simple XML, need some help on a path query in Oracle. Need to extract specific values from named pairs. e.g. GreenQuantity=4 <Identifier> <Type>GreenQuantity</Type> <Value>4</Value> </Identifier> See attached test script for full example. Must work on Oracle 11gR2.
I need to optimize / rewrite a database query to have fast response from server. I have a table "USERS" and table "DOCUMENTS" Page create list from USERS, and fill a monthly with Document ID Budget around $30,00
We have a gate access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of time. I would like to have a way to remove these unwanted records either in Access or in Excel and then import to Access. Within same username any record within ten seconds of the previous date and time would be removed. Wi...
I have a table that has following columns: coin_id, data_item_id, rating, created_at For each coin_id there's multiple rows from different data sources (marked with data_item_id), and rating from that data source.. but there are dozens of them. What I need is find the latest row for each data source (data_item_id) and get that row's rating. The output for example coin_id 32 should be: r...
...help me to make it working. Here is detail: Basically create and use the query string in React.JS. I built a search page using ReactiveSearch I use two components DataSearch and ResultList. It is working fine on http://localhost:9000 I like to pass the query string to it. The query string should be captured it DataSearch component, set the property defaultSelected
...abide by my project... I will only pay $10.00 milestone at end of completion. I will send file or files so you can edit then send back, i upload for tests... All i need a a query to pull the total count number for blocked column or meaning (blocked users).. Right now its showing the count number FROM probid_admin_stats or $data in screenshot that i do-NOT
We need to edit a mysql query used to exract records from 7 related tables, the query already works, we need to add 8 more fields to the result and some interactions.
we have a table where we have data saved as per MLM structure. This table has about 50K records and each child have again more child elements. need some one to make query/Stored Procedure etc to fetch record in less than 5 sec.
I need a python script that will check whether Emails are valid and deliverable via python script with multi threading. need as many Email providers as possible including gmail/hotmail/yahoo . ect
...out way. The dashboard will simply display the graphs. The actual queries will be processed in our own pages and dumped in csv format to individual web pages. The dashboard will need to call those web pages to get the data and then process and display it well. The dashboard will need to display data in column graph, line graph, line graph area, pie
...tuning help on Oracle SQL block. I have written the query myself and it works fine. I just want it to execute more efficiently and hopefully faster. 1. Query is 4500 lines, but it is composed of about 25 shorter and similar blocks. 2. It currently is executed in the scheduler as a stored procedure 3. Query updates tables on one schema, but all using “Merge”
Need to be able to search for USA addresses in DB even if does not have exact name in DB. Example: City name is in DB table is "Saint Paul" User would serach for "[login to view URL]" or "Saint Paul" and will always get the same result.
I have an existing MySQL query that takes about a couple mins to complete. I need to optimize this query (with indexes or some other methods you should know) to return as fast as a another sample MySQL query that does the same, but using different means to query. I will share both MySQL queries and share remote access to a test server with a cloned
My budget is NZ$25. I need you to review my CV and write a cover letter and a query letter, which you can then adapt for 1) a writer/editor position at a museum exhibit design business, 2) a video editing position at a tv station, 3) a data entry position at a software developer business.
Necesito agregar un query en mi model file y pasar la variable al archivo view, de preferencia solamente español para esta pequeña tarea. Me gustaría comenzar una relación de largo plazo comenzando con una tarea muy pequeña para evaluar la forma en que programas. Gracias.
I need some changes to an existing website - Wordpress 1 Bottom Slider Change (Just put the top slider's CSS Adjustment) - Size should be 1800×500 - I will provide the same size PNG image 2 Adding More pages to the Menu (Mock Up and text is ready) 3 Making the Phone Menu *Solutions* responsive (Not Coming Properly on the phone) 4. Bottom Slider should slide like the top slider 5. ...
Micro task to apply query to read price inside my model file, current query is working with static info in view section Micro tarea para aplicar un query para leer el campo de precio, el query funciona bien en este momento en la sección view con datos fijos, por lo que necesito aplicarlo con las variables en el archivo model
Looking at the schema of FormidablePro in mysql, it is not storing data in the usual format like a table but in a column for each field entry. I am looking at someone creating a query to pull information out of a tables column based on the entry id Thanks Chris
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
Hi i need to know the right query to move a list of emails from my database called "wp_mailster_subscribers" to "wp_mailster_lists" (inside there are many directory, i can create one called newlist"
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.
Query Generation: This is a one-sentence English command writing assignment project with a questionnaire survey at the end. The Worker will work on this task in the form of an excel sheet to generate verbal (spoken) English. This task will require you to think creatively and write conversational English as if you are actually speaking (Whether it's
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.
...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 format): SELECT * FROM (SELECT JOB_HEADERS_FW.*, COALESCE(STATUS_CODES_FW.DESCRIPTION_FW,JOB_HEADERS_FW.JOB_STATUS_FW) AS JOB_STATUS, COALESCE(JOB_REASONS_FW.DESCRIPTION_FW
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
...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 updated listings from the last update date time. Listings that are no longer active
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 of the item. The reason I need this app is s...
...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 is in the loop of the php. The search results
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,