Sql server insert where työt
Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.
Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...
Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Project Budget: $100 Project Deadline: 1-2 Days Project Type: Custom WordPress Plugin Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data ...Project Difficulty: Standard PHP Version: 8.2 and above Project Overview: Custom WordPress plugin required to allow a user to: - Upload a CSV with bulk new POST data - Select a post category, schedule start date, choose how many posts to PUBLISH each a day - Import post data and create all new posts as DRAFTS, to go live on the specified post schedule & keep a suitable log that can be checked - Insert the new POST IDs back into the original CSV file & automatically download the update CSV for a user 5* FEEDBACK WI...
• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Se...
As a seeking employer, I'm urgently in need of a skilled web developer proficient in Kotlin to code a complete feature that will span the entire application stack. Our application uses Java and Kotlin to connect a relational database backend to a modern web fronte...a complete feature that will span the entire application stack. Our application uses Java and Kotlin to connect a relational database backend to a modern web frontend. We're looking for a full stack developer who can code a complete feature spanning the entire application stack. Requirements: Java (5+ years) JavaScript (3+ years) Knowledge of software design principles Test driven development SQL HTML The timeline for the project completion is "ASAP", hence efficiency and timely delivery is vital. ...
i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35
...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...
I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application
We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...
I am seeking a skilled PHP developer to resolve issues on my website's offer/gigs page. The website runs on a PHP MicroJobs Script, and there are several bugs affecting ...fix bugs efficiently. Ability to optimize page responsiveness for various devices. Excellent communication skills to provide regular updates on progress. Deliverables: Resolution of all identified bugs on the offer/gigs page. Improved page responsiveness for seamless user experience. Clean, well-documented code changes for future reference. Timeline: Flexible, but aiming for completion within [insert timeframe]. If you're confident in your PHP skills and have experience with MicroJobs Scripts, I'd love to hear from you. Please include relevant experience and examples of past projects in your propo...
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...
I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.
...assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images when clicked. The CSV files must be Shopi...
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
...a programmer with expertise in the Twitter API and JavaScript for Google Sheets. I require assistance in setting up the Twitter API and need a custom script written for Google Sheets. Here are the specific requirements for the project: Project Objectives: 1. Script Functionality: - Automatically fetch Arabic text from a specified Twitter account and insert it into Column B of a Google Sheet, starting from Row 2. - Retrieve and insert links for images and videos associated with the tweets into Columns C, D, E, and F respectively. 2. Automation and Updates: - The data retrieval process should be automatic and occur in real-time, ensuring the Google Sheets document is updated continuously, irrespective of whether it is currently open. - Include functionality to ...
...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP
...Current website is very slow and couldn't take a back up using updraftplus plugin I need all files and Database copying to new server and testing that it function OK I am in need of a specialist with broad experience in WordPress platform to move my website from its current location to a Virtual Private Server (VPS). Requirements: - Comprehensive knowledge of WordPress site architecture and components. - Extensive experience in website server migration, particularly to VPS hosting. - Ability to ensure that no data is lost during the migration process. - Skilled in backup creation and restoration. - Familiarity with DNS and IP configurations for the new server. The task must be completed with minimal downtime and no loss of data/functionality. Please...
...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...
...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...
I need an experienced server administrator to assist me in setting up a domain remotely. he should have some experience with Digital Ocean and Linux server setups The ideal freelancer for this project should have experience in: - Setting up Linux servers, particularly on Digital Ocean - Proficiency in configuring and managing Ubuntu - Experience with Nginx web server software - Understanding of web hosting best practices and security measures - Strong troubleshooting skills in case of any issues. Please note that the server will be used for hosting a website, so it should be optimized for performance and security.
I want a Linux Ubuntu 24.02 expert who knows multiple domain handling on the server. I already created a .conf file but respective subdomain is redirecting to another website than required.
The site was created on WordPress * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have...
I am in need of a well-versed Python expert to assist in managing a Linux server. This project is task oriented and requires specific skills including: • Working with server data analysis • Implementing web scraping techniques • Establishing automation processes The role also demands a comprehensive understanding of Linux operations and the ability to print headers. A background in server security, setting up database servers and performance optimization would be ideal, but the focus is primarily on Linux server management via Python. Proficiency in Python, Linux, server data analysis and web scraping are must-haves. Experience in automation and server management will highly be appreciated. Looking forward to your knowledgeable a...
I need messages I receive in a specific server channel to be forwarded to my own servers channel, I do not have admin role for the server channel I will need messages forwarded from, so I need a script or anything you can come up with, I am allowed to invite accounts to the server channel
I'm currently seeking a skilled backend developer who has proven expertise in Python, Java, and Ruby. I need someone who can guide me through whether to use the current source code or start from scratch, a decision that we can make together as the project evolves. As our project's main responsibility is to handle authentication and server configuration, the perfect candidate should be experienced in: - Setting up, managing, and sustaining server configurations - Handling various authentication tasks - Expertise in Python, Java, and Ruby - Decision-making skills concerning source code development This project will be rewarding for someone who enjoys tackling unique challenges and has a flair for problem-solving. If you're up to the task, please don’t ...
I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...
...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...
I've recently established a venture named "Atlas Truck Parts" and am in need of a unique, professional logo to represent my business. The logo should be a combination of text and symbol, encapsulating what our company represents. ...colors - Create a logo that embodies the essence of a truck parts company In terms of skills and experience, proficiency in graphic design and a portfolio featuring logo designs are essential. Experience in creating logos for a similar industry would be an added advantage. I would like to incorperate the ATLAS statue with the man holding the world on his shoulders, eith remove the globe and insert a truck or possibly the business name instead just as an idea or stretch out the initial "ATP" in block letters as the trailer and...
I'm looking to set up a Minecraft 1.16 server focused on mini-games. Initially, I'd need 4-6 mini-games to be developed. Key Responsibilities: - Configure and set up a Minecraft 1.16 server - Design and implement 4-6 engaging mini-games - Ensure the server's smooth running and performance Ideal Skills: - Proficiency in Minecraft server setup - Proven experience in mini-games development - Strong understanding of Minecraft 1.16 mechanics - Ability to manage and maintain server performance - Creative problem-solving skills to enhance player experience Looking for a dedicated and experienced Minecraft developer who can not only set up the server but also create fun and unique mini-games within it. The goal is to attract and retain a strong ...
We're focused on helping LGBTQ+ owned businesses, so we're also looking for a graphic designer who's also in ...a sense of design with attention to detail, so you can play around with the existing style, while still staying true to the style. If everything works well and you have the branding knowledge + skill, you can take more responsibilities on the branding side as well — both for the concept and design. So, this will start with a trial period, and you can gradually get more and more hours. Please insert in your reply, why you'd love to be involved in a queer-owned business and help other queer-owned businesses. This way, we'll know that you've actually read this listing. Thank you for and looking forward to hearing from you. Please feel fr...
I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...
...select topic and then google it looking for the research paper. then find the survey paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP. Your prompt attention and quick work turnaround will be highly appreciated. Research Report 1. Title: [Insert your research title here] 2. Names: [Insert author names here] 3. Department: [Insert department name here] 4. Email: [Insert email address here] 5. Abstract (9-10 lines): Research area: Briefly explain the area your research focuses on. Problems: Identify the key problems existing in the research area. Solutions: Briefly mention the solutions your research proposes. 6. Introduction (20 lines): General overview: P...
I need a skilled professional to help me creating email servers to send bulk emails and managing. - **Email Marketing**: I have been using the server for bulk mailing and email marketing. I need an expert who can optimize these operations, ensuring that the emails are being delivered effectively and not marked as spam. - **Troubleshooting and Support**: Although I did not select this as a specific task, I might need help with troubleshooting and support in the future. It would be great if the individual could provide this assistance as needed. The ideal candidate for this project is someone with extensive experience in managing email servers, particularly with SMTP, bulk mailing, and email marketing. A deep understanding of email deliverability and anti-spam measures is crucial...
I'm looking for a graphic designer who can skillfully change the background of an image to create a new environment. Specifically, the image is of my wife on our wedding day, she really wanted a picture of her with the car, but we forgot on the day and missed the opportunity. Key Tasks: - Add picture of her beetle into the background of a wedding picture - Insert a high-resolution, realistic new environment - Position my Beetle car prominently in the image - Images can be sent over Ideally, you have previous experience with car image editing and can demonstrate a high level of attention to detail. I'm expecting the result to be realistic and in high definition. Proficiency in Photoshop or equivalent software is required. If you appreciate cars, specifically Beetles, th...
I have a file uploading system installed in my localhost server that's working perfectly. But when I tried to move it to an IIS server, it's not working.
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...
I'm currently facing some integration problems with my CI runner on GitHub. I'm looking for an experienced freelancer who can help me resolve this issue. Github Repository Push --> target is that runner push code to cloud linde automatically Key requirements: - Previous experience with GitHub CI runners and Linde Cloud Server. - Strong problem-solving skills in identifying and resolving integration issues. - Good understanding of continuous integration and deployment processes. - Ability to communicate effectively on the progress and steps taken towards resolving the issue. Please include similar project experiences in your application. Looking forward to working with a competent professional who can get this resolved quickly.
I'm seeking a proficient Photoshop expert whose main task would be to remove the background from my high resolution (300 dpi or above) images. Here's what I need: - Remove original background from given photos - Ensure edges are smooth and object in focus remains intact - Optimal adjusting of color and contrast post background removal - Insert a simple placeholder background in the interim The perfect candidate should have skills in Photoshop or similar software, with a strong focus on detail and an impressive portfolio showcasing past projects of a similar nature. Note that the ability to efficiently handle high-resolution images is a must for this project.
I am in need of a specialist who can set up a DayZ server for Xbox, with in-depth knowledge of the DayZ game mechanics and server maintenance. Here are the specifics: - OS: As my console of choice is Xbox, I require someone who can effectively deal with a server setup on this console. - Mods: I am looking for custom mods. It would be highly advantageous if you have experience in customizing mods fitting to the specific needs of the players. The ideal candidate should have solid experience in DayZ server setup on Xbox, and extensive know-how in custom mod implementation. Sound knowledge in maintaining and troubleshooting Xbox servers would be a plus. Please, detail your experience with the above criteria in your proposal. Let's make a thrilling DayZ gaming...
