Mastering sql queries for sap business one 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
Quibhvuvguugcuctfutfuttvuyviyivvyiiyvvyiyivivyyviyviivy
Minulla on jatkuvaa työtä, joka liittyy aikaisempaan projektiimme 'Business card design'
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
I am looking for a skilled professional with experience in AI and CRM systems to create a bot for my Kommo CRM. Key Features: - The bot should primarily function to answer frequently asked questions from clients. - It should be equipped with Natural Language Processing capabilities to understand and respond to messages in a human-like manner. - The bot needs to be knowledgeable about the product details of my business to provide accurate information to clients. - It should be able to respond instantly to client messages, ensuring no delay in communication. - The bot should also have the capacity to move clients between different sales funnels based on their interactions. Ideal Skills and Experience: - Proven experience in developing AI bots for CRM systems, p...
I have a PDF file that contains a business report, which includes data and statistics. I need a freelancer to accurately type the contents of the PDF into a new document, including the narrative summaries that present the data and statistics. Ideal Skills and Experience: - Proficient in typing and data entry - Able to understand and transcribe narrative summaries accurately - Experience working with business reports - Attention to detail and high level of accuracy
I'm seeking a skilled developer to create a user-friendly iOS app for small business owners. The app should effectively track financial transactions and manage inventory records. It should be simple yet powerful enough to cater to the needs of a small business owner. Key Features: - Recording of financial transactions - Inventory management - Intuitive interface for easy navigation - iOS platform compatibility Ideal Skills: - Proficient in iOS app development - Experience in creating accounting or inventory apps - Strong understanding of small business needs - Ability to design user-friendly interfaces Please bid if you have the relevant experience and can deliver a high-quality, functional app.
I'm seeking a skilled Windows application developer to create a User Interface Tool compatible with Windows 11. The application will need to integrate with SQL Server. Key Requirements: - Experience in developing Windows applications, specifically for Windows 11. - Proficient in creating User Interface Tools - Strong skills in SQL Server integration. - Ability to deliver a user-friendly interface. Please include examples of your previous work with Windows applications and SQL Server in your bid.
I need the attached logo for my business in a high resolution format. Currently all I have is a simple png. The logo should incorporate the same color scheme, shapes/symbols, and typography/fonts as the original design. This project will be ideal for a designer who has a strong understanding of brand consistency and can effectively translate an existing design into a polished logo.
As the owner of a motorcycle customization business based in Texas, I'm seeking an experienced Social Media Manager. Your role will encompass managing my Facebook, YouTube, Instagram, and Pinterest accounts. Key Responsibilities: - Improve Searchability: Utilize SEO strategies to enhance the visibility of my brand across social media platforms. - Create and Edit Content: Develop engaging content that resonates with motorcycle enthusiasts. This includes creating and editing photos. - Enhance Visual Aesthetics: Ensure my social media profiles are visually appealing and consistent with my brand's image. Ideal Skills and Experience: - Proven experience in social media management, preferably for a niche market. - Strong photo editing skills and experience with content ...
I'm seeking a creative and minimalistic design for NFC integrated business cards. The design should be: - Unique and professional: Moving away from conventional 'Tap here' prompts to a more creative approach. - Use of our branding: The design should incorporate our logo and branding colours in a professional way. Ideal skills for this job include graphic design, development of creative concept, and a knack for minimalist design aesthetics. Experience in creating professional business cards will be highly regarded. For your reference: Insta: @akersoflawn FB: /Akersoflawn
I need a one-page website designed for a Singles Run Club. As a web designer, I have all the necessary elements such as colors, styles, pictures, logos, and text. I just need someone to piece it all together in a fun, interactive, and functional way. Key Requirements: - Mobile-first design: The site should be optimized for mobile devices first and foremost. - WordPress: The site needs to be built on this platform. - Interactive Elements: A sign-up form needs to be integrated into the page. Ideal Skills: - Proficiency in WordPress - Experience in creating mobile-first, interactive websites - Ability to follow a specified design brief closely I need this project turned around quickly, so please only apply if you can deliver in a timely manner.
...standalone hardware without internet connectivity and support a cloud architecture for at least 1000 concurrent users. The architecture must address Big Data's Velocity, Volume, Value, Variety, and Veracity while ensuring security compliance. (a) Model will be trained on large amount of variety of data such as documents, handwritten text, excel sheets, power point PPTs, word documents, BRs, equipment manuals, IR images, reports, letters, faxes, flow diagrams, charts, block diagrams, videos, training books, medical reports (all variants of medical reports, data and scanned copies). (b) The format of documents, manuals, reports, letters, faxes will not be restricted to readable PDF format and the solution should cater for all possible formats. Accordingly, solution ...
I'm seeking a skilled graphic designer to create a flier for my business. The primary goal of the flier is to inform potential customers about my business, so it should clearly present relevant information in an engaging manner. Key Requirements: - The flier must include my business's contact information and location. - The design should be visually appealing and professional. Please note that the tone or style of the flier has not been specified, so a modern, sleek design would be ideal. The ideal freelancer for this project should have a strong portfolio of similar work, excellent graphic design skills, and the ability to deliver a high-quality product in a timely manner.
I'm looking for a freelancer who can create a professional, business-oriented website using Builderall. - The main focus of the site will be promoting our products and services, so experience in e-commerce and product showcase design is highly desirable. - A comprehensive product catalog is a key feature of the site, so skills in catalog design and implementation are crucial. Please include examples of relevant previous projects in your bid.
I need a simple mobile application developed for both Play Store and Apple Store. The main purpose of the app is to serve as a database and a form processing tool. Key Features: - Social Networking Elements: The app should include messaging capabilities and allow for profile creation. - SQL Database Integration: The app should utilize an SQL database. Ideal Skills: - Proficient in mobile app development for Android and iOS. - Previous experience incorporating social networking features into apps. - Strong understanding and experience with SQL databases. My goal is a seamless, user-friendly app that captures essential data and facilitates communication between users.
...Model (LLM)-powered Assistant for messaging and integrating intelligent machine learning solutions to improve user experience. This is a project-based role with a budget of $1,800. Scope of Work: Core AI Features to Develop: AI-Powered Recommendations: Job and gig suggestions tailored to user profiles and activity. Upskilling and learning pathway recommendations. Automated CV and Cover Letter Writing: Role-specific document creation with AI-driven formatting and tone adjustments. Predictive Analytics: Insights into job market trends, hiring efficiency, and skill gap analysis. Sentiment Analysis: Analyze user interactions for tone and sentiment to improve platform engagement. LLM-Powered Messaging Assistant: Create a conversational AI assistant to handle queries, ...
I'm seeking a tax advisor with experience in photography business structures. I operate as a Corporation and my main income source is from stock photography sales. Key areas of focus: - General tax advice tailored to my situation - Recommendations on optimal business structuring for better tax efficiency and growth potential Ideal candidate: - Extensive knowledge of tax regulations - Familiarity with the photography industry - Proven experience advising Corporations - Excellent understanding of stock photography sales - Strong strategic planning skills for business structuring
I'm seeking a .NET Core Developer with DevOps skills to create a small e-commerce website. This project involves: - Utilizing ASP.NET Core and nopCommerce for the shopping cart functionality. - Integrating with Bluestar Inc through a third-party API. - Setting up a clear SQL Server database schema for product, order, and customer data. Key functionalities of the site include order tracking and history. User authentication and advanced product search and filtering are not required. We have branding assets (logo, color palette) and need you to implement them into a simple, clean UI. We do not have Sketch files/wireframes. We would like code in a Git repository with an automated build and deployment process. Familiarity with GitHub Actions or Azure DevOps is a ...
I'm looking for an expert who can customize Business Central for my business needs. Key Areas: - Invoice and Billing: I need a general enhancement on this system to improve its efficiency and usability. - Inventory Management: Customization in this area is also required to better suit my business operations. Ideal Skills and Experience: - Extensive experience with Business Central - Proficiency in customizing invoice and billing systems - Expertise in inventory management customization - Strong understanding of general system enhancement
I'm seeking an academic professional who can assist me with a project in Business Management. The task involves manually reviewing three previous studies (all in Word Document format) and extracting concept items related to 'Measurement' which are highlighted in red. These items need to be filled into a specified template, with any missing boxes also needing to be completed. Key Requirements: - Strong understanding of Business Management concepts - Proficient in manual research - Excellent attention to detail - Familiar with Word Document - Able to work independently to complete the task Please note, the use of artificial intelligence or automated tools is not permitted for this task. The ideal candidate is someone who can provide thorough and meticul...
I'm looking for an experienced SAP ABAP developer with a strong understanding of workflow design, specifically to streamline our AP invoice approval processes. Key Requirements: - Expertise in SAP ABAP programming, particularly in workflow development. - Proven experience in enhancing invoice approval tracking systems. - Ability to implement effective notification systems for due dates. The primary objective of this project is to improve efficiency and reduce delays in our AP invoice approvals. The ideal candidate will be skilled in creating and optimising workflows to meet these goals.
Job Description: We are seeking a skilled freelancer to enhance and optimize our current spreadsheet system for tracking class data. Our goal is to make the system more insightful, visually engaging, and actionable for our business planning. Current Setup: We use spreadsheets to track class data, including the category of the class, the instructor, and the location. Each year has its own dedicated sheet. A summary sheet aggregates data from the yearly sheets, providing total counts for the year. Scope of Work: We’d like to expand the capabilities of this system by introducing new graphs, charts, and insights, including: Graphs and Charts: A graph showing the number of classes taught at each location, broken down by year and month. A chart summarizing how...
I'm seeking a seasoned developer proficient in Node and React js, to create an internal business tool. The tool will primarily be used by our employees and should incorporate the following key functionalities: - Data Analytics Dashboard: The tool should have a comprehensive dashboard that can display various data metrics and analytics in a user-friendly format. - User Management System: This will allow for easy tracking and management of users within the tool. Ideal candidates for this project should have a strong background in full-stack development, particularly with Node and React, and experience in creating interactive and efficient internal business tools. A knack for data visualization and understanding of user management systems will be a s...
I'm in need of a skilled content writer to help create engaging and inspiring content for my business catalog. This catalog's primary purpose is to introduce my company to potential customers. Key requirements: - Exceptional writing skills with a knack for creating visionary and inspirational content - Ability to articulate our company's mission, vision, and values in a compelling way - Experience in writing for business catalogs or similar materials - Understanding of how to write for a target audience, in this case, potential customers - Ability to translate complex business concepts into relatable and easy-to-understand language - A keen eye for detail to ensure all content is polished and professional
I'm looking for a logo for my business that incorporates both text and an icon. The specific elements of the icon are not yet determined, so I would appreciate a designer who can provide creative input and ideas. The business name is Th3 Covering. I would like the “I” in covering to be a microphone like this “cover?ng” but I am open to all ideas. I would also like there to be a spiritual/ Godly element to this logo. Ideal Skills: - Proficiency in graphic design software - Strong portfolio of logo designs - Ability to create unique and appealing text and icon combinations - Excellent communication skills for collaborative input Experience in modern, classic or abstract design styles would be beneficial, as I have not yet dec...
I'm seeking a ...seeking a proficient Bubble developer to support the development of an MVP for a professional social network platform tailored for a specific niche. This platform will primarily feature: MVP: - Candidate User Profiles: Mandatory to have an import from Linkedin functionality, to which other industry-specific information would be captured - Messaging System - Company Profile: Each company will have the ability create their profile - Bidding system by which candidates make themselves available for a new position, and companies start bidding for them. Further functionalities will consist of job posts, social feed, etc, but these are out of scope for the MVP. Moreover, i would also consider a Front-end only as an initial MVP for...
...Soluciones automatizadas: Recomendaciones generadas por IA para resolver problemas detectados en la auditoría. Reportes descargables con explicaciones claras para desarrolladores y propietarios de sitios web. 6. SEO Local y Rankings Personalizados Análisis de SEO local: Auditoría de consistencia de datos en directorios locales (nombre, dirección y teléfono). Optimización de perfiles de Google My Business. Mapas de calor interactivos: Visualización del rendimiento en rankings locales por códigos postales o regiones. Palabras clave locales: Seguimiento de palabras clave segmentadas por ubicación geográfica. 7. Visualización y Reportes Automatizados Gráficas y dashboards interactivos: Vi...
I'm seeking a skilled social media marketer with a proven track record in driving sales for an Instagram and TikTok-focused campaign for my UK-based jewelry business. Objectives: - Drive sales through engaging social media content. - Boost sales through effective social media strategies. Ideal Skills: - Expertise in Instagram and TikTok marketing. - Strong content creation skills, particularly in product showcases. - Proven experience in generating leads or sales through social media.
I'm looking to have a bootstrap static website created that contains business information. The site should be a full replica of seaquaticaquariums.com. The WP section for header and footer have issues currently. The wp source file can be provided or wayback can be used to match. The design should closely mirror seaquaticaquariums.com. Ideal skills for the job include: - Proficiency in HTML/CSS - Bootstrap framework experience - Web design with a keen eye for detail - Ability to create responsive, mobile-friendly websites - Experience in replicating and modifying existing web designs Please provide examples of similar projects you've completed in your proposal.
...experience. Smoothly and create a more modern, intuitive UX: Thank you for looking over the job details. Listed below is an overview of the project. Most of this can be obtain through the power of Stripe 1. Streamlining Customer Information Collection The goal here is to make the onboarding process as seamless as possible while ensuring compliance and security. Steps: Stripe Identity Verification: Use Stripe Identity to verify user identity quickly and securely. It allows you to collect customer information like name, email, address, and government-issued IDs, ensuring you're compliant with KYC (Know Your Customer) regulations. Dynamic Form Design: Break down the data collection into a multi-step, intuitive form. For example: Step 1: Basic Information (Name, email,...
I'm looking for an experienced professional who can convert my existing PowerBI dashboard into a Grafana dashboard. This new dashboard will need to be embedded in a React.js application. Key Aspects of the Project: - The primary purpose of this dashboard is real-time monitoring. It should be capable of tracking performance metrics live. - The dashboard will pull data from an SQL Database. You should have a solid understanding of SQL and experience working with SQL databases. - The conversion should focus on monitoring performance metrics. You will need to understand what these metrics are and how to visualize them effectively. Ideal Candidate: - Proficiency in Grafana and React.js. - Solid experience with PowerBI and SQL databases. - Skills in dat...
...functionalities include: WolframAlpha API Integration: The device will process and return results for advanced mathematical and scientific computations, including step-by-step solutions. Internet Connectivity: Incorporate a SIM card module for internet access to connect to online resources such as WolframAlpha, Wikipedia, and other APIs. Mode Switching: The device should operate in two modes: Basic Mode: Functions as a simple calculator with standard operations. Advanced Mode: Unlocked via a secret code, revealing a custom GUI to input queries and access hidden features. Custom Input System: The numeric keypad will allow dual functionality, with specific key combinations (e.g., pressing M+ and 7 together for "/") to input characters discreetly. Ste...
...medium business owners in the USA. Review their existing websites and identify potential anomalies, UI/UX issues, or missing features (e.g., chatbot, payment gateway, WhatsApp integration). Consultative Selling: Highlight gaps and opportunities in the client’s digital presence. Suggest appropriate services, including website development, redesigning, logo creation, and integration solutions. Lead Conversion: Arrange and conduct discovery calls with interested business owners. Finalize sales agreements by demonstrating the value of our services. Collaboration with Exponential Consultants: Collaborate with our technical team to address client queries or provide additional support during the sales process. Compensation & Benefits: Commission-Based: Earn...
My Facebook Verified business page has been inactive for over 2 years and now it shows a restriction preventing me from verifying my identity. I cannot submit a review or verify my identity. The ideal candidate for this project should have: - Extensive experience dealing with Facebook's business page issues. - Proven track record of resolving identity verification problems. - Deep understanding of Facebook's guidelines to ensure future compliance.
...comprehensive business plan for a UPS franchise. The primary purposes of the plan are to secure funding and set a clear business strategy. Key Sections: - Executive Summary: A concise overview of the business and its objectives. - Market Analysis: In-depth understanding of the UPS franchise market, its potential, and its challenges. - Financial Projections: Detailed forecasts that demonstrate the viability and profitability of the franchise. - Operations & Organization: Insights into the location, required employees, and operational strategies. The plan should place particular emphasis on our growth strategies, outlining how we intend to scale the business and capture market share. Ideal candidates will have: - Proven experience in business...
I'm in need of a freelancer with experience in managing and reviewing Google My Business profiles. The task involves bidding for 100 genuine positive reviews. All reviews must be niche-targeted and unique. Ideal Skills: - Proficiency in digital marketing - Experience in managing Google My Business profiles - Ability to generate unique and niche-targeted content Project Requirements: - Bid for 100 genuine positive reviews - All reviews should be niche-targeted and unique - Review lengths should be long (6+ sentences) Tell me howmany days you need for 100 reviews.