Query designemplois

Looking for an individual who has great skills on creating power bi reports Experience using Power BI Desktop, Power BI Service, Power Query and M code Experience using Dax language for advanced querying and connecting power bi to azure analysis Optimizing performance in Power Query

Hello, I am looking for an experienced freelancer to help me with SQL server queries. I will test with one query first. But would use you for others if proficient. Example query: Two tables joined by one column. One of the tables contains time stamps. I want the rows split into groups whenever there is a gap of more than 5 mins between timestamps. Eg Timestamp 1min - grp1 1.1min grp1 2min grp1 6min - grp1 12min grp2 16min grp2 23min grp3 The groups will then have a column edited The size of the database I need to query is medium. I would prefer someone with past experience working on similar project who understands the particulars involved in such a task. If you think you can help me out, please let me know. Thank you!

Software that connects an SQL database to Shopify inventory and orders using the Shopify API. Take the query of the balance line every 30 minutes and subtract every incoming order from that value. When the value reaches zero make every product go out of stock till a sufficient balance is returned.

Looking for .net developer to application to remote server to do following: 1. Create folder. 2. Upload files in the folder 3. Query server for All folder and files available. 4. Download files.

Logic Go to 5 minute timeframe, Query for 1 day time frame. I want to traverse from current day to previous day If current day low is greater than previous day low as well as there are no lower lows than the current candle in the future then mark the candle any shapes. Candle marking should be based on Daily timeframe but that marking should be visible in every possible timeframe

The rendering will be in the form of a report with the list of commands and screenshots of commands, results and NiFi development + export of the nfi template Work to..._M1/ETUDIANT_M1_PART/DateRecep=202210ddHHmm (this value must be generated dynamically by nifi, (use an attribute of the flowfile with a date value in the requested format ex: Variable_DateRecep with value DateRecep=${now():format('yyyyMMddHHmm')} Do a select on the table, what do you notice? Run the following sql command Msck repair table DATABASE_M1.ETUDIANT_M1_PART; Copy the data (via an hql query executed by NIFI) from the ETUDIANT_M1_PART table to the ETUDIANT_M2 table so as to keep only the latest version of the file sent (used the OVERWRITE keyword and in the where clause of the select use the value ...

I have a c# application that I need to have a very simple licence key check to my databse ( mysql) to authorise the application to mysql database is built, i just need some code inserted to the c# application to check the key in the DB like this: When software is opened, it will show a simple licence form with text box to enter a user enters key the code will send a query to my DB ( mysql) to check if said key exists on the DB. If key exists= open software else= show message box " key invalid, enter a valid key " This is simply a code snippet into the existing application and a simple form needed to coonect to my DB already built, so its a small project, no crazy bids please. I will supply DB credentials for connection.

I need a quick fix now on my prestashop module, the fix involves filtering a php query of the retrieved products ( a couple of minutes for those who know php and prestashop ). I need to do it now maybe through anydesk or teamviewer

Help me fix an issue while trying to run insert query in mysql and python

I am looking to add grand totals to an Access Report using a version of Microsoft Access between 2007-2016. I don't need help with formatting the report, I just need help to add the grand totals. Additionally, the data set is limited to just a few records in the query. I JUST NEED 2 GRAND TOTALS. Maybe you need to fix the query but this is an easy task for an expert. I'm a programmer, I just have a headache. Be careful with your bid amount.

I am looking for someone who can capture data from a fetch/preflight API from a public website. For example, if you navigate to https:// www. ii. / , use the search tool for 'TSLA' the API uses https://api-prod.ii. faceted-instrument-search-results?query=TSLA and returns a JSON with fields like "isin": "US88160R1014" . I need someone who can code a PHP script that based on a query parameter ('TSLA') can display the JSON result without using a service like Selenium.

I have multiple excel files that needs to be uploaded to sql database with specifications that are explained in the document file. I have a python code that creates a sql query to upload the specific rows. I will provide the code wich its open with google connect, what I want is to create a program that will be run one time and it will upload the files straight into sql. To proceed with the project I will need to share screens with you through teamviewer or zoom so you can work through my computer since I am not able to share the database. Please place a bid if you are willing to share screens. thank you!

I need a large amount of data export from excel workbooks into a database to be allowed to query the data and retrieve fixed information from the data and queries to be then available for visualization and display to be updated real time on any given set amount of time/ information.

I am looking for a freelancer to develop a Java Swing project using the Netbeans IDE and the MQTT messaging protocol. The project should include an MDI Container, an arrangement where one window contains multiple, smaller windows, which allows me to manage multiple components of the application. I am hoping to find an experienced software developer who can help me c...an MDI Container, an arrangement where one window contains multiple, smaller windows, which allows me to manage multiple components of the application. I am hoping to find an experienced software developer who can help me create this project as soon as possible. Thanks in advance! MDI Container will Contain Multiple Grid Responsive Updating Graphs with Min Max and Current Values calculated from Query using Mysql or Ti...

I am looking for an experienced .net and c# developer to take on a data-driven application project. Looking for a developer with expertise in .net, and reactjs, who is also familiar with Relational database, who is good at c# .net core - mysql, sql. And Convert sql stored procedures to .net query using dapper or entity framework. We have two projects that will run simultaneously. We can discuss more details of the projects over a quick call. I have taken care of the database structure and need the project completed as soon as possible. This is an exciting opportunity to work on a complex and challenging project with a tight turnaround window. If you are up for the challenge and have the necessary proficiency with .net and c#, please apply.

...a freelancer to update a query that worked in older version of SQL and does not work on SQL 2019 with a specific structure. The query should be relatively simple, the query should be an Update Query. the freelancer should have experience with SQL query . This project should take no longer than one day to complete. Select TOP 1 Value INSVALUE From [Project_320].[dbo].[Installation] WITH [NOLOCK] WHERE [INSSECTION] ="DISABLED" AND replace ([INSIDENT],'-','') ='$S_DATE$' The Select statement above used to return INSVALUE of 1 when the INSIDENT equaled the system date and no longer works, something has changed and I am not that familar with SQL. The format for INSIDEN is MM/DD/YYYY 12:00 00 AM and the value of ...

...enhance an existing product search module for our e-commerce. The primary objective is to improve the functionality, user experience, and overall performance of the search module. Scope of Work: Autocomplete Feature: - Replace the existing overlay panel that appears upon clicking the search bar with an autocomplete dropdown list. - Display a list of 10 suggested products as the user types their query, dynamically updating the list based on the input. API Integration: - Maintain the current integration with the external web service for search queries, while optimizing the API calls and effectively displaying the search results to the user. Search Results Display: - Upon pressing "Intro", display search results in the article listings hook, maintaining the order ...

Required expensive knowledge of power query.

...com/pjsip/pjproject/blob/master/pjsip-apps/src/swig/java/ ) So the app has to work on a desktop (windows, linux, macOS) and have to communicate with a SIP provider only. e.g (we will share you a fully working sip account after award) Later (not scope here) ports to iOS/Android required too The caller-URL contains some query parameters, like the callers number. The app can run only one instance and is listening to incoming calls. On incoming call it triggers a browser open of the above caller URL like The full SIP environment will be: - your SIP app, connected to the sipgate-account - optionally other machines also running your SIP app on multiple desktops - one or more SIP

I'm looking for someone to create a sequel query on 17 March. The task would require the use of Azure Data Studio, as well as any reference materials necessary to complete the project. The completed project should be delivered in a SQL Database format. The right freelancer should be able to efficiently create a sequel query based on the given instructions.

...proposed modeling, a relational model of the database, by specifying in a concise and precise way the passage to relational. Then, you will implement the relational schema with a DBMS of your choice. You will define the domain constraints. You will insert, in the database, a minimum number of tuples, but sufficient to illustrate the possibilities of the application and test the queries 3. Predefined query requests You will propose, at least, 10 relevant queries of various difficulties in relation to the general application, and you will give the expression in SQL. The queries can be stored as a view or as a text file, so that they can be reused. Project progress and deadlines This project will result in a clear, concise and comprehensive report, containing at least the followi...

I need to have a script that accepts a parameter as input. The parameter is a 6-8 digit code, this code is used to query a table with 2 fields, code and Valid. The field valid can have 2 values 0 and 1. If the code passed has a 1 in the field Valid then a green square is displayed, if the Valid field has 0 in it then a red square is displayed on the field. If the code passed has no record then a message is displayed "Invalid Code Used or Code has expired"

Sample TXT file (Sample Text ) is attached along with the Sample Excel Output/Final Result (Sample Output ). Project is to take a monthly TXT file (data changes every month, the number of records/data/rows will change). Monthly TXT files are dynamic and data changes monthly (format remains the same). Simple Text to Column will not work. Will require VBA, PowerBI, Power Query or similar data conversion type coding. Will provide a few TXT to test with before project will be considered complete and working.

I have a Williams Wavecast transmitter that shall be configured to periodically change the pairing code to ensure privacy for the audio feed. The centralised AV control system will update the pairing code shown on the “Room Controls” section of the Teams Room UI in sync with the Wavecast system. I need you to build the interface for Crestron to query wavecast and get the string that contains the pairing code

Black hat welcomedd Hey there..

We are looking for a Native Swedish speaker for sentence creation; You'll be required to create sentences for specific intent. if you are native Swedish speaker and hold strong command over Swedish language then feel free to apply.

Website related to Home tuition service. I just need responsive website UI/UX design & front end development. List of pages: Home Page About us Contact us Plan Packages Tutor Registration Student Registration Tutor List Student/Enquiry Listing Description: Home Page : Header, Footer, Banner, How it works, why choose, Features, success story counter Testimonial, (Small signup Form with OTP screen on home page at banner or tutor, student search form, will decide later), link of signIn in header, on click open form in model with foregt password screen and some other blocks About Us Page: About the website, vision, mission, director message, why choose etc Contact us Page: Query form, Contact Details and google map with office location Plans Packages Page: Registration...

We have a project that requires an audit of our sharepoint sites (no subsites) and find unique permissions. Will need to connect to PNP and audit site permissions and unique user permissions. We have approximately 1100+ sites.

#hiringnow Peoplesoft Campus Technical Time: 7 am to 3 Pm Requirement: • Ability to convert Functional Design documents to Technical Design documents • PeopleSoft 9.2 experience • Provide expert troubleshooting for technical problems. • Debug and develop SQRs, Fluid Pages, PeopleCode, Application Engine, AWE and Component Interfaces, IB along with working experience on data conversion programs. • Experience on XML/BI Publisher, Webservices • Have knowledge of PeopleSoft AWE, Security & Query Development • Experience working on Campus Solutions Modules CS module - Student Records, Enrollments, Campus Community, Student financials and Financial aid . • Work on all phases of a project – development, testing, production su...

I need a tool, e.g. MS Excel, Power query, macro, etc that allows me periodicially to download the full ICSS database with details on all ISCC certifcates which can be found at I don't need the PDF audit reports.

I need a well-designed interactive knowledge graph built with Vue2 using Apache Echarts (or any visualisation library compatible with Vue2) for demonstration purpose. The webpage should include an input space for users to write and run cypher query and a canvas for users to interact with the graph (hide the node, expand the node showing relationship with the other nodes, and display the information (or properties if you prefer) of the node). That is when you click the node, there will be three options to click. I have provided an example (neo4j) and you can completely mimic it.

ONLY DASHBOARD UI AND LOGIC BUILDER USING MAJOR DATABASES EXPERT LEVEL OF QUERY WRITING EXPERIENCE IS REQUIRED CONNECT TO START WORKING ON BUINDING CORPORATE LEVEL REPORTS Please be ready to show your skills

i HAVE ADDED A SUB QUERY TO A SQL QUERY BUT IT IS NOT RETURNING THE CORRECT RESULTS.... THE QUERY IS ATTACHED WITH THE YELLOW HIGHLIGHTED THE ISSUE... (select sum(spl. quantity) from supplyline spl JOIN item i ON = where between '2022/01/01' and '2022/12/31' and IS NOT NULL and = ) As Purchases_2022, COMPLETE SQL ATTACHED WITH WORD DOSCUMENT

We're looking for a PHP script development. The script must have basic functionality, no UI development is required. Only 2 features are needed: A) From an Knowledge Article ID input (example: KB-12345) obtain title and text of such knowledge base article (stored in Dynamics 365 Online Dataverse) B) Based on a search term, display list of Knowledge Articles IDs and titles from such query.

We recently attempted to move our elasticsearch installation, for We can see the servers are talking to each other, however the listings do not seem to be importing the site spends time running the query that should import but then fires out Notice: Undefined offset: 1 in /home/auctionit/public_html/includes/DOA/ on line 255 The sites entire browse mode relies on elastic search so when you try to browse a category you get the following error. Notice: Undefined property: User::$location in /home/auctionit/public_html/includes/DOA/ on line 212 unable to find script [listingTemplate] in cluster state We can see the Template for some reason is not syncing but cannot work out why

Necesito código html5/css para insertar imagen de banner publicitaria horizontal con media query (3 tamaños de imágenes) que permita visualizarse correctamente en diversos dispositivos móviles y resoluciones (smartphone, android iphone, tablet ipad, laptop, desktop). Necesito el servicio inmediatamente, gracias.

Require skilled programmers who have experience with influxdb and php to generate customized report format . You will be provided a sample query Report will contain header Graph generated from influx query Minimum maximum values And a table with rows containing interval data And a button to send the pdf to email address

I need a existing website for Go daddy website design . The project is a custom platform built on GoDaddy. I also need the graphic design. It should have the following feature(s): - Customization & plugins - Backup, cloning and migration - Installation & theme setup - Calendar integration - Email marketing - Bug fixes - Social media integration - Tracking & reporting I want a custom design for my website with a wow factor. I deal in 100% biodegradable jute products like shopping bags, wine bags, beach bags, tote bags, promotional bags, planters, etc and areca leaf plates and bowls that are totally eco friendly. I want my website to have a pure earthy feel, close to nature. I plan to export my products so there should be a query form where potenti...

I need a existing website for Go daddy website design . The project is a custom platform built on GoDaddy. I also need the graphic design. It should have the following feature(s): - Customization & plugins - Backup, cloning and migration - Installation & theme setup - Calendar integration - Email marketing - Bug fixes - Social media integration - Tracking & reporting I deal with 100% biodegradable jute products like shopping bags, promotional bags, beach bags, planters, wine bags, tote bags , rugs, runners, coasters, etc and Areca leaf plates and bowls that are also 100% eco friendly. So it’s important for my website to have an earthy, pure, close to nature kind of feel. There should be a query form where Buyers should be able to put in their requ...

I want to add the Nominatim utility to my Docker server to be able to search for addresses using geographic coordinates. For example, I would like to be able to use this type of query: However, instead of using the OpenStreetMap URL, I want the utility to point to my own URL base and port. I found a GitHub repository that provides a Docker image for Nominatim (), but I'm not sure if it's the most up-to-date version. When delivering the development, the developer should help me to host it on my server. They should simply lift the image and its resources, and I should be able to access it from my URL + port. Also, the installation should be done

...looking for someone to conduct an Instagram query for me. Specifically, I am looking for posts from specific profiles provided by a DB table, 250 profiles approx. The main point is to get the number of followers for each profile weekly and their new post each day so is required one-time profile consult daily since the restrictions could be hard to accomplish. In that query is required just save information about the post, the time of the post, the number de likes, the number of comments, and a screenshot of the post if possible. Overall, the freelancer should create a query in order to generate this content. Experience in Instagram as well as content creation on the platform is ideal. If you feel confident in your abilities to produce this query, do not ...

I need a well-designed interactive knowledge graph built with Vue2 using Apache Echarts (or any visualisation library compatible with Vue2) for demonstration purpose. The webpage should include an input space for users to write and run cypher query and a canvas for users to interact with the graph (hide the node, expand the node showing relationship with the other nodes, and display the information (or properties if you prefer) of the node). That is when you click the node, there will be three options to click. I have provided an example (neo4j) and you can completely mimic it.

I am looking for someone with good Mongodb experience who understands how to optimize query and performance

Access to Metabase: Access detail see 'Add new '

I need a python developer to write an automated skin trading bot on the Dmarket website. There is a ready-made Python parser that outputs json files with information about skins. Libraries that are used: asyncio json logging tqdm re statistics time datetime traceback aiohttp requests nest_asyncio To write a bot, you need to use the Market API. There are examples of query execution in different JS/Python languages on github... The main job of the bot is to analyze the data received from the API, as well as directly from the site (this is already in my parser), as well as to create orders (purchase requests [API]) for skins that have passed all the selection stages. The logic of the bot: 1) the selection stage number N is being carried out 2) a json number N is created with select...

i have an ms sql server database , i need to upload data from an query result to online server using asp.net

Build Graphql authorization , depth limiting, Cost analysis , rate and directive limiting using rust and integrate it with Apollo router , deploy it as a sidecar in kubernetes , plus point if can be deployed as wasm . This module will be invoked for every query that hits Apollo router. This is pretty basic module I am looking to build

...com/pjsip/pjproject/blob/master/pjsip-apps/src/swig/java/ ) So the app has to work on a desktop (windows, linux, macOS) and have to communicate with a SIP provider only. e.g (we will share you a fully working sip account after award) Later (not scope here) ports to iOS/Android required too The caller-URL contains some query parameters, like the callers number. The app can run only one instance and is listening to incoming calls. On incoming call it triggers a browser open of the above caller URL like The full SIP environment will be: - your SIP app, connected to the sipgate-account - optionally other machines also running your SIP app on multiple desktops - one or more SIP

This project is to design an A0 format poster based upon a two-page research abstract (attached). It will be used to capture the attention of potentially interested people. My preference is for more graphics than text in posters, as the intent of this is to foster a discussion with others. I consider this to be a marketing piece. The basic problem: "how can I find something I know I had/created/accessed many months ago?" is one that I find resonates well with a broad audience. The approach that I am promoting is to create an index of both existing characteristics, such as semantic content and common metadata like creation/access times, as well as using information about what else you were doing that involved that content: the websites you might have been looking at wh...

Query 1. Select all active users from AD where their extattribute2 value eq “AML” & extattribute4 eq “HIAS” Query 2. Select all users and the groups they belong to.