Hi All i have a table like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752...like attached image needs first negative balance date followed by second last positive balance means 7769 . -3752.86 2018-08-10 08:06:35 1 min job for expert send query in your reply budget : 500 INR
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.
I need someone to write a simple sql query to copy fields between tables
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 have the react webpart here, but it needs configured to work on a secure govt environment. You will not have access to my SharePoint site, it is off the grid. [kirjaudu nähdäksesi URL:n] This webpart or something like it is what I need in one day. I need the user to be able to enter
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
I need a custom "Highlighted Content" web part that has all the feature of that SPFX webpart PLUS: - allows me to change the image on the card, not pull from the page - links added go to the actual link not the Microsoft way that downloads the .url - change the order of the cards I need this ASAP
I need to create sub site in sharepoint hosted app (Client Webpart). Very simple example how to create site (Right now I have permission problem and I am not able to solve it). You must use JSOM and PNP.
Hello. I need very simple tutorial how to use [kirjaudu nähdäksesi URL:n] in SharePoint hosted app. But not in defaultaspx....No this is for me working....I need it in client webpart.... No functionality...Just how to implement [kirjaudu nähdäksesi URL:n] in clientwebpart...Of course it must it work...I have no working examples...
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.