SQL Jobs

remove duplicates that come from a sql query spring boot list @GetMapping("/employee/withoutProject") public List<EmployeeDto> getAllEmployeeWithoutProject(@RequestParam int projectManager) { List<Employee> emp = [войдите, чтобы посмотреть URL](projectManager); List<EmployeeDto> dtoList = new ArrayList<>(); for(Employee c : emp) { if(![войдите, чтоб...

for first step I need someone to develop a blockchain for me

Create Functionalities like Fiverr

Good day, I'm looking for someone that can help me either build a new mysql DB or to help me copy the old one I have and make it work on a local machine via MAMP or something, as I am building a C# application which needs mySQL db to let me test and run the app.

This project is a initial work, and we will assign more work based on the performance. We will be testing the candidate skill for working and knowledge on this startup project. We will be working on a project where 15 to 20 tables to be created in a SQL database. Some fields have 20 fields and some have almost 100 fields. This project will generate script for to a) Generate table b) Generate data ...

Create an Azure cosmos trigger function and update the changed values to another SQL database

MUST BE MySQL, RELATIONAL/ DATABASE EXPERT You will need to answer all of the questions accordingly and please use MySQL workbench. Refer to the abridged data file “2013-07 - Citi Bike Trip Data” (I will give you the data file later) You are required to design and implement a relational database to help better manage the CitiBike program in New York City. [I] 1- Study the data prov...

We are looking for an On call and project based Sr. Engineer to help with Installation, Setup/configurations and troubleshooting. The engineer will need to be able to articulate solutions in a reasonable amount of time. Engineer has an expert level experience with the follow environments. Server: SQL Active Directory 2008,2016,2019 Network: Ruckus /HP Cisco Meraki Sonic Wall Access poi...

I use a software that is older and is based on Access database. I am in the process of upgrading the software to the company's newest version which is SQL server now as opposed to Access. Over the years I have built many many queries in Access to extract data and display it in Excel workbooks and some in Word. I need someone who is expert at converting Access queries to SQL. Luckily the new ...

Se cuenta con una aplicacion basica desarrollada en Access. Para efecto piloto de evaluar una futura migración, se requiere que funcione en ambiente web para multiusuario con bases de datos en MariaDb o Mysql. Se puede usar cualquiera de los metodos: - Share Point - Solamente conversión de tablas accedidas mediante ODBC - Reprogramación El tamaño de la aplicacion a t...

We are from an IT consulting firm and an online tutoring company One of our client is in need of Project assistance in Dataware house Oracle based

query optimization, and forcing query plans, and a bit analysis on query optimizer

We are looking for a developer to help with the following: a basic VB.net ASP.net webserver that is connected to a SQL DB. The Database contains 1 table which records the information from client devices that is sent once the client app is opened on port 443 or port 80. On client app (VB.net) open (load). The computer name, Hardware ID (already generated), Domain, user name and licensed email ...

Database: query plan change in response to a change in the cardinalities database optimization small work

I need someone to complete a course assignment for basic database using SQL.

Database: query plan change in response to a change in the cardinalities database optimization small work problem 2 and 3 needs to be done

Database: query plan change in response to a change in the cardinalities database optimization small work

I'm looking for someone who can work with me in completing SSIS projects. I would prefer something training/hands on real problem solving situation. It will be an ongoing effort.

I am looking to build a small application with few primary functions : 1. Build an interface to facilitate connecting zerodha kite through python. a. Read and store Ticker data into a database 2. Automate request token generation 3. Generate trades based on predefined levels reading from a database, on matching the criteria send the order to zerodha (open order) a. Needs to build flexible appro...

We have a sql database that we need help with. We need to organize the data and build lists. This role will assist the sales team.

Read the data from pdf and save to Database

Need to use loop and lookup functions to check the data from one data extension. Based on the priority the image should change in the email.

I need a developer with full experiences for making some new RP-es, some Changes in existing scripts and some Security Change for my Anticheat in lua... If you are intrested in my Project... Please write me a message

I’ve ready dedicated windows server 2012, and I’ve sql db need to be restore and create on the server and we need a link to access , so that on cloud we can access or edit anywhere the sql accounting. We need something about ip address to access my external link SQL,example [войдите, чтобы посмотреть URL]:[войдите, чтобы посмотреть URL] is another company set up for us, they set up fo...

I am looking for 5 BI and SSRS resources to work full time on a project. Please send me your resume and your fulltime salary in INR.

I have a very simple backup .sql file (including data) which is only 11MB in size. I need to retrieve the data and put it into a very simple database which can be edited online. Can someone help me?

I need someone to create backend project from scratch for my app with best architecture, good quality of code. Requirement: - Create API in Node.js - 20+ api want to build - Deploy on AWS - Low bid price is in priority - Project Time duration : 5 to 35 days We will discuss further details in chat

The mobile application needs to be finished including backend & frontend endpoints Please apply if you are full-time available

Есть три этапа курсовой работы. 1. Необходимо по варианту задания сделать Data-flow, er, df-диаграммы, создать таблицы, заполнить их данными и написать простые запросы. Остальные этапы приведены в файле ворд.

Designing, developing and maintaining business intelligence solutions Crafting and executing queries upon request for data Presenting information through reports and visualization Translate business needs to technical specifications Design, build and deploy BI solutions (e.g. reporting tools) Maintain and support data analytics platforms (e.g. MicroStrategy) Create tools to store data (e.g. OLAP c...

Need expert SQL Expert who can work in stored proc in detail but all work is remotely

HI I am looking for Need Pl/SQL needed done

I have read-only access to a phpMyAdmin SQL portal and would like to create a Power BI dashboard from this. The Dashboard will be populated from data sitting in exiting tables/views that have the data I require. I need to be able to view the data on my desktop Power BI, mobile and online.

We are working on a small MMORPG game to release. We currently have all the files needed including the source code, launcher, website, client, database, etc. They are all working, but need fixes and improvements. My team can assist the developer in understanding the project and what we need them to do. We want someone who has experience working on pc games using Visual studio C++ and will work wit...

[войдите, чтобы посмотреть URL] es una página web donde se venden murales en linea

need help with making a database and building a code with it.

I need help with making a database and building a code with it. Deliverables Add a new hotel: Create a new hotel with appropriate information about the hotel as input parameters. 2. Find a hotel: Provide as input the address of the hotel and return its hotel ID 3. Delete a hotel by ID 4. Display hotel info: Given a hotel ID, display all information about that hotel (Includes room, rates and avail...

I have an account to be handled in which you have to answer Computer science questions. You can skip unlimited number of times. out of 20,000 new questions/per day. I want only minimum of 15 questions answered every day. I will pay you 50rs/question. Also it is a long term contract. Thanks

Hello, I am taking an initiative for a startup to service Automation as a service for the IT Infrastructure. Looking for Freelancer who will help me to build use cases around multiple IT Infrastructure domains such as Active directory, Database, Backup, O365 and many more. Skills which I am looking for -Automation framework -Python (Build a playbook in Ansible and/or YAML) -PowerShell scripting -A...

SQL replication Automatic backup SQL server windows NT 64 bit memory high

I want person who can write the procedure one the given details .

I have an application in ASP.NET VB.NET, need to upload the application on Go Daddy windows hosting with SQL Server Database.

only 2 hours would be [войдите, чтобы посмотреть URL] you must have knowledge of Normalisation ,Data Modelling,Distributed Database,Query Processing, Machine Learning,Multidimensional database, Data-warehousing,OLAP etc.

Need a professional website for a school "Brave Minds Preschool". Would like you to go through this particular website which is an example. But the website we want needs to be better than this "[войдите, чтобы посмотреть URL]" Maximum time for completion is 4 weeks. Would also need a digital advertising body to do major awareness on many other platforms but that would be aft...

We are a small UK gaming startup mid build of our proprietary competitive gaming platform. This is currently being built on Ruby on Rails offshore and is at MVP stage. We want to bring the project in-house and hire a small dedicated freelance team to work for us direct. We are looking for the most competitive prices to achieve our build.

MES WMS written in c# The RMS Project is a really big big project. I will try to explain how the project is composed then if you want to have more details on something please let me know

Hi We are having an estate agency software that a programmer has been developing for us and it has evolved over time. We are now looking to enhance the features and performance of the software. I am looking for someone who works on VB.NET, MS SQL and devexpress. Looking for a long term relationship for the development. We need to have some idea of pricing and how to co-ordinate the work. This may ...

Number of Positions: 2 Experience: 10+ years Mandatory skills: • 10+ years of experience in SQL Server, SSIS/ETL • Very good experience in SQL, stored procedures, views, functions • Analyze existing code for performance improvements • Excellent understanding of reading execution plan and diagnosing issues. • Strong in Data modelling concepts • Good exposure to Azure d...

Write a stored procedure named ‘get_lots_by_method’ to select a number of tax lots using a lot selection algorithm. The goal is to select enough records from acct_lot_details so that the shares field sums up to a specific value. Parameters and values: @acct_id INT = 1, @security_id INT = 1, @shares_sold DECIMAL(28,6) = 300.0, @method = 'lifo’,'fifo’, or ‘har...

It enable student to check their result online