Tsql xquery querypekerjaan
...with Oracle SQL Query Tuning and improve Oracle Performance. I will be using Oracle Exadata Database and therefore the successful freelancer should have prior experience working with these versions. The specific work required is Ad-hoc Query Tuning so the applicant should include relevant past work and experiences as part of their application. Detailed project proposals are also appreciated. Scenario: 4 Oracle SQL Queries that we have taking time anywhere from 3-7 minutes and wanted these to be running in less than 30 seconds. So require some one with Oracle SQL Performance Tuning Expertise to rewrite the query or Add any DB Configuration or Indexes or other Performance enhancement tips to cut that runtime down to 30 seconds or less. Amount of data that's com...
Looking for an experienced freelancer to develop an MVP for a WhatsApp-based chat platform that supports text-based query resolution, allows anonymous access, and includes an analytics system to track query resolution. The goal is to create a simple and user-friendly system that provides quick and easy query resolution for users. The ideal candidate should have experience in WhatsApp integration, database management systems, and analytics. Knowledge of text-based query resolution and security is also required. Responsibilities include developing a system that supports text-based query resolution, allowing anonymous access, and includes an analytics system to track query resolution. The system should be built in such a way that it can be easily up...
Deliverables: Query resolution - finding cause of failed reports and fixing them. Prerequisites: Understanding of the Database and Reports. Temporary access to the platform and it's elements.
We’re looking for a Wordpress professional to work with us to set up our Website. We aim to have the site designed and developed by 21st April You must be dynamic and willing to work with us as we design and bring the site to life. Budget for this Project is $250 **Theme** Our preference is to find a developer with experience using the Qwery Theme - Theme here - - Demo site - ** Do respond if - you have extensive Wordpress experience - you have worked with this theme in the past - you have a portfolio of previous projects - you can provide the level of commitment required in the next 4 weeks ** Please do not respond if - you do not have a high proficiency in English - you cannot commit to complete the site in a short space of time (our budget reflects...
...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
There is an open API provided here: I have a list of postcodes attached. I want a power file with a query that calls the API and returns all results for all the postcodes in the attached file. We will need the ability to add more / change post codes in the future. The key for API can be provided once work starts.
Hi, We are looking for expert who could help us get data on existing report in SQL server reporting services & microsoft report builder, 2 reports are currently not returning data suddenly everything is intact, we are using SQL server 2016. SQL query in dataset is not returning data as of now. connection string / some connection dataset or queries needs to be checked. There is a table created by our team in SQL 2016. We need help in getting the data from database.
Need Oracle expert and python and also minimum 3 years of experience in IT . Small task just plug and play the code. Old query replace with new query.
Hello, I have an App that will all the user to import data into a platform. I need to offer a nice list of native connectors. Each connector will have 2 functionalities: 1. Download data from a th...source: SQL Server, xls/xlsx, csv, txt (deliminated), Oracle, MySQL/MariaDB, Postgres, IBM DB2, MangoDB, TeraData, DBF, Slowflake, PowerBI, Tableau, Sales Force I require your recommendations on addtional: Azure, Google and AWS DB connectors, SAP, Shopify For DBs like SQL, PG, MySQL I need the ability to read the tables, in one function which will allow me to determine which table to import or query, In addition to building, I need documentation on how to use each the connectors. I will be constantly available for any questions you need answered. Please ask me any questions, Tha...
...Payment Choices should be like Step 4: Wallet Connection, Payment and Backend Query Phrase: "Connect your crypto wallet to proceed" Upon successful wallet connection, display phrase: "Payment accepted" Query backend and get result Display the result along with buttons to download articles Include a link to restart the process if needed. + Profile: User will be able to enter email address for notifications. + Api: Show api key and simple api documentation text (provided by us) + Documents: The freelancer will allow users see the documents created on a list and allow view and download the details for each one. * We will provide the backend api endpoints to query for each page. Timeline: The project is expected to take approximately 4-6 hours ...
I need to fix a bug in golang in postgresql query
Hi All, I am trying to run the following HTTP request in powerautomate but getting an invalid URL error. However when I run this directly from Microsoft Graph Explorer, it run fine. 1- $select=id,mail,displayname,assignedLicenses,accountEnabled&$filter=accountEnabled eq true 2- $select=id,mail,displayname,assignedLicenses&$filter=assignedLicenses/any(u:u/skuId eq 749742bf-0d37-4158-a120-33567104deeb)
Software to be created in MS Access. Office inventory database is to be created. Designing Search Operation for any item, Query and report generation etc.
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 ...
...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.
...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 Plans Package (3 Price Plans table) , Total amount to pay with coupon code apply page etc. Tutor Registration Form Page : Tutor registration page with otp screen after submit form, how it works, faq etc Student Registration Form Page: Hire a Tutor page with form wizard system example w...
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.
...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 support • Experience on Implementation and/or Upgrade Retrofits • Exp of People Tools 8.58/57; advanc...
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
