We need a mysql query that gets records from 2 related tables: Table one: "NAMES" STRUCTURE: ID (int) auto increment and primary key NAME (VARCHAR 240) Table two: "RECORDS" STRUCTURE: ID (int) auto increment and primary key IMPORT_DATE (datetime) DATE (datetime) FAMILY (VARCHAR 1) 3 different possible values A, B or C NAME_REF_1
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
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
...create a graph where for each month, you show the number of hours of lesson held to the three most important customer companies, in the last 12 monhs. You should drag into the query builder the lessons entity, the classes and the customer companies. Here I expect that you can filter lessons for date, from now to 12 month back, then you can group by month
...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
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.
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.
Hive SQL queries to query a range of thousands of rowkeys. The 1st rowkey in this case can be of the format 20170806GOLDSTANDING01a345 and the second rowkey can be 20180102GOLDSTANDING01a345 The task is to isolate the date as a range of 20170806 to 20180102 and output all the in between rowkeys
I'm looking for a SQL query on a postgres database that will find the closest road geometry and return the closest matching database record. Sample Latitude, Longitude for Lookup: 51.38356, 0.15047 51.42524,0.23797 51.40002,0.20599 This query needs to be able to handle a 1 lat/long value or multiple lat/long values It needs to search:
Hello! I have a very simple problem. I have a button that sets a recordset based on a query. For example: rs = [login to view URL]("qryName") This query has a WHERE clause where I need to specify that the records are from a certain year. This year value is pulled from a control on the form the button is located on. For example: WHERE
Query retrieval code in java for search engine. Resources will be provided. It is a small project.
Hi, I am looking for someone who would provide 7-8 monitoring query to build Splunk Dashboard for SQL Server.