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
...project were a client of mine is moving their DB from MS SQL to MySQL. The DB is simple. I have the create script and the data and the SQL we are looking to convert. Now here is the complication. MySQL does not support the same functions as MS SQL and there for we are struggling to convert the SQL statement like for like. I have been told that to achieve
I want to run Apriori Algorithm and Decision Tree classification on the Gene mutation dataset which contains categorical variables.
I need to make a family chart that looks like a tree with different branches being different families branching out with their own families. I tried to make this myself but there aren't good templates out there. This should be a fairly simple project. I would also like The Werking Family Tree or something along those lines at the bottom. I plan to
Very specifically, I am looking for someone to build a job template in Talend Open 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
I require the latest published Amazon Browse Node file from inside seller central: [login to view URL] Although is there a new system of Product Classification these files are still available in seller central. Give me the latest. Attached is an older one in xlsx format. Thanks Read
...hash bucket should have access to the head of a linkedlist. If the size of the likedlist becomes 11 then it should be replaced by a binary search tree. On the other hand if the size of the binary search tree is reduced to 8 then it will be replaced by a linkedlist. Explain what is the advantage of this strategy? Create the rehash function that rehashes
...a file and put them in a binary search tree. Put in a printMap function that will print the form of the tree using just the first 2 letters of each name in printing the form. Print the names inorder (use passing of a function to print the node). Have it also search for a name that is in the binary search tree and a name that is not (your choice) –
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 need a Mnist digits in Matlab using CNN, Random Forest and Decision Tree.I will provide details later.
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'm a social scientist in need of some help with making my data look good. It concerns qualitative data which lends itself for visualization: networks, lists, categories, hierarchies. I will provide the data in Excel sheets, but the maps and charts have to look better than those I can make with the program. I'm looking for someone who can do sunburst charts, node-link diagrams, adjacency...
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 is familiar with Excel can do this in 5 minutes. ...
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
a WordPress website already responsive but has many issues on mobile devices and needs improving. no access will be giving you can work on the main website CSS file then send it to me to replace it. Job should be done within 1 day. Please when sending proposal make sure it is relevant to what I need.
I am looking for someone that can help us with SEO. We are getting no traffic from google, and it looks like we are not being found on the search engines. I need some one whit expert skills to see if we are being found, and what can we do to increase our SEO traffic.
*Must use D3** I want to create a family tree using the following format in D3: [login to view URL] In the above code each box has one parent. I want to change this to multiple parent so I can add husband and wife and then there children underneath.
select phone_number,from device_status where bal <>'0.00' and phone_number>'1' and updated_at > date_sub(now(),interval 5 minute) and bal < '5000' and tries < warn and accumulated < x; Some entries will be found Log into a web form *225*[number]*[rand]# where rand will be a random number in a range rounded to a certain amount. Click send....
...htaccess file already has a few hundred redirects in it. I'm currently doing a lot of standard 301 redirects in the file, but also have some URL's (maybe 50 - 80) which have query strings. I need someone who can sort out the file and use a combination of redirects to get all redirects working.. It should NOT take more than an hour if you know what
We save data with ACF( Advanced custom field) plugin I need a DB column match (like a filter would work) then sort...employer vs. Jobs skills available by user *Excel calls this a multi-column sort I was told that a separate table created in DB was best and faster???? I need the MySQL Query, the WP save, and the WP return results sorted
Necesito crear una newsletter en HTML, para enviar por correo a mis clientes. Esta debe ser responsive, creada en HTML5 y Media query, EDITABLE. Todos los textos e imagenes deben poder ser cambiados. Se utiliza Blade (laravel) como motor de plantillas.
...the mature tree (f). Diagram is to be redrawn with black lines in Adobe illustrator. Final submission would be Adobe Illustrator file and a high resolution JPEG of the art. The black line drawings in PDF needs to be redrawn with each of six panels (a) to (f) being in the same line styles. The six panels depict the life history of the tree that begins
Need to know binary trees concept very well
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
Need a Use Case, Sequence, ER diagram and sql query. Please message for more information.
I need to build XML3 Files from ERP System using ODBC Connection. The structure is for Bank Payment files. Expecting 1 hour quick job as everything is in place already.
I have Mongo collection that I need Grouped and mapped. I'll provide the details of the initial schema and the result in the file. This is one query that should be easy for an experienced Mongo data scientist or Engineer.
Description...MySQL b. php script that will display the results in a local webpage. c. a brief description of the usage of the software, if needed See attachment for more details. sql file will be provided if you are shortlisted for the project. Thanks! Reference: [login to view URL]
...following 1. First page will contain two prompts ( DRIVER / VENDOR ) 2. Second page will ask the DRIVER OR VENDOR for telephone number in XXX-XXX-XXXX 3. The third page will query a MYSQL database for the drivers or vendors TELEPHONE number and if they have done this before the PAGE will display WELCOME BACK (NAME) or if they are not in database it will
Hello, I need some help with an informix pass through query. Im currently connected to the database using access. The query below needs modifiying SELECT idc_userid as User , event_ts as hours, after_event_qty as Qty, event_loc1_text as Location, event_ts as Time, item_nbr as Item, substr(event_loc1_text,1,2) as Area FROM wms_appl_event WHERE
Hello Freelancers, I have over 3000 ACRES OF TEAK TREE LAND I am selling in the Beautiful Country of Guatemala, consisting of approximately 700,000 trees, 15 to 25 year old TEAK. This is popular in the furniture business etc. Each tree is being sold at the minimum price of 30$ per tree and preferably the land is to be sold as ONE and not by parts.
Im working on query, basically i want: if slideIndex is on int & post has tag == 'tagslug' & category = 'slug' then output posts. i have the code owrking, its just the query itself im not sure how to do. can anyone help?