Sql advanced stored procedure 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ä.

PSD file should be encoded in HTML5 as a ...a MySQL database, which is pre-coded. Player makes bitcoin transfer us, and the transfer is calculated to 20-digit binary number which determines a coin shop. 0 = right and 1 = left. Binary and bitcoin transfer calculation are encoded completed, but the playing area and mainsite should be encoded bit in the same style as has been done site. This would be good to manage HTML5, Canvas Advanced Animation Toolkit, jQuery, Windows animateframe, maybe socket open. Mysql database is complete, 20-digit binary number and the database is ready, but the game on the site is not yet as a PSD file. The coin must looking good when it comes down to. The coin must move a the same way as site and the end of the multiplier must be the final effect.

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

I'm looking to streamline our purchasing process through a high-level overview of our procurement policy and procedures. This document will be used by all em...procedures - Ensure it is user-friendly and accessible to all employees - Consider the use of diagrams or simplified processes to aid understanding - The document should be concise, focused on the main processes and steps without getting too detailed Ideal skills and experience for this job include: - Strong understanding of procurement processes and best practices - Experience in policy and procedure development - Ability to simplify complex processes for a wide audience - Excellent communication skills to ensure the document is clear and accessible to all employees - Previous experience with streamlining proce...

I am seeking a proficient R programmer to assist with the evaluation of statistical significance in a large dataset. This project will involve data cleaning processes to address missing data, outliers, and unbalanced classes from CSV files. An in-depth understanding of advanced analytics and R programming is needed. • Proficiency in R language • Experience handling CSV files • Strong ability with data cleaning methods (dealing with missing data, accurately identifying outliers, working with unbalanced classes) • Expertise in evaluating statistical significance The selected candidate should not only have technical expertise but also the ability to interpret data and present findings in a clear, concise manner. This project shall pave the way for consequential de...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

...generate engaging, promotional contents on 27 different types of cancer. The final product should account for around 300 words per cancer, totaling approximately 8,100 words. Your task will involve: - Research and understanding of each cancer type - Writing simple, layman-friendly pieces to attract the attention of the general public - Promoting oncology knowledge and awareness without the use of advanced scientific language Ideal candidates would have a background in medical or science writing, and a talent for transforming complex concepts into easy-to-understand contents. Additionally, a basic understanding of oncology would be beneficial. Empathy and sensitivity are also required as the topic is sensitive for many. Ultimately, this project is about educating the general pub...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

I am currently in need of a proficient Excel expert capable of aiding me in data anal...amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An understanding of investment would also be advantageous. Applicants will be judged on past work experience as well as their insight into my project needs. I look forward to working...

As someone with an advanced understanding of Crypto and a specific interest in leveraging Crypto Liquidity Pools, I'm seeking an experienced individual to guide me in this area. My primary goal is to deepen my knowledge of DeFi, specifically through the lens of liquidity pools, with an intention to expand my investment strategy and potentially earn passive income. Key Requirements: - Proven experience and understanding of Crypto Liquidity Pools and DeFi - Ability to provide comprehensive, engaging, and tailored guidance to an advanced learner - A track record of helping clients achieve their investment and DeFi goals Ideal Skills and Experience: - Strong grasp of Crypto and DeFi concepts - Previous experience with Crypto Liquidity Pools - Excellent communication skills...

I am a dedicated Software Engineer and Team Leader in the software industry, seeking a highly capable Virtual Assistant to support my diverse range of tasks, including managing communications, project schedules, and extensive online research. This role is ideal for individuals who are familiar with the tech industry and are proficient in using advanced digital tools. Key Responsibilities: Email and Communication Management: You will be responsible for managing my email inbox, ensuring that all communications are responded to promptly and that key messages are organized and accessible. Experience in professional communication management is highly valued. Calendar and Schedule Management: The assistant will need to maintain and manage my calendar meticulously, scheduling meetings, ...

I am a dedicated Software Engineer and Team Leader in the software industry, seeking a highly capable Virtual Assistant to support my diverse range of tasks, including managing communications, project schedules, and extensive online research. This role is ideal for individuals who are familiar with the tech industry and are proficient in using advanced digital tools. Key Responsibilities: Email and Communication Management: You will be responsible for managing my email inbox, ensuring that all communications are responded to promptly and that key messages are organized and accessible. Experience in professional communication management is highly valued. Calendar and Schedule Management: The assistant will need to maintain and manage my calendar meticulously, scheduling meetings, ...

I'm looking for an experienced developer to build a custom ecommerce website, primarily using WooCommerce. The focus of this project is the creation of a highly customized product page for our unique products. Here's what is required: - The product is custom and has multiple variables including color, size, and material type selection. The product page should allow customers to select from these options with ease. - Additionally, the product page should feature a "step-by-step configuration process". This means that the customer should be guided through the customization process in an intuitive and user-friendly manner. Ideal Skills and Experience: - Proficient in WooCommerce and prior experience in building custom product pages. - Strong understanding of ecommerce pl...

I need a program that can scrape for the addresses of homes listed and compile them into a CSV file. The program should include the duration each house has been listed on the site, and have it run every hour to capture new listings. Additionally, I would like duplicates to be automatically eliminated. Key Responsib...file against another data base that has age and name of owner and contact info. Ideal Skills and Experience: - Experience in web scraping and data extraction - Proficiency in programming languages suitable for web scraping (e.g. Python, Scrapy) - Knowledge of CSV file creation and data handling - Ability to automate processes for regular data updates Please note that the addresses should be stored in the CSV file with each one on a separate line for easy reading.

I'm in need of a skilled web developer to create a tutor booking website. I aim to create a platform that connects students with tutors in Math, Science, and Language. Here's an outline of the project's major requirements: - Tutor Selection: The website should allow students to pick their preferred tutors from a selection of listed tutors. - Customized Tutor Profiles: I'm looking for an advanced level of customization for the tutor profiles. This should include the ability for the tutors to set their availability schedule, custom pricing, and have direct messaging with students. The ideal freelancer for this project should have a strong background in web development, particularly in building platforms that involve user interactions. Experience in creating si...

...existing desktop wireframe into a professional and polished design. The current desktop wireframe has structural issues, poor typography, and inconsistent spacing, creating an unorganized layout. In addition, we need a mobile version that aligns with the newly enhanced desktop design. Your expertise will ensure both versions meet professional standards. Key Requirements: Figma Proficiency: - Advanced proficiency in Figma for wireframing and design. - Create visually appealing, interactive layouts using reusable components. - Implement a minimalist design system. Design Refinement: - Overhaul typography for better readability and consistency. - Adjust spacing and layout for clarity and structure. - Implement a cohesive, minimalist visual style. Mobile Design: - Adapt the newly en...

...for few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fai...

...SPEC-01: AI-Powered Auto-Broker Application Development - MVP == Background This project involves developing an MVP for an AI-powered buyers' agent auto-broker app using FlutterFlow and completing an existing partially completed app design(see images). Developer should be able to integrate existing tools and services to maximize development speed and cost efficiency, laying the groundwork for more advanced features in later phases. The app leverages the MarketCheck API for automotive data and employs AI technologies to enhance the car buying experience. == Requirements *Must-Have (MoSCoW Method)* - Continue development off an existing FlutterFlow project with provided screenshots. - Efficient data handling and querying in Firebase Firestore with required indexing. - In...

I'm looking for an experienced full-stack and OAuth expert to integrate OAuth authentication for Twitter, TikTok into existing React.js applications. You are responsible for implementing a seamless user authentication experience that allows users to connect their social media accounts to our platform. If authentication is successful, the user's social media profile information should be safely stored in the database. For example, when the user presses the "Twitter connection" button, the Twitter user information input field using OAuth appears, and when entered, the information is changed to the "connected Twitter". If you successfully complete this task, I will award you development of all parts of this project. I attached a screenshot Looking forwa...

...of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new search, the stored information will be automatically deleted. Main Functionalities: 1. Custom API Parameter Configuration: Set headers, HTTP method, and data interactively. 2. Data Selection for Filtering: Allow filtering data by name, identification number, or both, to standardize information. The equivalent field in the endpoint to be queried should be placed alongside. 3. Data Mapping and Standa...

I need to convert a complex PDF file into AutoCAD 2021. The original document contains a number of layers and dimensions that need to be accurately transcribed. I prefer working with someone who is comfortable with video calls as I will need to communicate and request revisions through this medium. Your understanding of AutoCAD should be advanced to ensure that the converted file is precise and error-free. Additionally, promptness and responsiveness to video call meetings is crucial for this project.

I'm looking for a skilled web scraper to handle challenging websites with advanced detection. The main data you will be required to scrape is text content. Here are the key project details: Ideal candidate should have: - Experience in web scraping, especially from challenging sites - Strong knowledge of web scraping tools and techniques - Proficiency in handling advanced automation detection - Excellent attention to detail to maintain a high level of data accuracy - Ability to deliver monthly updates in a timely manner Please include any relevant past experiences or examples of similar projects in your bid.

As an advanced Master's student, I am currently in the midst of working on my thesis, which centers around the unique intersection of logistics and technology. With a word count falling within the 10,000-20,000 range, I am in need of a talented editor and proofreader to help polish my work. Key responsibilities will include: - Comprehensive proofreading for grammar, punctuation, and spelling errors. - In-depth editing to improve sentence structure, readability, and flow of ideas. - Ensuring technical terms related to logistics and technology are used accurately. Ideal candidates should possess: - Proven experience in academic editing and proofreading, preferably with a background in logistics and technology. - Attention to detail and excellent command over English language...

...of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new search, the stored information will be automatically deleted. Main Functionalities: 1. Custom API Parameter Configuration: Set headers, HTTP method, and data interactively. 2. Data Selection for Filtering: Allow filtering data by name, identification number, or both, to standardize information. The equivalent field in the endpoint to be queried should be placed alongside. 3. Data Mapping and Standa...

I need an expert with solid experience with AWS services, particularly Elastic Beanstalk and S3. As part of this project, I require: - Deployment of two applications on Elastic Beanstalk within my existing architecture. - Set up of two S3 buckets intended to store app data and archive data. The data to be stored is expected to be in the medium range (1-10 GB). Therefore, the buckets must be optimized for this scale. Required skills and experiences: - AWS Elastic Beanstalk: It's crucial for you to understand and proficiently manage application deployment within my infrastructure. - AWS S3: You need to have expertise in creating and managing S3 buckets, specifically for storing application data and archiving purposes. The main aim of this project is to develop two S3 buck...

I'm in need of an expert video editor. This project will involve advanced editing such as color correction, motion graphics, and audio enhancement. Details of the Project: - The video duration is under 5 minutes. - The content provided for editing will be stock footage. Ideal Skills And Experience: - Proficiency in advanced video editing techniques. - Experience with color correction and audio enhancement. - A strong sense of creativity and attention to detail. - Familiarity with editing stock footage to create engaging videos. I look forward to collaborating with a skilled video editor who can bring my vision to life!

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

I am seeking a skilled SAP Fiori expert, particularly with experience in the Transactional Fiori app, to aid me in configuring an existing Fiori app on our SAP S/4HANA system. Key Requirements: - Creation of a substitution within Fiori app - The substitution should concatenate invoice reference, reason code, and customer information - Concatenated information should be stored in a text field in residual clearing Ideal Skills: - Proficient in SAP Fiori configuration - Strong understanding of SAP S/4HANA system - Experience with Transactional Fiori apps Your expertise in this area will be highly appreciated, and I look forward to working with a professional who can provide clear guidance and support in this matter.

I am looking for a highly experienced and knowledgeable mechatronics tutor who has experience in Automotive R&D and exposure to Industrial/Production. The ideal candidate for this opportunity is one with advanced expertise in mechatronics 1) Teach me basic and also enable me to be able to look the design,understand and suggest Industrial improvements. 2) Review the Design and suggest improvment

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

I'm looking for a skilled individual to develop a custom Google script spreadsheet to cater for my company's specific needs in the area of sure betting/matched betting and accounting functionality. This project is of high significance and is strictly for in-house usage. Ideal Spreadsheet Functions: - Sure betting/matched betting analysis: Essential for calculating sure bets and providing comprehensive insights. - Accounting functions: Streamlined tracking of profits, bets, balances and expenses. - Identity management: Essential for identifying our partners, keeping track of their ownership share based on gain, withdrawals, and deposits to the company. - Sequential betting tracking: We would need this for a detailed record of sequential bets. We can explain further on this speci...

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

...functionalities: - The user tier is 50 and the main focus of the web app is communication. We want to avoid communication with our members through WhatsApp and emails. Communication can be send through the web app to one, a group of members or all members with a specific role. - The different roles are: admin, staff, parent and kid. - Members can be managed in the web app (CRUD). Personal information can be stored by admin or staff, and a part of the information can be read by one or more members (of type parent). A parent can be linked with more than one members of type parent. - Members of type kid can be managed per season (CRUD) (ex. 2024-2025, 2025-2026, …), and a season contains about 34 sessions. Each saterday morning there are two sessions (psychomotor skills and b...

I'm looking for an experienced WordPress developer to create an interactive and complex website for me using Advanced Custom Fields (ACF). Key Project Details: - The website will feature less than 10 pages, so it should be relatively straightforward to navigate. - The main functionalities I want to include aren't explicitly listed, but I'd like the website to be engaging, user-friendly, and visually appealing. Ideal Skills and Experience: - Proficiency in WordPress and Advanced Custom Fields is a must. - Proven experience in designing and developing interactive websites. - Strong understanding of user experience and good design principles. - Excellent communication skills and a proactive approach to problem-solving. I'm open to suggestions and recomm...

I am seeking a skilled freelancer with proficiency in Excel,...A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK AND THE TOTAL OF ALL NEED TO PRINT EACH WORKBOOK AS IMAGE IN A3 AFTER COLORING CELLS - Applying frequency distribution in order to derive significant trends from the data - Creating pie charts that effectively visualize the results and insights gathered from the analysis. The ideal candidate would have experience in advanced Excel functions, statistical analysis, and data visualization. Familiarity with frequency distribution and the ability to convert these results into visually attractive and easy-to-understand pie charts is paramount. Please include examples of similar projects you have worked on in your bid. I am looking forward to your ...

I require a specialized robot capable of locating and compiling available citations from business websites. As a fundamental part of this project, I am looking for: - Proficiency in handling and extracting data from different business sources, specifically focusing on citations. - Advanced skills in programming and web scraping to efficiently channel through high amounts of data. - Understand the "citation" within the context of a business website as a direct link to the company's website. The ideal candidate would be someone with vast experience in data mining, web scraping, and programming. Previous exposure to business data sources would be a bonus.

...Capabilities: The form must support file uploads specifically for image and document files. No video file uploads are permitted. - Auto-Response: Configure the form to send an automated reply once a customer fills it out. This reaction should reassure the client that their message has successfully been received. - Database Utility: Arrange for all submitted information through the form to be securely stored in a database. This will streamline tracking and handling of client queries. Details of the DB structure will be provided. - Security Measures: Implement Captcha security to filter out any potential spam or automated entries. - Skills Required: Deep understanding of HTML, CSS, JavaScript, and server-side scripting languages. Familiarity with database management and maint...

I'm currently studying at an advanced level in quantum physics and am looking for an experienced tutor who can guide me through unchartered territories. The specific topics I need to cover are not defined yet, hence flexibility and depth of knowledge will be key. Ideal candidate: - Degree in Physics or related field - Extensive experience in advanced quantum physics - Expertise in various quantum physics topics - Proven record of effective tutoring Please note, the deadline for this project is flexible as I'm focusing on comprehensive understanding rather than fast-paced learning. Your availability and commitment to the project will be important. Let's help me dive deeper into the world of quantum physics.

I need an experienced team of developer for building an online trading portal with user registration, login, and complex transaction capabilities. The platform should have a professional and corporate design. Key Features: - User registration and login - Advanced transaction functionality for enabling complex trades including options, futures, and derivatives Ideal Candidate: A developer with a good understanding of professional web design and familiarity with the stock market trading landscape in order to execute complex transactions on the platform. Prior experience in developing and working with financial technology will be highly valued. Design Preference: - The design should be clean, professional, and cater to a corporate audience. It should facilitate easy navigation an...

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.