Pl sql package example code 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). --------------...

Hei digitalartsguru, huomasin profiilisi ja haluaisin tarjota sinulle projektin. Voimme keskustella yksityiskohdista keskusteluikkunassa. Hey! I need to design a product package. I want a modern and sporty look. Attached is a logo that must be visible on the packaging. Also attached to the packaging information.

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

angularjs fix

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 ;)

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...

I am seeking residents of Munich, Germany to conduct an in-store check for a well-known Dairy brand. Project in a Nutshell: 20 SKUS (Products) need to be assessed for the following: Tidiness of shelves, package quality, time to find product and etc. 3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. Consumer will assess 31 samples per a product in total. No purchases required Products include water, plant based and diary. All data will be captured via an App thus good quality photos are needed. Answer questions related to the product via the APP. Full training provided. Requirements of the consumer: Tech Savvy. Promptly answers emails. Flexibility with time 4 weeks to complete Fee for project 1: €600. There is a secon...

I'm in need of 4 consumers based in Berlin, Hamburg, Karlsruhe, and Stuttgart to visit 8 stores per city. Your task will be to gather data specifically on the promotional displays and materials used for a well-known dairy brand. Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the product via the APP. -Full training provided. This data...

I am in need of 4 consumers based in Berlin, Hamburg, Karlshue and Stuttgart to visit 8 stores per city, for a well-known dairy brand. Your role will be to gather market data, particularly focusing on promotional displays and materials. - Project outline: - 20 SKUS (Products) need to be assessed for the following: -Tidiness of shelves, package quality, time to find product and etc. -3-4 samples per a product to be assessed. eg. Product is water: 4 of these will need to be assessed. -Consumer will assess 31 samples per a product in total. -No purchases required -Products include water, plant based and diary. -All data will be captured via an App thus good quality photos are needed. --Answer questions related to the product via the APP. -Full training provided. ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...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...

Montly Salary EUR 2000, full time + bonuses. Only Native Spanish speakers from Spain!! As a rapidly expanding company, we are in need of a dedicated Customer Support professional who is a native Spanish speaker from Spain. This full-time role requires an individual who can provide exceptional customer service during afternoon shifts. The compensation package for this role is EUR2000/monthly. Responsibilities: - Responding to customer queries via voice calls and email, ensuring each customer receives top-notch service. - Using the Zoiper platform to manage customer interactions. Ideal Skills and Experience: - Fluency in Spanish (Spain Spanish) - Solid background in customer support, preferably in a phone and email environment. - Familiarity with the Zoiper platform is an advantag...

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...

I need a captivating and innovative pitch deck that will help me attract new clients, particularly within the small business sector. Also a complete rebranding / social media corporate branding package kit for my company 17 Hertz Inc - is representing Ugo Mozie. Key Requirements: - The purpose of the pitch deck is not to secure funding but to attract new clients. - The target audience for the pitch deck is small businesses. - I am seeking a creative and engaging style. - Need to update photos and beat the competition who as we have non exclusive rights to secure new clients Ideal Skills and Experience: - Excellent design and presentation skills, with a proven track record of creating engaging pitch decks. - A good understanding of the small business sector and what appeals to

We are looking for an expert for static site generation using faustj...headless WordPress in a monorepo project. Data fetching is done using graphQL. We already have all required react components for the site, but the components need to be moved into a reusable, independent ui library (including build scripts). We use Storybook which should import components from the ui library. We use styled components as css-in-js solution in our react components. We use graphql code generation to generate typescript types from our fragments. Static site generation should make use of SSR and server components. The coding is more than half done. We are looking for someone, who has already made all the mistakes, and guide us. My backend dev scope the project for 2 days. If it takes longer, we will ...

...to guide a transformer model to generate code-mixed sentences. Specifically, we are targeting basic code-mixing complexity - inserting words from one language into another. Key Responsibilities: - Develop and fine-tune a transformer model for code-mixing at a basic level - Implement the model in a way that can generate code-mixed sentences effectively Ideal Skills and Experience: - Strong proficiency in Python programming - Proven experience with NLP and transformer models - Familiarity with code-mixing and its linguistic aspects would be a plus - Good understanding of basic code-mixing complexities - Ability to design, implement, and evaluate NLP models This project is ideal for someone who is passionate about NLP and has a keen interest in ...

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...

...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...

A fotóból egy fekete, kontúr vonalakkal kellene rajzot készíteni. Fontos, hogy felismerhető legyen a hölgy a rajzon és nem kell olyan részletesen, ahogy a minta képen van (pl. hajszálak külön, árnyékolás, stb). Fehér hátterű legyen a kép.

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

You will get an application that automated extracts the data from any site web you need, cleans it, and presents it to you in an Excel folder or links it to the database, etc.1 - An application capable of extracting infiniti of data automatically without human intervention and in a short time2- You can choose any package you want according to your specific needs3 - After that, you will get rid of manual data extraction, which requires a lot of time and focus, etc. With the application, say goodbye to manual errors.

I'm seeking a skilled professional capable of converting GPT chats with code samples into interactive, running HTML pages. This project requires: 1. Expertise in HTML, JavaScript, JSON, GitHub, retrospective mobile display and the use of ChatGPT. 2. Proficiency in transforming chat scripts with intermediate level programming concepts into functional code. 3. The ability to generate dynamic HTML pages from these chats, complete with buttons that trigger specific code executions. This is aquick and challenging, yet rewarding task for those interested in innovative ways of transforming GPT chat conversations into executable, interactive web pages. Result will be stored as a github project, We will send invitation to awarded freelancer. Current budget is 62$+...

I work for a security company. We needed a spreadsheet to track security units and track what they're doing. I have the code almost perfect, but it's buggy enough that it's hard to use. There's quite a bit of backend code and intermittent problems with it. I need someone who is great at project code to look at it, troubleshoot it and make it more user friendly.

... Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integrations and web services (REST, GraphQL, etc.). Ex...

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...

I am in search of a skilled Python developer to deliver a solution capable of scraping specific data from websites like and Makemytrip. The chief aim is to collate the room type and rates, along with rates applicable for speci...handling dynamic web content Your role will involve programming a robust and efficient scraper that can collect and deliver the desired data in a structured format. Familiarity with and adherence to legal and ethical aspects of data scraping is necessary. Efficiency in output delivery and importantly, minimal error in scraping are vital. I am not particularly interested in flight rates or tour package rates, only in hotel rates. Please ensure your bid includes your experience in the field, any similar projects you have completed and your availability.

I...design. Our expectation is to get the rough idea of how elements should be present on the package. How much text and where it should be situated. Ideas on backgroung, colors and schematics. We are looking for 2-3 ideas from designer. Key Requirements: - Proven experience in packaging design, specifically with cardboard materials. - Strong comprehension of brand identity elements and how to incorporate them into design. - Ability to produce creative, visually engaging designs that are impactful and represent the brand accurately. The ideal professional for this job is adept at leveraging the flexibility and adaptability of cardboard. Furthermore, they must recognize the importance of brand identity in package design, ensuring the final result makes a lasting impression ...

...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....

...developing an AI Chatbot using the ChatGPT API integrated with Langchain, primarily for Customer support purposes. I'm looking for expert advice on enhancing and refining the existing code in the following key areas: - Handling User Input: I need guidance on improving the bot's ability to understand and process a wide variety of user inputs smoothly and effectively. - Generating Accurate Responses: I require assistance in fine-tuning the bot's response generation to ensure it provides relevant and accurate information to users' queries. - Performance Optimization: I am seeking recommendations on how to optimize the code for better speed, efficiency, and overall performance. The level of customization I'm aiming for in the Chatbot's responses...

I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.

...Minimum of 10 years' practical experience in cybersecurity, preferably with recognized companies. Proficiency with various cybersecurity tools and programming languages. Expertise in identifying and mitigating risks, threats, and vulnerabilities. Technical Skills: Hands-on experience with Security Information and Event Management (SIEM) tools. Proficiency in Python, Linux, and SQL. Knowledge of CIA Triad, governance, risk analysis, compliance, and business continuity planning. Familiarity with Linux and Windows server configuration, Active Directory, network architecture, operations, and security. Experience in areas such as Wireshark, email security, wireless security, cryptography, port scanning, cloud security, and virtualization. ...

I am in need of a skilled .NET developer, someon...gateway integration, ideally familiar with 2D/Sekretpay. - I've made modification to the code that should enhance the existing functionality of my project. Specifically, this is regarding a custom payment gateway where I have changed the API token. - Your role will be to assist in updating this code on the .NET framework, ensuring that changes made don't compromise any other functionalities. - Ideally, you should have prior experience in working with .NET and specifically in the realm of payment gateways and handling API changes. This will allow you to understand the complexities of the job better. If you believe you've got the skills and experience needed, I'd love to hear from you. Let's g...

We are in search of a skilled PHP developer to assist us in optimizing the code of our WordPress plugin based on feedback from WordPress. The ideal candidate should have a strong background in PHP development, particularly within the WordPress ecosystem, and be familiar with best practices for plugin development. Responsibilities: - Review and analyze feedback provided by WordPress on the performance and quality of our plugin code. - Identify areas for improvement and optimization within the existing codebase. - Clean and refactor code to enhance performance, security, and maintainability. - Collaborate with our development team to implement necessary changes and improvements. - Conduct thorough testing to ensure that the plugin functions correctly after optimizations...

I am seeking an experienced software developer with expertise in creating robust web application...analysis for better decision making Needed Functionality: - Inventory management system: The application should keep accurate track of the inventory levels and alert the users when restocking is needed. - Payment management: The application should be capable of processing payments, invoices, and balancing accounts. Ideal Skills: - Proficiency in back-end and front-end development - Knowledge in SQL for database structure - Understanding of payment gateways The successful freelancer should exhibit strong understanding of cloud infrastructures and advanced data security measures. Experience in creating similar systems would be a significant advantage. The simpler the application UI, t...

I need an experienced developer with proficiency in both Vue.js and .NET, capable of delivering the project in a short time frame. - **Role Requirements** - Vue.js and .NET expertise, preferably in developing ...an interactive UI. - I place a significant emphasis on an engaging, usable and intuitive interface. - **Timeline** - The project needs to be completed ASAP. So, I'm looking for someone who can dedicate sufficient time immediately. -** Vue.js 2 and 3 experience ** with .Net Web API and sql server required on expert level Ideal candidates can demonstrate previous experience working on similar projects and have a strong understanding of UI/UX principles. this a NDA Project and no code will be share and is a remote work, NO PHP folks needed or bid on thi...

...and rate limits. Redirect to Uber/Lyft: Once users have compared the fare estimates, they should have the option to proceed with their preferred service. Upon clicking on either Uber or Lyft, they should be seamlessly redirected to the respective company's website or app to complete the booking process. Forum for Drivers and Riders: Create a vibrant forum section using a suitable Laravel forum package or plugin. This forum will serve as a platform for drivers and riders to connect, share experiences, discuss industry-related topics, and provide feedback. Implement features such as user registration, discussion threads, replies, likes/dislikes, and the ability to report inappropriate content. Encourage a sense of community and engagement among users. Blog for Industry Insig...

I'm looking for an experienced Webflow developer to update certain sections of a website. 1. Scroller section with right side image sticky to be created. You may copy and use public webflow templates to acheive this but match colour and font of existing site. 2. Addition of headers and titles in some sections Make sure all work is responsive Please see drive for exact work - Please give exact bid and timeline. Would be great if you can start work now.

... but tailored to our specific needs, including custom graphics and a unique logo that represents our brand identity. KEY REQUIREMENTS Languages and Frameworks: - Frontend: Expertise in HTML5, CSS3, JavaScript, and experience with frameworks like React.js or AngularJS. - Backend: Proficiency in server-side languages such as PHP, Python, or Node.js, with database management using SQL or MongoDB. - CMS Experience: Capability to integrate and customize content management systems (CMS), preferably WordPress or Drupal. Design and Graphics: - Creation of a unique logo and custom graphics that reflect our brand and the services we offer. - Design a responsive and accessible website that adjusts smoothly to different screen sizes and devices. - Clear and intuitive navigation system

1. Classes in the package:  MainClass: Will have the main method:  It will control the flow of your program.  It will create an arraylist of patients (only one arraylist should exist in your program)  It will prompt the user to select one of the following options (these options will keep being displayed after each selection until we exit the program): 1. Admit a patient The program will ask if the PCR test result is negative or positive and that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a positive PCR test should ...

I am seeking a developer with intermediate level experience IOS Swift. The main task will be to help me get the example working from the documentation at This is my first time working with IOS and the docs leave out some of the implementation. For example: ``` var totalUsageByCategory: [ActivityCategory:TimeInterval] totalUsageByCategory = (…) ```