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
I have a small 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
We are looking for a company to send connection requests on Linkedin. This would be a monthly task and will happen in specific city's that will be provided. This will include 80+ locations and you should have software to automate the process.
financial website needs project by project work done...need to fix pho line errors and reconnect data base with yahooo finance stock feed for end of day stock quotes...some other minor projects...please quote hourly rate and how hours are tracked
Hello! We are a International...retreiving us the following code: SQLSTATE[HY000]  php_network_getaddresses: getaddrinfo failed: Name or service not known As far as we know, It is related with the connection with the DB but we are not able to fix it. We have all the data to get into AWS but we need the site online again asap. Can you help us?
Build for Android - Basic concept : Users registers there profile . They will be able to search for other members connect and inbox Needed Features :...using facebook and instagram Search for people by Profile by criteria Show search results Allow users to Inbox others Show Notification messages This app is a basic connection and messaging app
Very specifically, I am looking for someone to build a job template in Talend Open Studio f...big-data-open-studio/ 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.
Hello, I'm searching for someone that can made an connection between my live Lightning info that I save on [login to view URL] and an other website where it's possible to made an new layer [login to view URL] Read Less
I have a requirement to play a custom message to a caller, that needs to be driven from a database, and is able to scale out. We will have IVRs in place, that the caller will press, which will then move to the context we are looking for your to develop for us. In side this context, you will need to look up a database, with a syntax like (callerregion is set by option the caller selects in the IV...
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.
Urgent help with Mysql - Wordpress database - Connection issue Fix the issue on [login to view URL] NEEDS TO BE FIXED TONIGHT!
ASP.NET, DDD, NHibernate, PostgreSql I'm having trouble setting up Fluent Nhibernate in my project. I currently have a fluid connection with just one database, I need to make a modification to a connection with multiple DB. After the user provides the 'Login' and 'Password', based on this data the system will search the 'Default DB' and identify
I am looking to learn advanced MS access
I am looking for a help with my database with Query / Report /etc
To begin...we started a business and one member signed our biz name up on FB & IGram under a personal account...then another member signed up our name on FB & IGram under a different name but similar...when we go into our Biz account under our real name it takes us to the personal account this member started...trying to shut it down...and have one FB account and one IGram account...help!
...PHP functional script, the IPN listener must to have the next features: - Simple option (Commented) to change between sandbox and real paypal account - Connection function to a MS SQL server Database. - Insert into a table the next fields sent it by paypal: first_name, last_name,payer_business_name, payer_email,payer_id,contact_phone,auth_id,auth_amount
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
...[login to view URL] 3. Write java code to: first connect to the db from the server side in the file MyWebApp/src/com/mycompany/mywebapp/server/[login to view URL] 4. Secondly, read and write to the db in the server-side java code. That is, after connecting, code a select statement to print the content of the db table
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.
...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. Attached is the Excel file. The first worksheet has the raw database. The second worksheet has the
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
achieve for phone to stay online while connecting a camera via wifi or 4g hotspot connection , I will provide the source code .
i have write all codes but i had problem with it ... cause am new :) so little bit of help would be , thankful 10 - 15$ just to fix my problem and sure it's easy for any experienced ppl
need a connection between my website and my phpmyadmin database
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.
...ed+rand Example perl script which performs a similar command on the same page. if con: [login to view URL]() def send_message(self): '''Sends loaded data to server. self.unknow_number and self.known_number must be defined''' br = [login to view URL]() cj = [login to view URL]() # Browser options br.set_handle_eq...
...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
...VPN connection/routing between multiple sites, where all sites must be able to communicate with each other. See attached drawing. Accomplished at the moment: PPTP VPN client in DD-WRT router location A connects succesfully to PPTP VPN server at home office. PPTP VPN client in DD-WRT router location B connects succesfully to PPTP VPN server at home
I have a logo, i lost psd file, i want some one to recreate it as psd format, with layers. should be done in 1 hour max
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.
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.