Function stored procedure sql server 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

server optimisation

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

Here's what I'm looking for in this project: - Design of a basic PowerShell script with few commands. The complexity is on the lower side, thus making this project perfect for beginners and those wishing to further strengthen their scripting prowess. - The script should be fully compatible and able to function efficiently on a Windows operating system. - Features or exact tasks that the script is expected to do are open to the freelancer's creativity. It might entail simple system tasks, generating reports or monitoring system functions. Your insights and suggestions are welcome. - Ideally, you will have experience in Windows PowerShell scripting and a good understanding of Windows operating system functions. This is an ideal opportunity for seekers of a quick yet ...

Looking for a Large Language Model Expert who can build Function Calling (triggers, calendars, knowledge base triggers) for our app. We already have a function for calendar, but we want some changes, and looking for an expert to advise and quickly make changes to this function.

I am looking for a skilled web developer who can create a job website that caters to both employers and job seekers. The primary function of this site is to provide resume and portfolio hosting for all users. Key Features: - **Resume and Portfolio Hosting:** The website should allow users to create and upload their resumes and portfolios, and make them easily accessible to potential employers. - **Easy Job Search for Seekers:** One of the main priorities is to ensure that job seekers can find relevant job listings with ease. This means a user-friendly search function and clear categorization of job postings. Ideal Skills and Experience: - Proven experience in web development, ideally with a focus on job websites or similar platforms. - Ability to create an intuitive user...

I'm seeking a skilled developer to create a custom clicking bot for a specific cryptocurrency website. The bot's purpose is to monitor and automatically click on certain links on the platform. Key requirements: - The bot should be able to navigate through the website, identify the links, and click on them. - The bot should be able to function seamlessly and consistently over time. Ideal Skills and Experience: - Proficient in developing bots and automation software - Experience with monitoring and interacting with websites Please note that the bot will be required to interact with Cryptocurrency faucets and crypto currency platforms. The project will involve continuous monitoring, testing, and troubleshooting to ensure the bot remains functional.

Hello, I'm looking for someone who can improve code written in Python. The application downloads data from Telegram and enters into transactions by setting stop loss and take profit at a given level. I have a problem with the limit function and setting stop loss and take profit correctly. I'm looking for someone who could improve the application code.

THIS PROJECT NEEDS TO BE COMPLETED TODAY IN THE NEXT 4-6 HOURS. DONT RESPOND IF YOU CANT DELIVER IN THIS TIME FRAME. RESPOND WITH ACTUAL COST AND DONT ASK ME MY BUDGET. YOU TELL ME WHAT YOU WANT TO COMPLETE THIS PROJECT IN 1-2 HOURS. I need a creative graphic designer to work on a menu board design tailored to my restaurant's theme. - The main function of the design is to display our food items prominently. - It also has to be an effective tool for promoting our restaurant's vintage branding. - The size should be 1800x700, and the orientation is landscape. Ideal Skills: - Proficiency with graphic design software - Prior experience in creating menu boards - Ability to incorporate vintage elements effectively - Understanding of effective restaurant branding - Attention t...

I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks super...Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Unit Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Unit Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...

Your main task will be to integrate a Zebra RFID reader into an existing software application in Visual studio software. Note: Person who already has Zebra RFID reader 8500 or RFD40 reader must bid for the project, since it is hardware based integration project. Tasks: 1. Single read function 2. Import CSV and perform inventory check If you're a Visual Studio developer with a background in Zebra RFID reader integration, I'd love to discuss how you can help improve our existing software through your skills and expertise.

...through a multifaceted approach. Essential Features: - The processor should be able to identify user-provided information through the comparison of ID documents, facial recognition technology, and verification of phone numbers and email addresses. - A searchable database must be integrated for easy retrieval of stored documentation. Security Measures: - While I don't need two-factor authentication or regular security audits, I expect a robust security system in place. The encrypted stored data should meet industry standards to ensure user privacy and regulatory compliance. Ideal Skills and Experience: - Proficiency in developing KYC/AML processors, with a portfolio of relevant past projects. - Strong knowledge of data security and privacy measures. - Experience ...

I'm in need of a seasoned C# programmer with a proven track record in REST API integration and MS SQL Database management. Your primary task will be to create an interface between a C# application and FactoryTalk Optix software. Key Requirements: - Comprehensive experience in C# programming - Proven track record in developing REST APIs - Proficiency with MS SQL Database - Very familiar with FactoryTalk Optix software The primary goal of the REST API interface is to facilitate data exchange between applications. The interface should be able to handle text and numerical data. Please provide examples of previous REST API integrations and your specific experience with FactoryTalk Optix. Your understanding of data management and exchange will be crucial for this project.

...developer who specializes in the Windows platform. My project is focused on creating an efficient and seamless learning application that can be used offline. Key aspects: - The core functionality of the app is to facilitate educational content sharing. Candidates with previous experience in e-learning apps will be highly preferred. - One of the critical requirements is that the app would be able to function in offline mode. The app should allow content to be downloaded and accessed without the internet. - Developers should be able to work with the Windows platform. Ideal Skills: - Expertise in Windows app development - Prior experience with creating offline-based apps - Familiarity with education-focused app development. Priority will be given to candidates who can show a portf...

...remote endpoint (Basic JSON PHP script) 2 Create drop-down which will "refresh" App screen an load data from endpoint sending $CUR_ID=1 etc 2) Integrate a few widgets i have already created in Dart. 3) integrate a chart that i have already creadted in Dart 4) Create Footer menu, bit like a bootstrap one 5) Create Anaysis and news and logout landing pages - Logout function should work and it should show name of user using stored local or session data 6) App should timeout after 5 minutes of inactivity and go to login screen and destory session data 7) make it look exactly like screenshots and responsive on phone tablet etc...flutter should ensure cross platform. I will share these once we talk further Please make clear, commented code :) Add "flutter...

My client's website currently uses a standard search field to allow users to enter a location or address. I want an autocomplete function added, so that when the user starts to type in an address, it will show suggested locations. PLEASE SEE MY BRIEF ATTACHED WITH SCREENSHOTS

...experienced professional who can proficiently analyze my Windows Server 2008 R2 log files. The primary goal of this task is to troubleshoot potential Networking and application errors. Key Responsibilities: - Analyze Application logs, System logs, and help in resolving Networking issues. - Identify and troubleshoot application errors within the log files - Provide a detailed analysis report with recommendations for resolution The ideal freelancer for this project should: - Have considerable experience in Windows Server log file analysis - Be adept at troubleshooting application issues - Demonstrate a proven track record of similar work in the past - Be able to provide clear and concise reports - Strong understanding of Windows Server 2008 R2 Your application sho...

...Objectives for the system: 1. It has to be completely offline (no online solutions will be accepted); 2. System has to be integrated with LLM (Llama or similar); 3. LLM must be capable on answering questions (via chatbot interface on GUI) on: a. DP’s; and b. Text it read while it was scanning the PDF and looking for DP’s; c. Previously read documents related to the same client. 4. DP’s are to be saved to SQL table; 5. We need a dashboard, to train the engine on finding DP’s in the document. Current problems: A. Large part of documents are scanned, but regardless if the document is scanned or not, it’s all in digital form format. It just so happens that some forms were populated digitally, printed, and scanned; B. As such, scanned documents are: a. T...

MUST HAVE 10 years of Experience As a Senior Angular Developer, I am in need of an experienced professional to aid the development of my Angular 14 application. The project involves a few key components that I require assistance with: - **CRUD Operations:** The primary function of the project will be to facilitate CRUD operations. It is imperative that the chosen freelancer has a solid understanding of this concept and can implement it seamlessly within the application. - **Integration with Third-Party Services:** While the application will not require integration with a payment processing system, email service, or any social media APIs, it is important to have a grasp of integrating applications with other services. Key Skills and Experience: - Proven experience with Angular ...

...Monitoring**: The system should be able to identify vehicles within a CCTV live stream. - **Image Extraction**: The identified vehicles' images should be extracted effectively for further processing. - **Number Plate Recognition**: It is crucial that the system is capable of accurately recognizing and transcribing number plates. The accuracy level required is high, meaning the system should be able to function well in various conditions, such as night-time and weather conditions. We want this system to be installed at Stone Crusher. So vehicles will be of big size (Tipper, dumper) - **Data Storage**: The extracted images and transcribed number plates should be sent to an external API. Ideal Skills: - Proficiency in Computer Vision and Image Processing - Experience in real-...

...e-commerce business, I am seeking a skilled and experienced Shopify developer for the construction of our online store. Key skills and experiences I am seeking include: - Proficiency in Shopify platform. - Proven experience in E-Commerce website development is a must. - Ability to assist in any potential troubleshooting or technical issues. The website's main purpose is to sell products, so the key function required is product listing. Please note that no further specific functionality was concluded at this time. However, your insight on optimizing the shopping experience, including but not limited to suggestions on shopping cart and customer reviews features, would be greatly appreciated. Please provide work samples of previous e-commerce sites you have developed or man...

I'm seeking a proficient MySQL and Node.js expert for database design and backend development, specifically focused on generatin...development, specifically focused on generating user activity reports. This task will involve the following: - Database Construction: Build an optimized and functional database perfect for efficient data queries. - Backend Development: Create a robust backend system capable of handling and processing large amounts of data. - Report Generation: Develop a system for creating user activity reports from the stored data. Ideal candidates should have significant experience with MySQL and Node.js, and a proven track record in data management and report generation. Your expertise in query optimization and API development will be crucial for effective proj...

I'm facing an issue with logging errors when making HTTP requests using PHP. The error message does not get stored in the log file. I need someone to help me troubleshoot this issue. Key Responsibilities: - Investigate the issue with the error logging system in PHP - Determine the cause for the absence of error logs - Implement necessary fixes to ensure all requests and their corresponding errors are correctly logged Ideal Skills and Experience: - Proficient in PHP and error handling - Experience with HTTP requests and error logging - Previous experience in troubleshooting similar issues - Familiarity with remote desktop sharing tools like AnyDesk would be a plus Please note that due to the nature of the issue and the need for real-time collaboration, the work will be done ...

I am in need of an experienced tax professional who can accurately file an individual income tax return with a focus on salary or pension income source. Job requirements: - Extensive experience in income tax return filing - Specialize in individual returns based on salary or pension earnings - Meticulous attention to detail, specifically to ens...tax return with a focus on salary or pension income source. Job requirements: - Extensive experience in income tax return filing - Specialize in individual returns based on salary or pension earnings - Meticulous attention to detail, specifically to ensure that no deductible expenses are missed Please note that no tax-deductible expenses have to be considered. Accuracy and proficiency in the procedure is crucial. Thanks in advance for ...

I'm in need of an expert who can design and develop an E-commerce website for me. The key part is that I do not need it to be built using the common platforms like Shopify, WooCommerce or Magento, but instead, via Amazon. In terms of features, I want to keep the design sleek yet user-friendly, with an integrated shopping cart function. Ideal skills and experience would include: * Proficient in handling Amazon e-commerce website setup. * Expert in web design with a clear understanding of the best practices for E-commerce sites. * Experience in integrating shopping cart functionality on e-commerce platforms. * Innovative approach towards interface design. * Prior work with a similar project scope will be highly beneficial. Interested freelancers, please share your previous work...

...inserts for our company. The main purpose of this is to help with the organization of certain key documents. Please see below for more details: - The pocket folder and its inserts should be organized in a way that is highly functional and visually appealing. The design should make it clear that the folder is aimed at families, while also maintaining a professional appearance. - The content to be stored in the pocket folder includes a company overview and company offering. The folder should be designed in a way that makes it easy for families to understand and access this information. - I'm looking for a designer with experience in creating print materials, especially those that are aimed at a family audience. A creative approach to organizing information and a strong atte...

I'm looking to develop a new, clean, efficient messenger app specifically for Android devices. It should have a primary feature of text messaging and an additional feature of photo sharing. Key Features: - Text Messaging: This should be the core function of the app. It should support all basic text messaging functionality, including sending and receiving messages. - Photo Sharing: In addition to text messaging, I would like the app to have a photo sharing functionality. Users should be able to easily share photos with their contacts. Ideal Skills and Experience: - Proficient in Android App Development: You should have a strong background in developing Android apps, and have experience building messaging apps. - Experience with Photo Sharing Features: Previous work on apps wi...

I'm looking for a skilled developer to assist me in creating a PDF editor that can perform automatic calculations within the text fields. Key Requirements: - Text Editing: The primary function is to allow for text editing within PDF files. - Automatic Calculations: The editor should be able to perform summation and subtraction calculations within the text fields. Ideal Skills and Experience: - Proficient in PDF file manipulation and editing. - Experience in integrating accounting functionalities within software. Please note that the editor should be compatible with all PDF viewers and be user-friendly, allowing for smooth and efficient workflow.

...both Canvas and Model-driven Power Apps. These applications should be designed to interface seamlessly with SharePoint and SQL databases. Key functionalities to be incorporated include; * Workflow automation: Our applications should aid in achieving seamless workflow, eliminating unnecessary delays and redundancies. * Data integration: Facilitating effective synchronization of data across different platforms and databases. * Document management: Applications developed should have mechanisms that streamline the creation, storage, and retrieval of digital documents. The ideal freelancer should possess a wealth of experience in Power Apps development, SharePoint, SQL, and proficiency in Power Automate. We're looking for a skilled individual who understands the intric...

I'm looking for a highly skilled and artistic 3D fashion designer to conceptualize and create completely unique clothing designs. It's essential that your forte strays towards minimalist and clean aesthetics. Expectations include: - Original Concepts: I want never-before-seen designs that challenge conventional attire norms. - Minimalist Design: The ability to encapsulate simplicity and function in your designs is vital. - Adaptability: Your designs need to be adjusted according to real-world considerations or feedback. Ideal Skills Experience and Skills: - Proven track record in 3D fashion design, particularly in clothing. - A strong portfolio showcasing your knack for minimalist and clean designs. - Excellent communication skills as well as the ability to grasp and tr...

Hi guys! I am looking for an Shopware 5 Developer on this project. This plugin needs a function more: The function i want is that we can choose per Shop the document which should be taken. Look at attachment. The reason i need this: We have a mainshop which generate a invoice document with information A and we have a subshop which need a other document with information B. The plugin generate and sends automatic the invoices. We need to choose the document per shop that every client get the right document. The person i choose to work will get the plugin and needs to install it on his own test shop. As alternate i can give you a staging shop. If you have no experience with shopware

I am in need of a skilled UI/UX designer to join my startup team and help create a unique platform centered around providing exclusive experiences for couples. This platform will function as a social space where couples can communicate privately, share a calendar, and access a recommendation engine tailored to their preferences. To provide an effective design that meets our users' needs, you'll: - Function essentially as a product manager/designer, primarily focusing on developing wireframes. - Pay close attention to our requirements for private messaging, a shared calendar, and a recommendation engine. These features are essential for the platform's success. - Submit a detailed project proposal, showcasing how you intend to meet our specific needs, propose p...

Determine the right sensors and communication protocols to use in a particular IoT - reference Select from a range of possible technologies and appropriately deploy Cloud Services using different cloud - reference Implement security features to protect data stored in the cloud. MO3 - reference

I am trying to provide as much description as possible, but feel free to contact me if you need more information. This is a simple proje...session, as sessions have an initial and end date/time). Student conversations on a chat session get logged into the database. On the Teacher Backend, Teachers can download transcripts of all the conversations their students have had for a specific session (the transcripts would show the students username, the conversation and the transcript with timestamps). Passwords on the database are to be stored with MD5 or similar encription (there is no need for super high level as there is no identifiable information on the DB except for whatever conversations students have). Ideal Skills and Experience: * Proficiency in PHP and MySQL * Experience w...

Note: make millions after see results The AI Influencer Agency Bot would function as a middleman between businesses seeking to promote their products or services and influencers interested in collaboration. Here's how it would work: 1. **Business Search**: The bot would search for businesses looking to promote their products through influencer marketing. This could involve scanning social media platforms, websites, and other online channels for potential leads. 2. **Influencer Search**: Simultaneously, the bot would also search for suitable influencers who align with the business's target audience and marketing objectives. It could analyze factors such as follower demographics, engagement rates, and content relevance to identify the best matches. 3. **Initiating Conta...

Ubuntu Apache Server Setup with PHP and MySQL

I'm in need of a...Web and Mobile applications - Proficiency in creating browser extension interfaces - Understanding of user-centered design principles - Proven track record of creating engaging and intuitive UI/UX designs The target audience for these applications is the general public, so it's important to create interfaces that are easily understandable and navigable to a wide range of users. The primary function of the applications is to provide social analytics data based on Twitter. It's crucial that the designer can create interfaces that not only look great but also support the functionality of this analytics service. This project will require a designer who is versatile, able to create designs that work seamlessly across different platforms, while keepi...

I need a function-packed mobile app created for my mobile detailing service. The app should be available on both Android and iOS platforms. Key Features: * Online Booking and Scheduling: Users should be able to conveniently book detailing services at their preferred times. * Customer Reviews and Ratings: The app should have a system for users to rate and review services provided. * Vehicle Registration: Users should be able to register and select their cars within the app. Ideal Proposal Includes: I am particularly interested in receiving detailed project proposals showcasing your understanding of this project and a roadmap to completion. Design Preference: I prefer a colorful theme with Red, Yellow, and Blue as dominant colors. Ideal Candidate: A freelancer who has experience ...

...both city/locality and mosque name. - Display the search results in a table format for easy understanding. Ideal Skills and Experience: - Proficiency in web development and database management. - Prior experience in creating searchable databases. - Familiarity with prayer time calculation and display will be a plus. We currently using a plugin table in wordpress to Display a table with a search Function. We need to Refine it as a Standalone page or subdomain site with search functions based on location , Distance to nearest masjid feature and / or Distance to next Masjids with upcoming Salaah times. OUR CURRENT MASAAJID SALAAH TIME PAGE IS : THE PAGE WITH THESE FEATURES WE LOOKING FOR : WITH SEARCH BUTTONS OF CITY

...analytical and problem-solving skills. Strong communication skills, both written and verbal. Ability to work independently and manage time effectively to meet project deadlines. Preferred Qualifications: Experience with testing web applications in various browsers and devices. Knowledge of HTML, CSS, and JavaScript. Experience with bug tracking tools like JIRA, Bugzilla, or similar. Familiarity with SQL and scripting. What We Offer: Competitive project-based rates. Flexible working hours. Opportunity to work with a dynamic and innovative team. Potential for ongoing collaboration on future projects. If you are a meticulous QA professional with a passion for ensuring top-quality web applications and are looking for project-based work, we would love to hear from you. Please submit...

I am looking for a skilled developer who has experience working with Rust and CrustyDB to help implement a few operators for a Query Execution Engine. Key Objectives: - Implement join operators to support more complex queries Ideal Skills: - Proficient in Rust and CrustyDB programming - Familiarity with database systems and query execution - Understanding of join operators and how they function within a database system The deliverables will be clear, well-commented code that is consistent with the project's instructions, which can be found in the provided link. Your focus will be on implementing join operators, so experience and understanding in this area are crucial.

I'm looking for an expert to perform a multi-node deployment of Corda on AWS using Kubernetes. Skills and Experience Required: - Strong knowledge of Corda platform - Extensive experience with AWS setups specifically Kubernetes - Proven track record of deploying multipl...knowledge of Corda platform - Extensive experience with AWS setups specifically Kubernetes - Proven track record of deploying multiple nodes on Kubernetes. Responsibilities include: - Setting up and configuring Kubernetes on AWS - Deploying multiple Corda nodes onto the AWS Kubernetes setup - Testing to ensure successful deployment and addressing any issues that may arise. - Demonstrate procedure to update application source code on Corda If you have the skills and experience I'm looking for, I'...