Sql jobs

...But if i use IP Address and Port for connection on same machine, connection is extremely slow. Most times i get Query time out for complex queries that i do when the Connection String contains IP Address and Port. But i do same complex query on same machine, using Database instance name directly, i never get timeout and it takes a second or two to run. Example : Query 1 : ConnectString = "Driver={SQL Server};Server=MSSQLSERVER5;Database=SchoolMain;Uid=Admin;Pwd=admin101;" When i use this query, recordset is fast. Less than 2 seconds. Query 2 : ConnectString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;Password=admin101;Initial Catalog=SchoolMain;Data Source=,1433" When i use this query, i get Query time out expired. Notes : > I am us...

Conversion of sqlite tables to another format

I need a developer having knowledge how to create windows applications Requires- . Net, Sql

I have an ongoing need to convert 4GL programs to PL/SQL. Several functions written in 4GL will be converted to PL/SQL and then wrapped into a package. This is a very large project that is expected to last at least a year. Pay will be based on number of lines per function. Please do not respond if you do not have experience in these technologies.

Need desktop windows based application with SQL database

I have many years experience in C# and Azure. I'm starting a new piece of work next week where I need to develop an ETL job in NodeJS to be hosted in a Amazon Lambda function. This job will pull data from an Microsoft SQL Server Database (I have one setup in Azure) and post to a REST API. I'm looking for someone to pair with starting Sunday 23rd Jan UK time. I think 2 hours should be sufficient for initial session. I expect there will then be ongoing development for the following 6 weeks. Candidate must have recent experience of AWS Lambda (test and devops processes) and NodeJS. They must also be fluent in spoken English.

...:db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 605 [:db_insert_placeholder_1] => 605 [:db_insert_placeholder_2] => user [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => 123 test ) in DrupalCoreEntitySqlSqlContentEntityStorage->save() (line 846 of core/lib/Drupal/Core/Entity/Sql/). Steps to reproduce: 1) go to site 2) select login 3) select create new account 4) fill in all fields that are mandatory (have an asterisk in red) 5) Submit Error above occurs. Please note that freelancer must work weekends and be able to start upon award and finish within 1 day of award. The freelancer m...

We use Microsoft Teams for telephony - and we want to show info about the caller, which should be pulled by a bot from an external database (SQL most likely) or an API (to be determined in discussion with the developer). We need a developer who has experience in building bots for MS Teams and Microsoft 365 in general.

Hope you are doing good. I need some help in creating tutorial videos on technology. Need some freelancer who can help me record videos in any of the below technology can please ping me. Python Oracle PowerBI Tableau Linux shell script MongoDB payment will be based on the hour of videos delivered. I will give you the basic outline concepts for your to work on each time.

...all relevant information (including video/images/audio and receive relevant advice from the advice provider who can in turn provide his advice on the same form and also share documents, images, etc as part of the advice. Images can be captured by a camera or by drag-drop from folders to the app UI. This browser-based app should work in windows and android (phones). Security should be ensured and SQL injection vulnerabilities should be prevented. Once the contractor is shortlisted by us (based on experience, successful projects and price) and after he signs an NDA with us, We shall provide the design for the UI, Db, tables, fields etc. The proposed timeline for this simple application is 30 days. The contractor is welcome to suggest better ways to do the same job. The work will be...

Power BI Developer should have hands on experience in -Source Control repository handling including versioning - Data Extraction & Transformation (using...experience in -Source Control repository handling including versioning - Data Extraction & Transformation (using ADF) Osource, Zoho ,CSV -Power BI Development based on identified KPI(s) Data consistency & verification check -Azure SQL - Scripts Development Using stored procedures, business logic implementation Data Modelling -SQL Server - Scripts Development Data modelling Using stored procedures, business logic im...

The need is to build a python module, which can pick data from a specified location (tables in a database) and then process that data to comprehend customer interactions and provide an analytical approach in understanding customer state, sentiments, etc. whi...of complaints • Output data to be pushed to a database or returned via an API Assumptions • This will be a stand-alone web application accessible via URL and APIs • Hosting: ▪ Application to be hosted in TP Azure servers ▪ App & DB will be on existing TP interact dedicated servers • Application will be internet-facing • External VAPT and code review to be factored • Compatibility with Azure MS SQL Databases • Code should be dynamic and scalable using the latest supported version of Pyt...

Donation platform for HS, non profit FundyMe needs some things fixed.

I am looking for a C# developer to work with me on our CRM reporting functions. Primary responsibility is to grasp our current solution and use it. Currently, the application is console-based within Visual Studio 2019 community edition and the code is hosted at using a shared git repository. Six days a week, we download two datasets (csv) from our CRM and update local SQL Server v2016 tables. Then we run code against these and use EPPlus to create Microsoft Excel spreadsheets and email these to salespeople, managers, and decision-makers. Ideally, you appreciate agile methodologies. Business conditions change often and the abilities and attitudes from this way of thinking are very helpful. Also, solid object-oriented thinking as a programmer. Basic requirements:

Get a XLS file on an URL, read it and insert columns on Microsoft SQL table

I have a web-application in asp.net framework (C#) which currently accepts payment using Paypal i.e. I have a business account with paypal. Further, I want to implement a wallet based system in my website using Paypal button. That means I will have to allow the customer to recharge money in their web-wallet based on their payment using paypal button. Keep the data of user's transaction an...transactions on my web-application along with the time stamp and transaction ID. I want someone to develop the complete wallet system with following features as a minimum: 1. Recharge page (using paypal gateway) along with success and failure page 2. Page to view last ten (10) transactions 3. Email of successful/ failed transactions 4. Page for raising the payment issues/conflicts 5. Associated

Hi I have about 50000 files needed to be imported into SQL Server DB

hi am looking for oracle developer with following skills 1 oracle pl/sql 2 oracle forms 3 docker 4 linux container 5 oracle streams/DSQ 6 PRO C++/C 7 LINUX/UNIX

hi am looking for oracle developer with following skills 1 oracle pl/sql 2 oracle forms 3 docker 4 linux container 5 oracle streams/DSQ 6 PRO C++/C 7 LINUX/UNIX 8 oracle database must able to work remotely with little supervision able to analyze requirements and come with solution Soft skill Listening skill : Strategic Thinking : Design Skills : Conceptual thinker : Strong analytical problem solving skills : Able to comfortably multitask (perform multiple design, implementation, and testing tasks concurrently). : Self Motivated NOT THIRD PARTY IS ALLOWED

i have aprogram written in LAVAREL i want to convert it to standard PHP so i have more control on GUI and SQL i attach the program any offer above 50$ wont be accepted no milestones before i see a proof it works:

...Services )and store the data in a bucket (name the bucket as yourname_demo). 2. Create AWS Postgres RDS database service (Amazon RDS | Cloud Relational Database | Amazon Web Services), name it yourname_demo_rds and load the data from the S3 bucket Activity -2 1. Download pgadmin4 ( Download ()) to your local machine 2. Connect the postgres db you have created - yourname_demo_rds 3. Run the sql query to retrieve following information from the db: a. How many unique ProductID are available b. How many unique ProductType are available c. Filter the db for OutletSize = Small and create a child table and name it outlet_small d. Filter the db for OutletSize = Medium and create a child table name it outlet_medium e. Filter the db for OutletSize = High and create a child table name it ou...

PostgreSQL query work on Race database - very small queries (total 20) will provide more details.

...delight our customers. You can expect to participate in all aspects of the product life-cycle Required Qualifications: · 2+ years of web/software experience in the development and maintenance of modern web applications · 2+ years of experience with React.js developing and utilizing component-based architecture · 2+ years of experience with Node.js and RESTful API development · Proficient in SQL and relational databases like Postgres · Ability to implement rich client functionality with thorough knowledge of HTML, JavaScript, and CSS · Driven, flexible, self-starter with the ability to work independently, as well as in a team environment · Ability to deliver engineering tasks on time and with high quality · Passionat...

...technology practice Requirements, Skills, Qualifications: Must have 3+ years of PHP or other significant programming experience. Good understanding of MY SQL and relational databases. Expertise in PHP development and Drupal. Expertise in JavaScript and mainstream JavaScript libraries such as JQuery and working knowledge of Ajax. Good understanding of web technologies and HTTP. Good Linux skills HTML and CSS skills commensurate with years of experience. Git knowledge/ version control knowledge and skills. Contribution to the open-source community Experience in Drupal8 of 2+ years. Good with RDBMS & writing custom SQL, Drupal API experience Must have PHP, JavaScript, AJAX, HTML and CSS experience Should be able to code as per Drupal standard cod...

...technology practice Requirements, Skills, Qualifications: Must have 3+ years of PHP or other significant programming experience. Good understanding of MY SQL and relational databases. Expertise in PHP development and Drupal. Expertise in JavaScript and mainstream JavaScript libraries such as JQuery and working knowledge of Ajax. Good understanding of web technologies and HTTP. Good Linux skills HTML and CSS skills commensurate with years of experience. Git knowledge/ version control knowledge and skills. Contribution to the open-source community Experience in Drupal8 of 2+ years. Good with RDBMS & writing custom SQL, Drupal API experience Must have PHP, JavaScript, AJAX, HTML and CSS experience Should be able to code as per Drupal standard codi...

This is to debug the code since the result isn't looking good

...and talented Laravel developer who is passionate, energetic, and self-motivated. Skills: Laravel 8+ & GraphQL Strong knowledge of PHP 8+ and OOP Creating database schemas that represent and support enterprise business processes Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3 Understanding security, safety and accessibility compliance Familiarity with complex SQL databases and their declarative query languages Proficient understanding of code versioning (GIT) Aggressively learn new technical skills and technologies Interpret system requirements and specifications to produce code solutions Work with an agile team to develop, test, and maintain solutions Linux knowledge is a big plus Must Have: Experience with microservice architectures Exp...

We are looking for Asp.net Developer for 160 Hours in a month. resources should be...NET. • Good experience in development/consume web service/API restful and OData • Good Client Scripting Java Script, JQuery • Good skills in xml/Json web services • Good HTML skills • Good CSS skills • Understanding and experience of Github to manage projects • Able to develop, compile, create, debug and consume .Net common components (such as DLLs) • Hands on Database concepts such Write/modify SQL Queries(DML) • Create/Modify Database Objects(DDL) , Database connection • Good understanding of Object-oriented programming and have hands on development and unit testing experience • Developed and maintain efficient, reusable, and reliable code &bu...

The web admin panel is developed in php- Code Ignitor with my sql server and rest api. There is a small issue that sms otp is not delivering now on certain api calls. At one point its working fine. Only those who have previous experience in php-Code Ignitor, my sql and API only should bid to this project. Its just fixing a bug or changing the credentials. For those who know the work, it might take max of 1 hour. If you succede in this, i have more projects to work on.

What we need is develop a system to pull data from a ftp site on a daily basis then convert from xml to sql and push it into a DB

• Should have experience in designing data warehouse projects. • Experience in creating Microstrategy Schema and application objects suc...knowledge of Star/ Snowflake/ Dimensional data modelling, Data Warehouse and reporting techniques. • Experience working with the full life cycle development process, which includes analysis, design, development and testing. • Strong SQL skills and ability to create simple to complex Schema Objects as per the requirements. • Experience in Object Manager, Enterprise Manager, Command Manager and System manger. • Experience in performance tuning of various Reports and Dashboards using VLDB Properties. Skills • Good knowledge on Microstrategy • Good knowledge on SQL query • Basics on SAP HANA will ...

A successful candidate will need to posses the following abilities: - JavaScript - HTML - CSS - Node.JS - Game Design Patterns / Fundamental Game Design - Great communication skills both typed and voice calls. - Knowledge of Web3 (Solidity) is a plus. - Unity Game Development The game you'll be working on is a multiplayer top down shooter similar to the game found here: . The game map and assets are ready. The game will need to be built to function on PC web browsers with multiplayer. Servers will need to be scaled accordingly to match player counts. Finally, we'll need blockchain integration by assigning certain in game assets to ERC1155 & 721 NFTs made by our solidity team. By doing this, the game allows users to access the verified NFTs within their crypto wallets.

Dear freelancers, I require 2-3 Ax developers to work on a long term project The candidate should have hands-on experience on the following DM experience in F&O Dynamics 365 F&O Data Entities (F&O) SQL Database RIS Good to have skills Azure SQL Logic Apps Good communication skills. Those with the mentioned skills only may apply. Currently we don't have offers for freshers. Thanks for taking time to read this. Good day. Regards Rishi

...with Go framework & tools . e.g Revel, Stringer, Go kit etc. Experience with containerizing Go lang microservices. Preferred experience in building Go lang microservice with gRPC implementation. Spring Boot ( good to have) Java Postgress/oracle AWS/GCP Git Significant development experience in a Java focused on data, APIs & Microservices. Strong understanding of data and data integration concepts (SQL, data governance, enterprise patterns). Proven problem-solving skills and the ability to propose new solutions. Experience with development best practices (TDD/BDD, CI/CD and other DevSecOps concepts). APIs and related concepts (OData, GraphQL, API Gateways, OAuth, Swagger etc.). Excellent written & verbal communication skills are essential. Good experience in handling a...

I have a query that uses temp tables and variables. I want to load the out put in Power BI and generate reports. Power BI throws the error when declared variables used in the SQL . " the variable name '@yearmonth' has already been declared. variable names must be unique within a query batch. I tried using blank query and declare those variables in Power bi but not successful.

We are looking a Data Sciencist Architect who can do below for us. Design Data Warehousing System Develope ETL using python scripts/C# project or any other tool and setup those on server or some other service to run every on a particular time to fetch data from multiple sources and dump it in to DWH. Setup PowerBI with embadded capacity for customer reporting. Person should be expert into SQL development & DWH designing, Python and PowerBI

Hi, I need a single cystal report designed using vb.net, sql server or ms access. My max budget is INR 500/-

Develop a revenue system. A manual is available. This will take how long? How much. PhH, SQL

Hi Aqeel A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hello Freelancers We are in the phase of starting a company (registration in progress). We are in need of 2 full-stack web developers with expertise on the MERN stack. Requirements: JavaScript Typescript React js Node js SQL NoSQL REST Git / Github Good To Know Web Socket WebRTC AWS Agile Methodology Note: We are not hiring on a project basis Only bid if you are from India and can join immediately. Working hours: 10am - 7pm (Monday - Friday) Experience: 0 - 2 years Notice period: 1 month package: Based on interview Please drop your CV on chat.

To define the software architecture for a platform using Node.js for backend and sql server databases. We already have the mockup done.

Hi. I have some projects to carry out or to maintain made in C # with .Net Core on sql server. The most urgent is the development of a small web application for the management of supplier orders and the receipt of goods.

Develop a revenue system. This will take how long? How much. PhH, SQL

Develop a revenue system. This will take how long? How much. PhH, SQL

Develop a revenue system. This will take how long? How much. PhH, SQL

Develop a revenue system. This will take how long? How much. PhH, SQL

Develop a revenue system. This will take how long? How much. PhH, SQL

Develop revenue system. This will take how long? How much. PhH, SQL

...-f7b3edae02f2 Basically I need a T-SQL script that replaces in the json all old IDs with the new IDs. In other words, given the json above, I expect the following json as output: { "showRandomSections":false, "sections":[ { "questionCount":"1", "folderId":"F44EEDC6-88FD-4886-AEF1-8314A1A11FC4" }, { "questionCount":"1", "folderId":"BF5C9C6C-00AC-467C-8F47-D1ACE582925A" }, { "questionCount":"2", "folderId":"F44EEDC6-88FD-4886-AEF1-8314A1A11FC4" } ] } I don't want to use loops or cursors. Maybe this link can help you, I found it by googling...

Hello I have a simple project. I have a c# method that gets data from SQL store procedure, insert it into a text file and download it by a btn. The issue is: the data from sql does not get inserted. the text file and btn works fine and the method to get the data from sql also works fine. public DataTable CreateRunOCR(int name1, int name2, int name3) { string sqlStatement = ; try { IDBContext eddsDBContext = (workspaceArtifactID); SqlParameter DocumentArtifactParam = new SqlParameter("@name1", workspaceArtifactID); sqlStatement = "[EDDSDBO].[CLCS_LSA001RL_GetWRBugText]" + " @Prod_ArtifactID = " + @name2+ " ,@Co...