I need someone to write a simple sql query to copy fields between tables
...restriction levels for Admin, Viewer, and Enroller). This will allow certain users to make changes, and view certain columsn. each user level will be able to access and view certain data. All this will be based on the 26 colums of the excel sheet. We will inform you which user lever can view or edit which column. In addition each record should have a status
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
...impressions, CTR (click through rate) and position for a fictional bike company called "example". This is example data downloaded from Google Search Console about a fictional bike company called "Example". Google Search Console allows us to download data about our website to see how we are ranking for given search terms. To explain the columns if you are not
...project are based on SMS (School Management System) which is manage all Student record And Storing the data or information of School Department,i.e attendance, Subject record, and parents query or sending the message to student parents for complain or any query from [log ind for at se URL] on..this is very usefull for SMS. it is developed on the PHP technology and
...information. The code being read will be a primary key that will be used to query an already prepared viewer in the MYSQL database. The resulting data from this viewer will be presented to the user as shown below: The user can only consult the data, no change is allowed. All data manipulations will be performed at the rear and will not be the responsibility
...have installed M1 EE and I want to migrate only the data (products, orders, customers, categories and etc.) to the clean M1 EE. When I ran the installation over the CE database I receive an error: SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '381' for key 'PRIMARY', query was: INSERT INTO `catalog_eav_attribute` You will work
I need you to setup / create a form within caldera forms plugin. The data needed for calculation comes from givewp and affiliatewp plugins user data plus a user input (a floating number field in the form eg 0,1). The calculation for the affiliatewp processor [Total] field is: (givewp total donated + affiliatewp unpaid referrals) * user input After
NAME: DentaKNOX Its combination of two words (Dental + KNOX) This logo will be used for professional SOFTWARE FOR DENTAL CLINIC MANAGEM...This logo will be used for professional SOFTWARE FOR DENTAL CLINIC MANAGEMENT having features to register patient/record patient treatment data etc. It will be cloud based software. Feel free to ask for any query.
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.
Looking for an XLS (or what might work better) for the...would then be used to populate a master xls, If I am looking for a bartender for Tuesday night in DC, I should be able to query bartenders, DC, who is available that night and contact them. It would be ideal for the initial data entre to be web based, that info would then feed to our master xls
...our inventory quantity), plus a checkbox based upon sql query results we will provide. Add 3 buttons with the indicated functionality to the window, Pause, Remove, Un-pause. The buttons will interact with our Google PLA products and apply the indicated results to product listings. Amazon data will not be affected by the buttons. Using ftp for the change(s)
We are looking for a junior PHP Developer responsible for managing back-end services and the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You
...to upload too much data to backend functions in site taking more than 10sec to load : [0x00007fae60e15320] query() /srv/[log ind for at se URL]:25 [0x00007fae60e15220] query() /srv/[log ind for at se URL]:84 [0x00007fae60e150f0] query() /srv/geekmagazine
I have a quick issue I just need some advice on Fixing or a slight change of code. JSON Response is being presented to the app however, it won't append to the Dictionary that I'm trying to use. Paying a maximum of $30AUD for this as it is a quick code fix. Just needs a simple fix.
...to build an elegant front end for the project fellow the data from of this API sample: [log ind for at se URL] and one of the searching functionality should include by adding URL [/Im_raw_sql_query/?query=text] like this : [log ind for at se URL] The job only has to deal with the front end presentation
Select rows to display the columns: name of product/service assign alias as “ProductService”, quantity sold of product (invoice detail), employeeID who is assigned to the invoice; where the employee ID equals 1; sort by name of product/service ascending.
Oracle identity manager product using Dbat connector back end is Java and Groovy for connector configuration and customization Groovy is used ...configuration and customization Groovy is used to connect to target database table and join another table and generate required output. Use groovy script and query table to fetch data. Query is available.
SELECT [log ind for at se URL], SUM([log ind for at se URL] * [log ind for at se URL]) as price FROM Customers INNER JOIN Invoice ON [log ind for at se URL] = [log ind for at se URL] INNER JOIN InvoiceDetail ON [log ind for at se URL] = [log ind for at se URL] group BY [log ind for at se URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the othe...
...of mobile apps, web apps, and A.I. - based analytics *Design, implement, test, and maintain REST APIs *Craft robust QA systems to ensure product and data quality and reliability *Design schema and query optimization for databases (PostgreSQL, NoSQL) *Design and maintain required software version controls *Standardize processes to maintain clean, testable
This work involves a pdf file of shipping labels with multiple pages that needs to be sorted based on a reference number in a text file that matches a label/page within a pdf file.. ie A list of alpha numeric letters/numbers are given vertically in a text file that need to be searched within the pdf file and as the pdf file finds the queries within its pages (which is one per page), it creates a n...
I need someone to edit and Excel VB script that we use to refresh query data. We need to insert code to also update pivot tables at the same time. We believe we have found the correct code at: [log ind for at se URL] We just don't have the inhouse expertise to add
I want a tool which will download all the candlesticks data from [log ind for at se URL] view.com. It should also download that candle is green or red. Also values for all indicators at a point. so probably should query next pattern and get values for them.i may want to use it for my website.
...small reports, and for each of them we need to get: a. SQL query/SP that will fetch the data from tables. b. C# code for the Web Services which will fetch the data from DB and provide them as a data structure c. XAML code for one page of the mobile app that will call the Web Service, consume data and display it in the report. [We are using MVVM structure]
...between (1990 -2010)? • Which countries had the lowest density in 2000? • Which country is going to have the biggest gender imbalance in 2020 for 18 year olds? • Provide a query to get the first 3 letters of the country name and the country area concatenated (e.g. fin_303815) Now that you’ve familiarized yourself with the information, provide a recommendation
I need you to build a landing page. budget 600 Rs
...basis in the excel or in the database. 3. deploy it in the server and should able to download it or updated it in a daily basis. 4. Run the select query where promotion_id =" text%" and insert the data into the excel. 5. I should able to download and upload the all the reports in the database ( of-course corresponding tables need to created). we should
...name is John Conlin and I am the owner of Contingent Fitness Training. I want to have a wp calendar created from mysql data. Need a wordpress page to display a calendar with values from a database given a userID. This is the Query to get calendar SELECT cft_fitbitheartrateday.activity_date, cft_fitbitheartrateday.heart_zone_type, cft_fitbitheartrateday
...Quẻry from code. SQL Query have to put in procedure. --> use CALL name ( [ argument ] [, ...] ) Ref: [log ind for at se URL] 2. SQL Procedure Generator: Procedure will be gennerator from Input.1 condition. 3. front end: View/ Search/ Create/ Delete/ Update (GUI: Data View with multi page display, 1 page ~ 20 line data) Ref simple GUI: https://github
...full product development. Project: The purpose of the web-based application is to enable users to browse, compare, review, and purchase products. The back-end will need to sort data and receive calls from the front-end. Requirements 1. Use MEAN Stack a. integrate API’s such as google maps, Paypal, email, etc., b. Supports front-end development using HTML/CSS/Angular