Complex stored procedure sql server 2008 example 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ä.

Eminent Minds Technologies Pvt Ltd,( ISO 9001-2008 Certified Company)

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

...the two materials. - Providing insights and recommendations on the preferred material based on the analysis conducted. Ideal skills and experience for this project include: - Proficiency in COMSOL MULTIPHYSICS software. - Strong background in heat transfer analysis. - Experience with vehicle brake systems and materials, especially cast iron and carbon ceramic. - Ability to interpret and present complex data in a clear and concise manner. - Understanding of vehicle dynamics and the impact of brake disk materials on performance. This project would suit a freelancer with a strong engineering background, particularly in the area of heat transfer and materials science. The ideal candidate should be able to deliver a thorough and insightful analysis that informs the decision-making p...

...-Knowledge of Agile and Scrum. -Fluent in English. -Nice to have: Google Cloud, CI/CD, Kubernetes, and Docker. -Nice to have: experience in building payment solutions. -Nice to have: experience in the medical business. Duties of the role -Architect, discuss, design, implement systems within the Scratch ecosystem. From simple (but important) sign-up forms to complex back-offices to end-user facing forms to multi-service signal-based event integration. -Help Scratch develop its test infrastructure and write tests to improve application test coverage. -Participate in all technical and product discussions together with the team. -Work with high quality and business sustainability in mind. -Developing front end ...

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!

I'm currently seeking a skilled developer to create an e-commerce platform, named "yuk pencet", tailor...Requirements: - Develop an intuitive, sleek e-commerce platform that aligns with the preferences of the specified age group - Implement the product customization feature in a user-friendly way, ensuring it's engaging and easy to use Ideal Skills and Experience: - Proficient in e-commerce platform development - Prior experience in creating platforms for young adult audiences - Expertise in integrating complex customization features - Strong UI/UX design skills - Knowledge of best practices for e-commerce SEO This project involves creating a unique and engaging platform, so I'm looking for someone with a creative mindset and the ability to think from the ...

I am seeking an experienced programmer to recode a C++ webview2 sample program to use win32 calls compatible with a Microfocus Visual COBOL environment. This transformation involves a focus on maintaining critical user interface functions presently coded within the C++ webvie...transformation involves a focus on maintaining critical user interface functions presently coded within the C++ webview2 sample. Key aspects of the project: - Conversion to Microfocus Visual COBOL - Prioritization and preservation of User Interface functionality Ideal skills and experience: - Proficiency in C++ and Microfocus Visual COBOL - Experience with understanding, adapting, and recoding complex coding samples - Familiarity with using win32 calls - A strong background in UI integration and function ...

...looking for a backend developer who has proficient skills in MongoDB, , React.js and Node.js, colloquially known as the MERN stack. Key Requirements: - Substantial experience using the MERN stack for backend development. - Proven record of delivering robust, error-free applications using these technologies. - Comfortable with managing data structures and developing algorithms for complex data manipulation. - Intermediate skill level is preferable as you should have a solid understanding of backend development principles without being overqualified. In your application, please detail your background and experience working on similar projects. This involves explaining your past work and presenting any particular challenges you had to overcome. Each accomplishment and hurdle met

I am in need of a comprehensive business plan tailored to secure funding for my wholesale business venture. The project specifically requires a focus on the wholesale of scrap metal, minerals and ores on an internationa...Freelancer: - Experienced in creating business plans, with a proven track record of successfully securing funding for clients. - A deep understanding of the wholesale industry, particularly in the specified fields of scrap metal, minerals and ores. - Proficient in market research and analysis, with a particular focus on the global marketplace. - Strong financial acumen and the ability to translate complex financial data into easily digestible information for potential investors. - Excellent communication skills to ensure the business plan is clear, compelling and p...

I'm seeking a talented copywriter with experience in translating complex medical concepts into Turkish for my pain management clinic's website. Key Requirements: - Specialization: The copywriter should have extensive experience in medical copywriting, preferably in the area of joint pain management. - Patient Testimonials: The website should include real patient testimonials, so the copywriter should be skilled in incorporating these into the overall content. - Language Level: The content should be highly technical to cater to medical professionals, ensuring a precise and accurate representation of our clinic and services. Your role will be crucial in helping us connect with our Turkish-speaking audience. A deep understanding of pain management and medical terminology i...

We have a project which needs an expert who is experienced with either Haraka or Postal. The project requires understanding, building and managing SMTP infrastructure on a deep technical/engineering level. To simplify the project it revolves around receiving email, modifying some of the headers and then sending it on for delivery. We expect there to be some development involved to achieve the final desired outcome. The full details will be explained in further discussions. We will need the installation and testing of the solution and ongoing support and consulting after implementation. Please note, we are specifically looking for a technical expert in handling Haraka/Postal/SMTP. This is NOT a project focused on email delivery as it is applied to marketing type emails and reputation man...

I'm seeking a seasoned SEO specialist to perform a comprehensive audit of my website with a focus on improving rankings on Google. Key Requirements: - Audit: Review the current state of my website from an SEO ...I aim to rank for. Ideal Skills and Experience: - Proven track record in SEO, particularly with enhancing Google search rankings. - Strong analytical skills to assess the current website's SEO performance. - Excellent understanding of keyword research and optimization techniques. - Ability to provide clear and strategic recommendations for improvements. - Good communication skills to explain complex SEO concepts in understandable terms. This project would suit someone who is up-to-date with the latest SEO trends and can deliver tangible results. Looking forwar...

...specialist in server maintenance and troubleshooting, particularly for my Dedicated Linux Server Level 2 Strato. The key tasks required are: - Recovery: I need help with server recovery, the ability to troubleshoot and restore the server in case of failure. - Update: Keeping the server software up-to-date is crucial for security and compatibility. I need a specialist to handle the server updates effectively. Ideal skills for this job include: - Strong expertise in Linux server administration and management. - Proven experience with server recovery procedures. - Proficiency in updating server software without causing disruptions. - Strato dedicated server recovery - Operating system Ubuntu 16.04 LTS 64bit + Plesk On...

...experienced PHP backend developer who can assist me with urgent server configuration and API integration tasks. Specifically, I would require the following: - Server Configuration: I need someone who is well-versed in server setup and configuration, ensuring a smooth and efficient back-end infrastructure. The ideal candidate should be able to ensure optimal performance and security. - API Integration: There is a need for the integration of an 'informative application' API. This task requires someone with prior experience in integrating custom APIs and a strong understanding of how to effectively connect APIs for seamless functionality. Ideal Skills and Experience: - Proficient in PHP for backend development. - Strong background in server configur...

...a highly complex 3D model, inclusive of intricate mechanical motion studies. Key Aspects of the Project: - 3D modeling: The designer's primary responsibility is to create a 3D model. This will not be a basic rendering, but a complex structural design featuring intricate mechanical motion studies. - Detail Oriented: The project necessitates a high degree of granularity. You will be expected to engage extensively with components and their specifics. - Manufacturing Process: The 3D model must be prepared with the manufacturing process in mind. It will be utilized directly in the production line, hence, the design should be functional and representative of the final, tangible product. Ideal Skills and Experience: - Expertise in SolidWorks software, particularly in deve...

I'm in need of a skilled English to Turkish translator who can help me with proofreading short, moderately complex sentences for a mobile app. Key Requirements: - Experience in translating to Turkish - Attention to detail; proofreading skills - Understanding of general audience's language level The project's goal is to ensure the content is accurately translated and retains its informational value for a general Turkish-speaking audience. Skills and Experience: - Proven experience in translation and proofreading - Familiarity with mobile app content is a plus - Strong understanding of the Turkish language and its nuances - Ability to keep the content accessible and engaging for the general public. Looking forward to your bids.

I'm in need of a developer proficient in Python who can create a video tutorial. The tutorial should showcase the process of building a user authentication login page for a web application using the Microsoft Graph API. The loging should just allow pre-regi...around this language. - Familiarity with Microsoft Graph API: The ability to leverage the Microsoft Graph API for user authentication is essential. - Video Creation: While I'm not looking for a professional video maker, the candidate should be able to record, edit, and produce a clear and engaging tutorial. The ideal candidate should possess a developer’s eye for detail and the ability to explain complex technical processes in a clear and understandable manner. Experience with educational or tutorial content c...

Hello, I need some minor editing of a brochure. I'm thinking maybe this could take 30 mins work. Are you availaible? I have a Word document that I plan to print on PDF and send as part of a brochure to possible clients. What I need is final touches, alligning all images, and maybe ideas on adding a background and theme (Nothing complex, I want it to be as simple as possible). Thank you.

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 Quick...the tasks 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 Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress 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...

"I am actively seeking a designer who possesses a profound understanding of branding. Proficiency in Maya, Adobe Suite, 3D Studio Max, and general image editing skills are prerequisites for this role. The brand in question is already well-established; however, it requires a sophisticated refinement while maintaining its appeal. Specifically, this project involves the design of a spirit label. If you lack the aforementioned skills, I kindly request that you refrain from applying or if you are trying to give the work to someone else. When I'm available online, I can provide further clarification. Please understand and NDA will be required to sign.

I am looking for an expert who can help me set up a SIP trunk server using Twilio as the SIP provider. This server will be used for both voice calling and SMS messaging. Key Responsibilities: - Establishing a SIP trunk server with configurations optimized for Twilio - Implementing call management features like Call Recording, Call Forwarding, and Interactive Voice Response (IVR) - Ensuring seamless integration of both voice and SMS capabilities - Providing recommendations for server security and performance optimization Ideal Candidate: - Extensive experience with SIP trunking, particularly with Twilio - Proficiency in configuring and customizing SIP trunk servers - Proven track record in implementing call management features such as Call Recording, Call Forw...

I'm looking to create a top-notch e-commerce website that can handle transactions across multiple payment gateways and cater to a global audience. This site should be well-integrated with multiple payment options including ...integrating multiple payment gateways. - Global Audience: The site should be designed to handle transactions in multiple currencies and be adapted to different countries' tax codes and regulations. - User Experience: A user-friendly and visually appealing design is a must, ensuring a smooth navigation experience for consumers from various regions. If you have a proven track record in creating complex e-commerce sites that cater to international markets, and are proficient in integrating various payment gateways, I would be interested in discussing th...

I'm in need of a CAD designer to create a simplistic, yet detailed wall-mounted direction sign. The design should be accompanied by the following: - Multi Colour: My vision for this sign is to incorporate a variety of colours to enhance visibility and aesthetic appeal. I don't require a design that's overly complex or detailed. It's important to strike a balance between simplicity and the necessary level of detail. This project is ideal for someone with expertise in creating clear and concise CAD designs. It's important to note that while the project is relatively straightforward, attention to detail and understanding of how to make the sign visually appealing and easy to read will be crucial to its success.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I'm seeking an individual with excellent typing skills to convert a text-only PDF file into a Word document. The content is not complex; it consists of plain text without images or tables. Key Requirements: - Complete the task within 3-5 days - Ensure the content is accurately typed - Deliver the Word document in a standard text format Ideal skills: - Proficient in typing and data entry - Familiar with Word processing software - Attention to detail in maintaining accuracy - Ability to meet deadlines

I'm in need of an expert who can help me with the following tasks on my existing server: - **Server Configuration:** Fine-tuning and optimizing my server settings to ensure it's running at its best. - **DNS Management:** Managing and configuring my domain's DNS settings to ensure proper functionality. - **Email Setup:** Setting up email services on the server for my domain. I will provide you with root access to the server, so you should be well-versed in security practices and able to handle the responsibilities that come with that level of access. Ideal candidates should have: - Extensive experience in managing Cpanel and WHM - Strong knowledge of DNS configuration and management - Proficiency in setting up email services - The abil...

I'm looking for a skilled animator who can create a 2 in 1 video for the launch of a news analytics platform. The video will serve as both a countdown to the platform's unveiling and a narration of its key features. The target audience for this video is primarily business professionals. Key Points: - The video's style should be an animated explainer. This will help convey complex information in a visually engaging and easy-to-understand manner. - The tone of the narration should be conversational and engaging. It's crucial that the video captures the attention of the audience and keeps them interested throughout. Ideal Skills and Experience: - Proven experience in creating animated explainer videos, particularly for B2B audiences. - Ability to craft engaging an...

...Interface for Clients: • Provide a page where users can enter their tracking number and view the current status of their submission. 5. Admin Dashboard for Managing Data Statuses: • Enable administrators to log in, view submissions, update their statuses, and manage payments. 6. WhatsApp Integration: • Provide customer support through WhatsApp. • Automate responses to common inquiries and escalate complex issues to human support. Complimentary Services 1. Maintenance Service: • Offer a maintenance service for three months post-launch. • Address any bugs or errors promptly and ensure smooth operation without additional costs to the client. Project Plan Phase 1: Design (2-3 weeks) • Create wireframes and mockups for all pages. • Finalize des...

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine

...client, developers and designer to complete website projects. Key responsibilities include: - Managing the design and development process, ensuring the website meets our needs. - Provide website content that is aligned with SEO best practices - Basic understanding of website development - Ability to work on simple website projects (WP) and complex website projects (Portals) - Understand domain DNS configurations, Email configurations, and server configurations. The ideal candidate will have: - Proficiency in Arabic and English, with an ability to translate content effectively. - Experience managing website projects, particularly those with high customization requirements. - Strong communication skills to liaise between our team and the developers. - A strong attent...

I'm seeking a skilled programmer with experience in Moodle and JavaScript to develop a simple yet crucial feature for our Moodle p...its architecture, including the ability to create Javascript for Moodle. - Familiarity with API integrations, preferably ChatGPT or similar. - Strong communication skills to ensure seamless collaboration and understanding of the deliverables. - Attention to detail and ability to ensure data security within the Moodle platform. It's essential that the final product allows the audio files to be stored within Moodle after transcription. This feature should be user-friendly, efficient, and secure. If you're a programmer with these skills and experience, I'll be happy to discuss further details and work closely with you to bring this p...

I need an experienced Wordpress developer to create a custom online form on my website using WPForms. The form should save all submitted data to a database. Here are the specifics: - **...should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents from form data - Capability in working with complex form...

...skilled developer to implement DTLS in C for secure communication within a tight deadline of two weeks. Key project requirements: - Implement DTLS in C: The primary goal of this project is to introduce DTLS to an existing system for secure communication. - Tight deadline: This project needs to be completed within two weeks. Timeliness and reliability are crucial. I need the data coming from the server to the client over UDP socket to be encrypted with DTLS, and it should appear as DTLS in the protocol section of Wireshark. In addition, the code should be able to handle streaming video or live feed over the socket accordingly. This code should work in linux and windows. Ideal Skills and Experience: - Proficiency in C: Extensive experience with C language is a must. - DTLS Kno...

...in PowerPoint format. This content rich profile will contain detailed information such as our company's history, mission and vision, and the products and services we offer. Given that the target audience is our potential customers, skills in marketing and great understanding of customer demographics will be highly regarded. Proficiency in PowerPoint is a must along with the ability to convey complex information in an easy-to-understand manner. A background in corporate storytelling or alike will be a significant plus. Ideal skills include: - Expertise in PowerPoint - Brilliant storytelling abilities - Understanding of customer demographics - Background in Marketing or related field. Your goal will be to present our company in the best light possible, helping us to att...

I'm looking for a skilled developer to integrate a Dental CRM software and Voiceflow. Here's what I need: - Integration with Dental CRM: I want the patient data in the CRM to be synchronized with the chatbot we're building. - Integration with Voiceflow (chatbot builder): This part is slightly more complex. I need an integration that allows for booking and managing appointments, authorisation, as well as the ability to retrieve or create patient profiles. The goal is to build a chatbot that visitors to the website can interact with to book, reschedule, or cancel appointments. Automated messages to confirm changes will also be needed either through SMS or email. Ideal candidates will have experience in API integration, especially with CRM and chatbot builders like...

I am in need of a proficient developer to create a platform that garners reviews from both mobile applications and websites. The core function of this software development project will be: - Collecting both user-submitted text and star ratings - Presenting these collected reviews on Google maps Ideal Skills and Experiences: - Experience in web and mobile application ...reviews on Google maps Ideal Skills and Experiences: - Experience in web and mobile application development - Familiarity with Google map APIs is susceptible - Strong grasp in designing intuitive, user-friendly interfaces - Previous experience in developing review or survey related tools This project is multi-faceted and has an influence over a wide audience, therefore the ability to deal with complex projects is ...

...in need of a skilled technical writer to create a comprehensive user manual. The target audience is "end-users" with an advanced level of technical knowledge and experience. Key Responsibilities: - Develop user-friendly content that meets the needs of the target audience. - Explain complex information in a clear and concise manner. -Diagrams related to logic gates/tables/timing to be drawn Skills and Proficiencies: - Proven technical writing experience in producing user manuals. - Ability to take complex, technical information and translate it for colleagues and consumers who have non-technical backgrounds. - Excellent attention to detail and ability to adhere to style guidelines. - Strong working knowledge and understanding of the technology behind the prod...

I'm in need of a skilled copywriter who can help me create qualitative content for the healthcare sector. This project is specifically geared towards educating the audience about a product/service. Ideal expertise would include: - Exceptional copywriting skills - Prior experience in Healthcare related copywriting - Skill in converting complex concepts into simple, layman's terms. The top objective is to educate the audience about a product/service effectively. Therefore, ability to create compelling, engaging, and user-friendly content is paramount for this task.

I'm a beginner in programming and am working on a personal project involving AI chatbots. I'm looking for a tutor to help me learn how to create them for a website. Key asp...to create them for a website. Key aspects of the project include: - Teaching me the foundational principles of AI chatbot design - Guiding me through the creation of a basic, functional AI chatbot for a website - Explaining how to integrate and maintain the chatbot on a website. I'm expecting the tutoring to be interactive and highly informative, you should be patient and good at explaining complex concepts in a simple manner. Experience in AI chatbot development, specifically for websites, is highly preferred. A solid understanding of programming concepts is also necessary, along with the abi...

I urgently require a proficient SQL Server expert, particularly conversant with SQL Server 2012. My primary challenge is recovering deleted records. Ideal Skills: - Comprehensive understanding of SQL Server 2012 - Expertise in data recovery processes Experience Required: - Proven track record in database recovery - Past work with SQL Server 2012 Your immediate availability for this project is essential. Please, only serious and experienced candidates should bid.