I HAVE SET MATRIX TABLES AND WOULD LIKE THEM TO BE CONNECTED WITH DB tables to receive data. i would also like to apply commissions plan this need someone with codeignator skill
Looking for a sql developer to help 1) prepare data in SQL View or table so that I can visualise the data as a 'Network Chart' in Tableau. The chart should show Territories with Countries, Companies and Contacts linked. Please see this video to help explain how the data should be prepared :[login to view URL] From the video
hi there we looking for long term person who can create html table email signatures please do sample on your own server atatched and let us know what oyu would charge per deisng like this as we have a few thanks
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
Hi! I've already spent the last couple of days developing a page similar to [login to view URL] but it has been...[login to view URL] but it has been giving me some headaches getting it to function how I would like. I would like a developer to build a comparison table similar to the one shown on offers.com.
Hi there, I require a program/application that scrapes data web pages from 2 websites and inputs it to a table format in the program. The pages data will be scraped from is determined by the user input of 3-4 letter codes. User interface for the program will be fairly simple with rows+colums and settings such as save, insert row/column and which data
I need someone to write a simple sql query to copy fields between tables
I want a plugin that allows for a variable table to be added to Woocommerce products. Just like this example site [login to view URL]
I need to recreate the size variation table from this magento site but in WordPress/Woocommerce [login to view URL] Preferably using an existing plugin instead of custom development. Let me know if you have any questions.
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
Hi there! I'm looking for a project that will open a content-link in a html, after this it will check in a table in the source code how many specific word appear and if it's > 3, the script will back to the first page and click in a specific botton. It should loop at each link (it has several links on the first page, and the procedures must happen
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
...2010), and place those into a SQL Server table. I would therefore like a powershell script that populates a table with: Username, EmailAddress, PrimaryOrAliasIndicator. The script will be run as a scheduled task once per day. Therefore, it should run without user interaction. It is quite ok to delete the table and re-enter on each occasion, rather than
Our business is called Connect the Dots Digital. We help CEOs and subject matter experts improve their sales ability through LinkedIn. We are creating a lead magnet tool that will allows people to download their current LinkedIn connections and then run them against a simple analysis tool. While we want it to be helpful and to look professional (e.g. a few charts), this is a very simple analysi...
Need GET and PUT APIs for a cloud db. GET Input: Key Process: Check a db table for the key and find associated column value for the key Output: Value PUT: Input: Key, Value Process: Find row of the ke in db table and replace the column data with 'Value'
This is just quick lookup of values from one table, finding the corresponding value in a second table, and then replacing it for the original value. The only issue is that the original values are part of a single field, so the field needs to be parsed first, the value substituted, and then reassembled.
We need you to export a particular table from a sql_file, which we will provide to you, to a csv file. We are having issues to export the file, since the data contains several signs like commas, semicolons, etc, so we can not define a good separator.
Hi, We are seeking a designer to help us with matching place cards, table numbers and pix card for our wedding. very simple. There will be 97 people at our wedding. Our theme colors are nude, blush, white, gold. Our floral is greenery, so a little green may be considered. Place Cards: - Must be self standing, fold in the middle - like a tent - White
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.
I have a table that has 5 fields. MyTable (ts int, pid int, pfc int, psc int, spt int) The table stores unique records. I mean no record will present in the table twice. The stored data essentially is grouped by the "ts" field. I mean all the records that have the same "ts" value can be considered a single group. The task is to write a SQL statement
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.
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.
SELECT [login to view URL], SUM([login to view URL] * [login to view URL]) as price FROM Customers INNER JOIN Invoice ON [login to view URL] = [login to view URL] INNER JOIN InvoiceDetail ON [login to view URL] = [login to view URL] group BY [login to view URL] I CAN"T SEEM TO GET THE Customers.Firstname...etc... because of the SUM... I can get one or the other but not both...
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...