SQL Jobs

Trabajo con un formulario de Microsoft Access para registrar clientes (pacientes) que van a tomarse radiografías en nuestro centro radiográfico, y lo que necesitaría son dos cosas: - El Precio a pagar por el paciente se calcula con código mediante la información del examen solicitado y el tipo de descuento. Necesito que el listado del arancel quede disponible como tabla o algo equivalente de modo de poder actualizarlos según necesidad con mayor facilidad que editar los cálculos del código. - que desde el sistema se puedan imprimir las boletas de los pacientes integrándolo al sistema de facturacion que tengo contratado.

Necesito exportar base de datos informix 7.1 a Sql server y tarea programada para exportarla varias veces

Se cuenta con una base de datos Sql que pesa aproximadamente 200 gb y actualmente está teniendo mucha lentitud en los query llegando a tiempos de 13 mms a más ya que realizan consultas de múltiples tabla y generación de vistas. -Se requiere realizar un mantenimiento del sql server y del Windows en donde está montado -Limpieza de logs y alertas -Aplicación de parches de seguridad -Resolución de bugs -Optimización de funciones, procedures, triguers, etc.(tuning Database)

Es una aplicación desarrollada en PHP con larval + MySQL como base de datos. Ya está operativa y necesita algunas modificaciones y mantenimiento diario. Gracias. Saludos.

Hola busco freelancer CON DISPONIBILIDAD DE TIEMPO PARA SACAR ESTE PROYECTO EN UN MAXIMO DE 2 SEMANAS Y QUE HABLE ESPAÑOL con experiencia en procesos de migración de datos entre 2 bases de datos que se encuentran sobre el motor SQLSERVER. EL procesos se debe realizar en 4 fases donde por cada fase se entrega un script que contiene las 7 tablas principales del procesos (estos insert se entregan funcionando) pero se debe corregir el primer bloque debido a que no se hizo de manera correcta. De ahí en adelante se deben poblar las tablas que estén relacionadas con estas 7. Para poder explicar mejor propongo por anydesk y de esta forma explicar mejor.

El proyecto se realizara en simultaneo con más de tres programadores, los cuales trabajaran juntos compartiendo opiniones, código del Back end - Front end y conexiones de base de datos SQL server, ect. El trabajo consiste en realizar una aplicación en PHP para uso interno de una empresa. Es para uso de múltiples usuarios a vez en el área de manejo de mercadería, etc. Esta aplicación se realizara con diferentes versiones, en las mejoradas contara con APIS de conexión. Dicha aplicación se conecta a la base de datos de un ERP (software administrativo está realizado VBA) que trabaja con su base de datos SQL SERVER 2012. La nueva aplicación tendrá su propia base de datos para guardar sus datos y a su vez...

Quiero desarrollar una web servís para poder captar clientes en para mí empresita que da servicio de albañileria

Solucionar el error: "ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by" Causa: Hasta la versión 5.6 de MySQL 5.6 el modo de SQL era NO_ENGINE_SUBSTITUTION. En la versión 8 de MySQL los modos de SQL por defecto son ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION Por motivos de seguridad, compatibilidad y mantenimiento en hosting compartidos no se modifica el modo de SQL por defecto en el servidor, y hay que modificarlo en el inicio de sesión dentro de la programación. O bien mod...

I've been given the documentation to set up the On Premises Data Gateway so that we can use Power BI. I have been able to install the Gateway on a server, but I am having issues when creating a new SQL data source. I am receiving a message to say "Unable to create data source. The on-premises data gateway's service account failed to impersonate the user."

Create a chatbot for use from the web. Use APIs. Frontend built with react, backend is python. - Webapp pages: login, user creation, usage, billing, main chat interface - Users to authenticate and process billing /subscription - Session chat history is retained, stored in database for future reference - Will need to use APIs. Keys provided. APIs already selected.

hi, I want someone to develop a website in Dot Net or Python or whichever technology is secured. The team will be from India as we will require them to do the work at our location. The site will have a basic inventory system, a front end for users etc. The main feature of the site will be a visualizer as you can see in this example The user selects the tile color, the type of edge he wants to see and the system display the table with the same marble tiles and edges that were selected. More can be discussed. Only bid if you have worked on a similar project in the past.

Need a gujarati girl with strong technical background in computer science. Someone who has extensive experience in the field of software QA engineering. Thorough understanding of topics i.e. SDLC, STLC, TestNG, Cucumber, Jenkins, RestAPI, Postman, SoapUI, Rest-Assured, Selenium, Java, Cypress, etc.

Need Snowflake Developer who can migrate quires/SP's from SQL Server to Snowflake SQL.

Please only apply if you have ALREADY worked on a similar project. We need the equivalent structure of MD4C in SAP BW (on HANA) : technical details and help on implementation. What is the MD4C ? The multi level order report is a classic SAP report. The MD4C transactional code allow its users to find coverered non covered stock for the article recursively. Within production planning, the Multi-level Order report does a collective availability check for all the components in an order, rather than for an individual order component. The collective term is used as it is run against multiple orders at the same time rather than for a single order. The benefit of the SAP report is that results are displayed multi-level style in the same manner of an exploded Bill of Materials. The result is ba...

I want help for my Java project using spring boot.

Need to deploy web api with database and react application build in Dot net core framework on Azure

Error: sys.utl_http end of input reached

Hi I am looking for someone full time to work with me in projects working with DBT, Power BI, Python, SQL, etc. This is a full time position and no other work should happen. We would work each day from 9am to 5pm. The pay would be $700 USD each week. Let me know if your interested in having a conversation about this. Thanks.

need support for Peoplesoft HCM Technical Support 9.2 in AWE, IB, Peoplecode, App Packages

1. Sorting data as described - by Centre (ASC) and Completion% (DESC)

I have two files for which i created the two tables in the SQL instance. when i use the import commands, rouhly 10% does not get loaded. i need someone with good knowledge on GCP SQL to work on loading those two files. i do not expect this to take much time

On the way to cloud, we need a senior db admin to help to the transition. Must speak french

Hello, I have a very simple task who can help me for IIS and SQL server, its just placing of some text from SQL DB. person who knows it should not take more than 30 mins. Thanks,

Hi , I am looking for Dot Net full stack developer with angularJS frame work. Every day they need to contribute 3 to 4 hrs . The candidate must have discussion with client for shorlisting . EXP : 3 to 5 yrs

Hi I am looking for some experts in KQL language to write a script for me

I need a live application which make in php and sql

Looking for liquibase expert for the database repository, changes challenges

Hello there, my project is not as complex as others. I will need somebody that had understanding in python through vs code and SQL databases. I created a code long time ago in python that will transfer some files into SQL. The issue with the code is that now is presenting some errors when it used to run perfectly fine. It is not adding the correct number of rows since the new data has new rows so you will add to the code the possibility to add additional rows from the code. The files that the python code transfers are encrypted so the only way to see the files is if they are already in SQL as a table. All this information I am unable to share with you since it's a project for my company, for this reason we will have to share screens and you will work from my computer, if you are comfo...

Hi All, We are looking for an experienced company that can build a unified API switch to integrate a POS system with the the following food delivery apps: ▪ Uber Eats ▪ SkipTheDishes ▪ DoorDash ▪ GrubHub ▪ Postmates ▪ Seamless This requires a full integration, including Menus, Stores, taxes, etc... You will have to build the APIs using swagger, and you must provide a Web UI that allows testing all the API and that shows the full integration operational and with real-time updates. You must also extract and write the data from/to a database to allow the integration to work through the database or the APIs. If you can't show that you have done the work, please don't bother as we can also do it from scratch. Skills required: SQL, C#.NET, WebServices

Power bi report,row total not showing correct value

Oracle time and labor freelancer

We are seeking a skilled and experienced frontend developer to join our team on a freelance basis. The job will involve developing the frontend of our website using Node.js and React. Additionally, we require that the candidate has a good understanding of Amazon Web Services, SQL, and querying. Please note that we already have a team in place for the backend development of the platform, and the successful candidate will be required to work closely with our backend team to create a cohesive and functional platform. The ideal candidate will have: Strong experience with Node.js and React Experience with AWS Knowledge of SQL and querying Good communication skills Strong attention to detail Ability to work independently and meet deadlines Also valueble to have knowledge of webflow (and figm...

Convert your ER diagram to a relational schema. ( ➢ Underline all key attributes in your relations. ➢ Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. - Populate your tables with 5 rows at least. - Design and implement at least 4 queries. As specified below Data Retrieval Queries with Select (total of 4 Queries) ➢ Where ➢ Order By ➢ Group By ➢ Aggregate functions ➢ Subquery ➢ Join query - Note: ➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4. ➢ Using select all (*) is NOT accepted. - Design two stored procedures as the following ➢ Create a PARAMETER based SELECT QUERY stored procedure ...

Convert your ER diagram to a relational schema. ( ➢ Underline all key attributes in your relations. ➢ Specify all functional dependencies for each relation. (Mapping) - Use Oracle to create the normalized tables. - Populate your tables with 5 rows at least. - Design and implement at least 4 queries. As specified below Data Retrieval Queries with Select (total of 4 Queries) ➢ Where ➢ Order By ➢ Group By ➢ Aggregate functions ➢ Subquery ➢ Join query - Note: ➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4. ➢ Using select all (*) is NOT accepted. - Design two stored procedures as the following ➢ Create a PARAMETER based SELECT QUERY stored procedure ...

Hi! We use schematron rulesets to validate XML documents. We want to import these schematron rules into an Database (BaseX) and let validate the XML right there. We hope that way the validation is much more faster than traditional validation. We search for someone who is familar with XQuery and Databases generally. The Documentation how to import is also here to find:

I need the Database Programming coder needed for multiple jobs. Details will be discussed.

The following changes are required to be made to orange hrm system already currently installed, and already full of information. The software has been used by our company for about a year, and as of today we need the addition of these functions: Ability to report for each employee, and for each month and year of : Days Worked; Vacations Used and Remaining; Leave used and remaining; Possibility to do export of hours worked on each project for each employee (report for each month and year); Possibility to Upload pdf files for each employee ( by manager) for payroll and year-end single certification; Travel notes: a section within which the employee can add what travel he/she did and any expenses incurred ( possibility to attach pdf for receipts/receipts) I provide access data from web inter...

Need a developer who can scarp the website and handle captacha in c# project, fetch data and push into sql. 1. Step 1. RUN BELOW LINK IN backend. A. ENTER PAN NUMBER/AADHAAR NUMBER B. ENTER CAPTCHA 2. Step 2. A. Capture details mentioned in table B. Push that data in SQL. Language c# project, webapi required

Quicksight insights project developing dashboard

Simple web application with sql data base. 1. insecure web application a. sql injection, XXS, broken authentication, sensitive data exposure, broken access control or any vulnerabilities at least 3. 2. secure web application to fix above vulnerabilities 3. prefer python and php and able to run in localhost. 4. please noted down the step to fix in vulnerabilities.

A webapp which takes data as input (a markbook later where teacher can enter marks) shows this to user for the data cleaning and saves this data which is then used to produce the analysis. This is a pupil assessment tracking system which can accommodate any curriculum with some basic subject and assessment criteria setup. some basic info that can be saved is student basic data and teachers should be able to upload multiple files (some based on internal configuration of assessment and other external exam data.) After the upload, there is a report section which picks up this data and shows it in required way (High achievers/low achievers/top 10 per subject/average grades etc) comparison of class marks with either class etc

We require a web based database application for cemservices which will manage various types of construction contracts and labour input.

• Participate in data migration activities • Creation of transformation scripts and tasks • Consult with various stakeholders including subject matter experts to understand the source and target data models • Develop a detailed understanding of data models for projects that are part of current and future migrations • Execute data extraction, cleansing and loading from various systems. • Adhere to company and best practice security standards • Participate in data quality and reconciliation activities Skills and experience • Experience with analyzing data models in both source and target system landscapes and defining appropriate mappings and transformations necessary to successfully migrate the relevant data • First-hand experience working on med...

need fix a qurrent query to verify if data match in other table before update

We have PostgreSQL queries/codes that require to convert to in Snowflake equivalent.

Need SQL Database management (Oracle) Expert to do the project. If any interested apply

Necessitamos de um porgramador que consiga executar o seguinte : Temos 5 fornecesores que enviam os STOCKS em CSV e pretendemos que crie um CSV que una todos os fornecedores através da comparação do melhor preço dos 5 fornecedores. Os artigos que apareçem no CSV final seja os que têm melhores preços , ou seja deve aparecer o fornecedor que tenha o melhor preço. Aguardamos as vossas propostas

I am looking for an expert to take 3 online technical assessment tests (in French) for an interview, Each test will take1 hour Stacks: java, nodejs, angular, sql

Por favor, regístrate o inicia sesión para ver los detalles.

Below is the JD of the above. Want a candidate who has less/competitive budget. As a SQL DBA/ Migration Engineer you will be fully engaged in the migration project for Microsoft SQL Server. Our team works with precision and speed. We are looking for a candidate who is ready for this challenge. Job Description What you will be doing as a SQL DBA / Migration Engineer Have some 2008 R2 and majority R12 that needs to be upgraded to R19 § Create Test Database environments to research and solve database upgrades pre-production upgrade § Upgrading current SQL Database to new supported version for Windows Server Migration to 2019 § Migration of existing Databases to new Windows Servers § Restore data and ensure that current databases work as expected § Provide expert l...