SQL Jobs

We are a security guard agency and we deploy security officers across many locations, sectorised into North, West, East and Central clusters. In general, there are both day and night shifts for up to 12 hours. The total number (both day and night shifts) of the security officers deployed across at each location vary from 1 to up till 30. The composition of the team at each site is made up of permanent officers as well as relief officers. The former (permanent officers) obviously will be stationed at the particular site permanently and the latter(relief officers) can be deployed at only one sites or a cluster of sites. A software vendor had developed a rostering and deployment system but we are faced with multiple issues. For example, the system is very slow due to extensive MSSQL procedure...

FIXED BUDGET! 30$ Please understand this first! --- I need one page, to acces the users camera, take a picture and read the code. Idont care if is numeric, bar or qr. I just need to read the code and see if code is available. So, read the code, get the number and see if the number is valid in database. If yes, display message OK, if not, display NO. Database table columns (id, code, status) status = 1 OK, status = 2 NO You can use only free comercial use library.

draw an Entity-Relationship Diagram (ERD) which shows the relationship (cardinality and existence) between the entities using Microsoft Access program

Explain the concept of subqueries with joins.

Tenho um banco de dados, onde possuem algumas informações e precisaria retirar uma listagem dos registros que se repetem e salvar as quantidades de vezes repetidas e informações diferentes no caso.

I have some websites coded my by me. So im searching some expert in web security, specially SQL injection for audit my sites. thanks you !

It is all about tax. We have tax collecting consultants but want to get all the records in their database to a central database dynamically. This platform will be either cloud-based or on-premise. Please see attached documents for an idea of my expectation. A simple prototype will be most welcome.

I need php script to get file content of this url then insert data to table base on the all the table and fields that I create.

Need an import and export function for NAV. IMPORT: To import sales orders to NAV. The import file will be a CSV or EXCEL, and will include 16 fields (such as customer name, address, order number, SKU, price, etc). EXPORT: Tracking feed (order number / tracking number) Please inquire or apply only if you have specific experience with programming on MICROSOFT NAV DYNAMICS / NAVISION. C/AL is the Database specific programming language, and is primarily used for retrieving, inserting and modifying records in a Navision database. C/AL resembles the Pascal language on which it is based.

I am looking for a PHP developer with decent experience writing SQL queries and server side programming.

Getting the below error when accessing SQL Server from Computer S1 to Computer S2. However, when i access SQL Server S2 from another computer, I am able to access it. TITLE: Connect to Server ------------------------------ Cannot connect to S2MSSMLBIZ. ------------------------------ ADDITIONAL INFORMATION: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054) For help, click: ------------------------------ An existing connection was forcibly closed by the remote host ------------------------------ BUTTONS: OK ------------------------------

Estamos buscando una persona con conocimientos esn asp.net, y Sql para el Mantenimiento y desarrollo de unas nuevas funcionalidades que tenemos en la empresa...

We have a cloud application based on ASP.NET, C#, MSSQL, Crystal Reports. We are looking for developers to make many customisations as per our requirements..

I am looking for a person who can help me to create a copy of the remote database into my local database. It will be an hour job. will get paid accordingly.

Necesito optimizar dos consultas SQL, ya que para un gran número de resultados, son bastante lentas en mostrar el resultado final. Las consultas no son complejas, quizás revisando joins se solucione el problema de rendimiento.

I need a ghostwriter for a 50-100 page book on SQL. The writer must have great SQL knowledge and flawless written English. A draft version of which topics need to be covered in the book is attached.

wanna increase phpmyadmin sql upload limit

Hello, For more information, please bid on this project.

Need assistance in writing stored procedure for data quality in postgres SQL for real estate data.

MCQs on Unix, UI, SQL, and python and 2 python programming questions. In programming one question is based on defining 4 to 5 classes. For example train ticket booking, atm card deposit and withdrawal, Library management system in python defining a few classes.

Have to fetch the today's total loan count and collection count from mifos application and add those values automatically to zoho books as journal entry. Technical Skills: Mifos, Java, Zoho Books

Looking to convert an excel pricing calculator into a tool that will write to allow event scheduling (under development in SQL, but also need a temp solution) and output to Quickbooks online for revenue recognition. Example, sales agent prices 10 events, need to capture this as 10 rows with name, program, price, client detail, deal number etc. this would need to plug into SQLserver once ready, but until then it needs to allow to plug in dates for each event. The dates and $ would drive revenue recognition. It would be nice if it could output into QuickBooks online via API.

Looking to convert an excel pricing calculator into a tool that will write to allow event scheduling (under development in SQL, but also need a temp solution) and output to Quickbooks online for revenue recognition. Example, sales agent prices 10 events, need to capture this as 10 rows with name, program, price, client detail, deal number etc. this would need to plug into SQLserver once ready, but until then it needs to allow to plug in dates for each event. The dates and $ would drive revenue recognition. It would be nice if it could output into QuickBooks online via API. Looking for time and cost quotes and type of solution. Calculator interface and logic with writing into a database, temp scheduling solution form, output into Quickbooks online of price times quantity based on schedul...

Database: The user uploads a video which is split on the server. Each frame is converted to a SVG. These frame are converted to a single SVG file (video wall). The video wall is converted to a database file that will load into the Godot database (the developer - to be hired - writes this code). The database file is uploaded to the game (the developer handles that part). Script: The game is controlled by GDScript (which the developer would write), however we already have the function of the game in 10,000 lines of Javascript, some of that Javascript would be ported to the GDScript by the developer. Action: The user can then edit the video as an animation. For example, a spinning tornado could be moved from one video to another. In the new video, the direction, speed, scale, rotation, and...

Hello, I'm looking for someone who can made a script for a lucky wheel that I can place where I want on the map.

Items in the System: I’m selling through a water meter. I want to know how to customize the erpnext sales invoice inorder to get the meter readings field and the start and end date of accounting fields. Thanks 1. Introduction of contracts - (Customer name, contact, zone (has green zone A1, A2, Ndavela, green zone 2, green zone 1, green zone 3.1, 3.2), Nuit, customer code, phone number). It should be possible to print individual contracts as well as zone contracts at once. 2. Introduction (the introduction of the real one can never accept being less than the previous reading, as reading and, as reading the previous one, as reading and, as reading without previous power; 3. batch invoices and individual invoices (batch invoices must be invoiced as bills) These invoices must have a...

The candidate should be proficient in those set of language: Full stack sql+nosql+.net+JavaScript+flutter Work is needed for this week and competitive compensation will be provided, The candidate will be invited to signa NDA and take a quick test to show his skills.

The candidate should be proficient in those set of language: Full stack sql+nosql+.net+JavaScript+flutter Work is needed for this week and competitive compensation will be provided, The candidate will be invited to signa NDA and take a quick test to show his skills.

Looking for SAP business one technical consultant to re-develop exist stored procedures. SQL HANA.

Tengo un problema con MYSQL, tan solo tengo 5 bases de datos y va así de mal.

Requiero de un programador en Visual Basic, access y SQL que me permita hacer una modificación en una aplicación hecha en access con una base de SQL que esta funcionando y que complementaria mente necesita mejorar en sus reportes y comunicarse con otra base.

Wir sind auf der Suche nach einem SAP Developer für eine einfache Abfrage In SAP B1, die Abfrage müsste so aussehen. (SELECT T0.[ItemCode], T0.[OnHand], T0.[WhsCode] FROM OITW T0 WHERE T0.[WhsCode] = '12'"). Diese Abfrage benötigen wir im automatisiert 120 Sek. Takt als Export in eine CSV-Datei auf dem lokalen Rechner.

Necesitamos configurar el software Epicor por un problema que nos manda al facturar

Approximatively 3 hours of work. 40 CAD You will have to read a document specifying the job to de done. It consist of using an already given Database and create 4 stocked functions to make use of the database and to create the API that goes along with them. The fuctions should use multiple tables. The choice of the the functions is free between 5 requested. Create at least one package to keep the variables you use in the different functions. Test functions with anonymous blocks Code should be commented The functions should use different aspects (cursors , collections, mass treatment ,…) FRENCH talker prefered

Need windows based service for Whatsapp Integration With SQL Server Using C#. Service will fetch details from SQL Server and send details with PDF on Whatapp Number.

Deseamos configurar y crear un Data Lake en Microsoft Synapse con base en una arquitectura diseñada y una base de datos de Postgres que ya estamos alimentando continuamente

A survey project for intranet. Uses legacy ASP and Microsoft access database.

We have a website: which was built in wordpress connected to an SQL - MyPHP dbase. I would like a reviews page created. We have 350 + reviews currently saved in a simple CSV file (downloaded from Feefo), which I would like to be added to my website. You can see the reviews here: We will stop working with Feefo soon, and will be disconnected from their website.

Microsoft SQL Server Backend.

Number of Positions: 2 Experience: 3 to 4 years of relevant experience Job Description: • Hands on experience in end to end design, development and enhancement of OBIEE & BIP Reports • Sound knowledge of OBIEE Administration • Experience in Performance tuning & Security Management of OBIEE Application • Working experience in PL SQL Procedures, Functions, Packages, Views, Materialized views • Good Communication & Presentation skills Qualifications: Graduate / Post Graduate

Hi I am Sachin Jaiswar from ETP International Pvt Ltd. I am looking for a SQL Programmer.

I want to create an IMDB like website …using react,SQL and NodeJS(using classes in Nodejs)…

We are looking for data analyst who has the following skills to help us with the data reporting. Python and SQL Alchemy MS SQL Experience Solid understanding of SQL Databases and Data Schemas Cleaning Raw data and producing a cleaned CSV file

Quiero un colaborador para realizar un Sistema de Escritorio de ventas y control de inventario de productos, es decir ver la parte de venta de un producto y entregar ticket de venta nada de boleta o factura, y disminuir stock, de misma manera permitir el ingreso de productos a traves de sus facturas y/o ordenes de compra, y entregar reportes. Pero aclaro un Colaborador yo también ayudaría un poco. de Preferencia en Vb.net con Mysql

I converted these json data into the SQL table already. Now I want to normalize these two tables separately. If you know how to use IBM i, then it will be a big help!

Looking for assistance in SAP HANA project.

We are looking for a Database Administrator (preferably from the Philippines and Vietnam, but we encourage other nationalities having the listed qualifications) to: - create an efficient physical database design from a logical data model and application specifications - do metadata management and repository usage - create and manage database schema - implement backup and recovery, and ensure data availability and integrity - perform SQL code reviews and walk-throughs - implement security infrastructure Skills required : ERP and business knowledge Web-specific technology expertise Storage management techniques CockRoachDB This is for an INDIVIDUAL person, NOT a team. Send a link to your LinkedIn profile, with references and recommendations, send a portfolio, and lastly your resume. Stat...

We Need one dashboard for our Digital Marketing Team. We run different types of marketing campaign (Facebook, Google Ads, Bings, Google Analytics) so we need one complete dashboard which help team to get insights and callout on organic and paid data. Skill set required-- sql ( to fetch data from bigquery to data studio) Google sheets Google Data Studio Thanks

Hi! I found a bot on github and I liked it but I use javascript to build bot , its in python. I need someone who can customise but for me

I need a freelancer to develop code to scrape amazon product details and store in my database and send alert if the price hit lowest price.