Perl execute sql server stored procedures output 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 ;)

I have a one hour podcast. I am in need of assistance with some of the audio quality (extraneous noises, variable volume, and some low quality areas). I have done the editing parts. Key Responsibilities: - Enhance and balance audio by mixing and mastering using professional audio software - Ensure the highest audio quality, minimize noise and enhance clarity - Deliver finished output in Audacity Project File format Ideal Skills and Experience: - Proven experience as an audio engineer working specifically with podcasts - Expertise in handling Audacity software - Strong knowledge of audio mixing and mastering techniques - Excellent attention to detail in balancing sound and eliminating background noise I'm keen to find a specialist who can help in delivering crisp, clear, an...

I need a professional to create a bootable macOS Sierra 10.12 as I plan on downgrading my Mac system. Unfortunately, I do not have the macOS Sierra 10.12 installation file, which is why I require someone capable of tracking it down. The ideal freelancer would have experience in creating bootable macOS versions, a deep understanding of Mac systems and software, preferably with experien...downgrading processes. This may involve: - Source a macOS Sierra 10.12 installation file - Create a reliable and secure bootable macOS Sierra 10.12 - Guide me through the process of using the bootable macOS for a fresh installation on Macmini (late2018) Previous similar projects and reviews would be an added advantage. Please submit your proposal with a brief explanation of how you plan to execute...

I'm in need of a skilled developer who is proficient in a variety of programming languages and can work on two key areas of my website. - Basket Featur...registration, the user remains on the registration page. This is not the intended behavior, and I need a solution that will ensure that users are correctly redirected to their profile page post-registration. . This video helps what im trying to say. Ideal candidates for this project should have a strong command of HTML, JavaScript, CSS, PHP, and SQL. In addition, experience with Stripe payment integration and troubleshooting registration processes on websites is highly desirable. Please note that these two tasks are interdependent, and hence, need to be addressed simultaneously.

I'm currently experiencing a peculiar issue on my CentOS server. The process /usr/sbin/mariadbd is showing 109% CPU usage in the WHM task manager, although the server load is stable and I haven't made any recent changes. Your primary task would be to diagnose and resolve this problem. No error messages or warning signs have appeared, making the source of the issue somewhat inscrutable. Access will be provided via AnyDesk or a remote desktop connection for swift and efficient troubleshooting. Your expertise in the following areas would be invaluable: - Proficiency in CentOS server administration - Expertise in WHM and server task management - Experience in identifying and resolving high CPU usage issues - Strong communication skills to work collab...

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page ...redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication a...

I need a professional with extensive experience in Fuzzy Logic and Matlab. Since I haven't defined the exact task or domain, I anticipate your ability to tackle various applications ranging from control system design, pattern recognition, forecasting, robotics, financial analysis, to traffic control. The final output, yet to be specified, could be anything from improved system performance, enhanced decision-making, or better data analysis. Since the assignment specifics are yet to determined, I require someone who is flexible, creative, and solutions-oriented. Matlab proficiency is a must.

...enhance the renders of a pre-existing school structure I've already modeled. Its a academic project Key Points: - The school structure is already modeled, but requires expert touch to elevate the realism of the renders. - I have set the desired views and added basic materials. Your task will be to add the finishing touches, including lighting and human models for scale and context. - The desired output is semi-realistic renders. So, you should have a keen eye for detail and an understanding of how to achieve this level of realism within Lumion. - These renders will be used primarily for presentations, hence they need to be engaging and professional. Ideal Skills & Experience: - Proficiency in Lumion and 3D modeling - Prior experience in creating semi-realistic rend...

...Nickel-metal hydride batteries. Key points to consider for this project: Skills and Experience • Understanding and experience in working with various battery types • Proficiency in Matlab for creating simulations and testing • Strong analytical modeling skills Project Objectives • Provide research and suggestions on optimizing battery life, decreasing charging time and improving power output. • Develop a comprehensive Matlab model suitable for variety of scenarios. • Evaluate optimization results using different methodology – simulation and testing, analytical modeling or field testing. Please ensure you have in-depth knowledge in this field, assisting me in achieving optimal results. Besides, great communication sk...

...a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to identify significant deviations. Daily Data Table: Summarize daily data for use with the SARIMA model, aiding in long-term consumption predictions and trends analysis. All the tables are fed from the main large table (secondly rate table - real time table). Details about the models: ML Model Development: Anomaly Detection Model: Develop a model using Random Forest algorithms to detect unusual patterns in energy usage. SARIMA Forecasting Model: Implement SARIMA models to forecast daily energy requirements, considering seasonal variations. Database: A cloud SQL real time database is preferred. Front end: After analyzing the data,...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I'm seeking an experienced app developer to create a high quality hybrid app that supports both iOS and Android platforms. The core functionality of the app should include: - User Profile Creation: Users should be able to establish their own unique profiles utilizing phone verification for authentication. It's c...establish their own unique profiles utilizing phone verification for authentication. It's crucial that this feature is secure, fast, and seamless for all users. Ideal candidate for this project must have: - Skill and experience in developing cross-platform or hybrid mobile apps - Expertise in user profile creation and phone authentication implementation - Attention to details ensuring high standard output - Exceptional problem-solving skills to efficientl...

I am looking for a skilled WordPress designer to create an engaging blog website. As client details were not provided, the site should be versatile enough to work for a personal, business, or news blog. - Design: While no specific design elements were specified, the site should be modern, user-friendly, and visually compelling. - Freelancer Applications: Potential fre... - Freelancer Applications: Potential freelancers should include examples of past work, their experience, and detailed project proposals when applying. Ideal Skills and Experience: - Advanced proficiency in WordPress. - Previous experience designing blog websites. - The ability to incorporate versatile features to suit various types of blogs. - Strong communication skills to comprehend and execute my vision ef...

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

I am looking for a skilled freelancer who has extensive experience in managing ads on both Google and Facebook. The main goal of this project is to increase the traffic to my website, focusing on professionals aged between 35-54 years. The ideal candidate for this job should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving t...should have: - Proven experience in managing Google and Facebook ad campaigns - A track record of achieving the goal of increased website traffic - A deep understanding of the professional demographic on these platforms - Excellent analytical skills to monitor and optimize the campaign's performance Please provide examples of your previous successful campaigns and details of how you plan to execute...

As a DevOps developer with substantial experience in Azure, particularly in Azure infrastructure, Azure DevOps, and Azure networking, I need your immediate support in the following areas: Your responsibilities will include: - Implementing continuous integration and continuous deployment strategies. - Resolving any bugs in the CI/CD pipeline and identifying improvements. To successfully execute this project, you should: - Have 5+ years of experience in the Azure environment. - Be proficient in Azure infrastructure, Azure DevOps, and Azure networking. - Have a track record in Jenkins, GitLab, and Azure DevOps. If you possess the above-mentioned skills and experience, please apply for this project.

...clients' unique needs. From SEO and social media marketing to email marketing and e-commerce strategies, we leverage cutting-edge techniques to drive results and exceed expectations. Position Available: We are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about storytelling and creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth analysis and implement conversion rate optimization strategies that enhance user experience and drive conversions SMM Guru: Do you live and breathe social media? As our...

...Strong understanding of User Experience principles to ensure a seamless and enjoyable user journey on the web platform. The ideal candidate for this project would be someone who is not only creative but also has a deep understanding of the principles of design and the technical implications of their decisions. You should be able to come up with innovative and original ideas, but also be able to execute these ideas in a way that is practical and effective. As I'm open to suggestions, I'm looking for a designer who can bring their expertise to the table and help me shape this project in a way that is both unique and impactful. If you think you have what it takes to deliver this comprehensive design project, I'd love to hear from you. Please provide a portfolio o...

With over 10,000 followers, my quotes and sayings themed TikTok account demands a better revenue strategy. Seeking an experienced social media monetization expe...followers, my quotes and sayings themed TikTok account demands a better revenue strategy. Seeking an experienced social media monetization expert to explore, design and implement strategies excluding sponsored content. Your tasks: - Identify successful alternative monetization methods for TikTok(include but not limited to merchandising, shoutouts, donations, affiliate marketing). - Develop and execute an effective action plan. Ideal skills and Experience: - Proven experience in social media management and monetization. - Sound knowledge about TikTok specific earning strategies. - Exceptional creativity and problem-solvi...

I am in urgent need of a high-quality app developer who is deeply versed with MacOS , I already have an app, images, source code etc but I keep getting errors while trying to upload to Mac app store Key Qualities and Skills: • Proficiency with MacOS Software Deve...is deeply versed with MacOS , I already have an app, images, source code etc but I keep getting errors while trying to upload to Mac app store Key Qualities and Skills: • Proficiency with MacOS Software Development inc Xcode I am working on tight schedules and thus I need this project completed as soon as possible, hence a developer who can keep time without compromising on the quality of output is preferred. Commitment, reliable communication, and professionalism are key traits that I am looking for in...

I need a skilled PHP developer for a project that requires merging multiple images into a single template. The primary ...Positioning and Size: The ability to adjust the positioning and size of the images being overlaid is essential. While I prefer a simple drag and drop tool to adjust these parameters, the output should be precise. - Output Formats: The final image should be available in both JPEG and PNG formats. Ideal skills and experience for this job include: - Strong proficiency in PHP: Since this project will be executed primarily in PHP, a solid understanding of this language is a must. - Image manipulation: Experience in overlaying images onto a template and managing their positioning and sizes is crucial. - Output formatting: Ability to generate images in bo...

I'm seeking a seasoned C++ programmer who can design an array-based heap effectively. The purpose of this project is to handle both max heap and min heap. Here are my specifications: - Implementation of the max heap and min heap within the same array-based heap structure. - The software should be able to execute both Insertion and Deletion operations. - It should facilitate Heapify operation, enabling the optimization of the heap structure. If you possess extensive knowledge and experience in heap data structures and can proficiently utilize this in C++, you are the right fit for this task.

I'm in need of a freelancer skilled in Windows server administration and virtualization technology, specifically VMware. Your task will be to set up a VPN server on my existing Windows virtual machine. Key tasks include: - Installing and configuring OpenVPN on the Windows server - Ensuring the VPN setup is secure and functions properly You should have deep knowledge and experience with Windows Server, VMware, and OpenVPN protocols. I'm expecting the project to be done efficiently and timeously without compromising on the server's security measures.

I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid proposal.

...Where: Script '/home/beemo/dev/flutter/packages/flutter_tools/gradle/src/main/groovy/' line: 1419 * What went wrong: Execution failed for task ':app:compileFlutterBuildDebug'. > Process 'command '/home/beemo/dev/flutter/bin/flutter'' finished with non-zero exit value 1 * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. * Get more help at BUILD FAILED in 20s Running Gradle task 'assembleDebug'... 21.0s Error: Gradle task assembleDebug failed with exit code 1...

...an immersive and detailed virtual reality walkthrough for a real estate project, based on the map I'll provide. This walkthrough will be used for client presentations, hence it needs to be of the highest quality. Key Project Requirements: - The walkthrough must be highly detailed with full textures, realistic lighting, and furnishing to give the client a real sense of the property. - The final output should be in a Virtual Reality format. This is critical for the project as we aim to deliver a realistic and interactive experience to our clients. Ideal Skills and Experience: - Proven experience in creating high-quality Virtual Reality content, particularly in real estate. - Proficiency in using tools and software for detailed modeling, texturing, lighting, and furnishing. -...

I'm in search of a professional based in Delhi/NCR to manage and maintain my website. The website is already developed, now I just need someone to maintain it and perform necessary updates and alterations. Key Responsibilities: - Execute content updates on the website as required. - Implement design modifications to enhance the user experience. - Improve website functionality to ensure it's always operating at its best. Requirements: - Proven experience in managing WordPress websites. - A keen eye for design and ability to implement changes effectively. - Understanding of website functionality and how to enhance it. - Availability to make changes as needed, so residing in Delhi/NCR is preferred.

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm looking for a professional to assist with the creation of a YouTube channel focused on insurance. The m...video content related to annuity and Medicare. - Ensuring that the content is accurate, up-to-date, and easy to understand for laymen. - Suggesting creative ideas and strategies for content diversification. Ideal candidates should have: - Prior experience in creating content on insurance topics. - An understanding of annuity and Medicare. - Excellent video editing skills to ensure high-quality output. - Strong communication and collaboration skills to work with me in creating a channel that aligns with my vision. Your role is crucial in making complex insurance topics accessible to the public, so a passion for educating and a creative approach to content creation are...

...Posts should be made three times a week. You will need to schedule these posts for optimal engagement. • Content Creation: I require original content created. You should be adept at crafting engaging posts that align with our brand voice and ethos. Proficiency in using various social media tools for graphics and video creation is a plus. This role requires someone who can strategize, plan, and execute compelling content while tracking performance. If you have a knack for understanding what makes social media users tick, this is your job....

...written Catering proposal on a Word document, along with supplied photos, into a visually striking Business Proposal. The goal is to use design software like InDesign (or your choice) to format the proposal in a modern and professional manner. Key Points: - The design of the Business Proposal should be modern. - It should include high-quality images that I have ready to provide. - The final output of this project should be in a digital format such as a PDF. Ideal Skills and Experience: - Proficiency in InDesign or similar design software. - Experience in creating visually appealing Business Proposals. - Strong eye for modern design and layout. - Ability to work with high-quality images. - Knowledge of digital document creation and formatting. Your task will be t...

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

...With limited specifics to provide, it is crucial for interested candidates to demonstrate a well-rounded skill set. My expectations include: - A variety of past work samples showcasing your talent in 3D modeling, animation, or rendering. - Your experience level in the 3D field. - A detailed project proposal outlining your work process, your understanding of the requirement and how you intend to execute it. The timeline and deadlines for the project are flexible, but I am interested in knowing your general availability and how swiftly you work within a given timeframe. Your proposal should, therefore, include this information. Ideal candidates should be quick learners, possess excellent communication skills, and have a knack for bringing creative ideas to life in 3D. Looking fo...

...and local corporate, payroll, and other applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. • Provide detailed analyses and explanations of all transactions. • Prepare documentation for external auditors. • Implement and maintain internal financial controls and procedures. Requirements: • Bachelor’s degree in Accounting, Finance, or related field. • Certified Public Accountant (CPA) or similar certification preferred. • Minimum of 5 years of accounting experience, particularly in a corporate setting. • Strong understanding of GAAP and financial reporting. • Proficient in accounti...

I need the header on my WordPress site to be adjusted in its mobile version. The full header requires resizing. Key Responsibilities: - Resize the full header in the mobile version Ideal Skills and Experience: - Proficiency in WordPress development - Experience with responsive design, especial...requires resizing. Key Responsibilities: - Resize the full header in the mobile version Ideal Skills and Experience: - Proficiency in WordPress development - Experience with responsive design, especially mobile optimization - Strong understanding of CSS and possibly JavaScript for more complex adjustments In your application, please provide a detailed proposal on how you plan to approach and execute this task. Past work examples of similar mobile optimization projects will be highly c...

...and I want them to be seamlessly placed on a beach setting. Key Requirements: - Background Replacement: The current background needs to be removed and replaced with a beach background. The focus is on making the transition appear natural and professional. - No Specific Effects: I don't require any specific effects to be applied to the photo. The primary task is the background replacement. - Output: The final edited photo should be saved in JPEG format. Ideal Freelancer: - Experience in Photo Editing: Previous experience in photo editing, particularly in background replacement, is essential for this task. - Attention to Detail: The quality of the final photo is crucial, so an eye for detail is important. - Time Management: The project deadline is relatively flexible, b...

I'm in need of a talented graphic designer who can create a design for our personalized beer glasses. Framework: - Output file as Vector file. - only two colors: The white design on a brown background - No need to place it on the beer glass; just show us the design - Design size: 3-inch wide x 3,5 inch tall. It can be oval, rectangle or something in between - Must include the text " Alexander's Beer Glass" - This is not a Logo design; do NOT send me designs on business cards!!! Let me know if you have any questions. Thank you for your participation.

I'm looking for a functional implementation utilizing AWS media convert in a .NET core environment, with a specific focus on video transcoding. - Functionalities: The main functionality to be implemented is video transcoding with the target being MP4 format. - Desired Output: The desired output resolution for the transcoded videos should be 1080p. Ideal Skills and Experience: - Significant experience with AWS Media Convert - Proficient in .NET core programming - Experience with video transcoding technologies - Understanding of video formats, particularly MP4, and resolution settings.

I am in search of a graphic designer skilled in photo retouching and color correction. The project involves editing images for a product catalog. Key Tasks: - Apply skilled photo retouching techniques - Execute color correction to enhance product appearance The ideal freelancer for this project would have: - A proven track record in high-quality image editing - Strong skills in photo retouching and color correction - Experience in creating images for product catalogs. Please provide samples of your previous work, particularly in product image editing. This will greatly aid my decision in selecting the right candidate for the job.

1) Integrate Xproxy Server into the prebuilt web dashboard as discussed. 2) Admin N Customer dashboard 3) Load demo $ in the customer account and he buys the proxy Proxy gets assigned to the customer from the server with details like http, socks and user pass , and option to change auth from user?ass to IP auth With API button, he can change the user?ass from his dashboard.