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
Takes incoming customer calls Makes outgoing customer calls/Sales leads Answers questions abo...issues as necessary Maintains working knowledge of products and services sold and keeps current on industry developments by reading current news or attending workshops May specialise in inbound or outbound telemarketing or in sales for a particular industry
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.
Established in 2016, we specialise in design and delivery of a high-quality training solutions as well as bespoke programmes together with the ongoing management of learning and development to enhance potential and develop new skills within any team and any organisation. Experience of our trainers spans a wide range of industries and includes companies
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.
We are seeking experienced so media marketers who specialise in social media account audits. Each audit will require you to review a clients social media accounts, reporting on what is good and not so good. You will be required to produce a detailed report for each social media account with recommendations and top tips for improvements. (These must
I am looking to learn advanced MS access
I am looking for a help with my database with Query / Report /etc
I am creating a blog on behalf of a Retired Divisional Manager from one of India's biggest Government General Insurance firms. The Blog will specialise in content on Insurance, General Insurance including auto, home, and other material insurance types. I am looking for a content creator with a knack for business writing and thorough knowledge of SEO
...to: Cover many disciplines, such as sale and purchase, dry cargo brokering, tanker brokering or container brokering. However, it is more commonplace for Ship Brokers to specialise in one particular area. Handle typical responsibilities of a Ship Broker would involve marketing of tonnage (ships) to customers / shippers / charterers. Negotiate spot/time
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]