Sql add field existing table 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
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)
Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)
I'm in need of a skilled electronics engineer with experience in creating GPS devices to design and prototype an athlete tracking device, initially targeting soccer players. Key Features: - Real-time Location Tracking: The device should provide accurate real-time location data for athletes on the field. - Distance Covered: Tracking the total distance covered by the athlete during a game or training session. - Speed Metrics: Monitoring the speed at which the athlete is moving during different phases of the game. - Acceleration and Decelerations: Recording sudden changes in speed to analyze the player's agility and response times. - Heart Rate Monitoring: Capturing the athlete's heart rate to gauge their exertion levels during play. Ideal Battery Life: - The desired b...
As a passionate retailer, I am looking for a talented fashion designer who can help me conceptualize and create a line of women's casual wear. The clothes should reflect a relaxed, easygoing, and comfortable aesthetic using neutral and earthy tones to embody the spirit of nature and groundedness. Ideal Skills: - Experience in women's wear...should reflect a relaxed, easygoing, and comfortable aesthetic using neutral and earthy tones to embody the spirit of nature and groundedness. Ideal Skills: - Experience in women's wear design - Understanding of fashion trends - Skill in creating designs with neutral and earthy color schemes Overall, I am looking to partner with someone who understands my vision, can bring fresh ideas to the table, and help me bring this uni...
I'm looking for someone who can create an Entity-Relationship (ER) diagram and possibly a related dataflow diagram for my different business systems. This diagram should map out the relationships between these systems and highlight data flow, perhaps in a dataflow diagram, but the flows are quite simple and may not justify a...placeholders for other details, like data types. The ideal candidate should have experience with ER diagram creation in a business context, and ideally experience in mapping user interaction and data flow. I have attached the description of the systems, relevant fields and data flow for you to map out. I need the output in a format that is editable so that I can replace system names, some of the field names with real system names/fields from the deploy...
I'm in need of a skilled developer to create a web application for influencers. This application will serve as a platform for influencers to offer their services to comp...commission-based marketing. It will also include a comprehensive customer relationship management system, data storage, and reporting functionalities. The application will also feature financial management capabilities, payment methods, and invoicing. The successful freelancer for this project should ideally have: - Proven experience in web application development, particularly in the influencer marketing field. - Strong knowledge of customer relationship management and data storage/reporting. - A solid understanding of finance management within software. - Proficiency in integrating payment gateways into we...
...can help me design a plan to automate my business analytics workflow and migrate the existing PowerBI setup to Tableau. Key Tasks: - Data Cleaning & Preprocessing: Streamlining the data cleaning process will be crucial to ensure accurate insights. - Data Integration & Transformation: Integration of data sources will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business ...
I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. Experience : 5+ years only
I'm looking for salesmen to help promote our range of esports coa...coaching programs, specifically focused on Pokémon, Fortnite, and Yu Gi-Oh! We also have some programs for League of Legends and simracing. Ideal candidates for this job should have: - Intermediate level of experience in the esports industry - Good understanding of the games being coached (Pokemon, ACC, Yu Gi-Oh!, League of Legends, Fortnite) - Strong sales experience, preferably in a related field - Excellent communication skills - An interest in gaming and esports Your primary tasks would include promoting and selling our coaching programs, engaging with potential customers, and driving sales. The goal is to increase the number of sign-ups to our programs. Experience in the gaming industry and sales ...
...seeking a freelancer with expertise in setting up Jira for project management and integrating it efficiently into our current workflow. Key Responsibilities: - Evaluate and recommend custom workflows if necessary - Implement best practices for efficient project management - Ensure seamless integration of Jira into our existing software - Setup Integration with Tempo and Xero - Help understand how we can track billable hours against actual logged hours and add this field Ideal Candidate: - Proven experience with Jira - Strong understanding of project management principles - Ability to tailor Jira's workflows to our needs - Excellent communication and problem-solving skills - Prior experience in software development projects is a plus Your advice on custom...
I need a professional and creative logo designer with animation skills to create a unique and engaging logo for my construction company, Narly Services. Key Requirements: - I operate in the construction industry, so the logo should reflect this field. - The logo must be animated. I want it to be dynamic and engaging, without being too overwhelming. - You should aim for a modern and innovative design, while still maintaining a professional look that is suitable for a construction company. Ideal Skills: - Logo design - Animation - Understanding of construction industry aesthetics. I'm excited to see your ideas for the Narly Services logo!
...looking for someone with a wide ranging talent within this field. As such, your tasks could span from designing components, conducting simulations, to creating technical drawings. You may be required to work on various types of systems and components, potentially including HVAC systems, robotics, or automotive components. Additionally, proficiency with tools and software is vital. The specifics may vary, but potential options include AutoCAD, SolidWorks, and ANSYS. Ideal skills and experience: - Broad knowledge in Mechanical Engineering tasks - Experience with diverse systems and components - Proficiency in AutoCAD, SolidWorks, ANSYS, or similar tools - Exceptional technical drawing ability If you are versatile and adaptable in the field of Mechanical Engineering, I en...
This project is to create a (Legal Zoom) type of website with various documents starting with privatization. Individual will set up fields for a project for consumer to fill out on a particular order and there will be an admin side for each State where certain field will be changed each election by admin pertaining to the docs of that state. The starting docs will be for the state of Michigan and we will expand from there. Other work TBD.
Project Description: I seek a skilled professional to develop a comprehensive methodology for classifying policies and measuring associated risks ...clear flowchart that determines which policies should be escalated to the Board versus those that should be handled by the Risk and Compliance departments. Preferred Formats: - The final deliverables can be in Microsoft Word or PowerPoint, or any other format that effectively presents the methodology. Project Requirements: - Proven experience in risk management, policy development, or a related field. - Excellent analytical and strategic thinking skills. - Ability to deliver clear, concise, and actionable tools for organizational use. Submission Details: - 24 hours to 36 hours #Please if you do not make this project in 36 hours max ...
I'm in need of a talented designer to help me create my wedding stationery items. I would like the designs to be modern and minimalist in style. We already have key design elements used in our save the date and invite, we just need help with pull-through in different deliverables. Key Requirements: - Design of Table Number Cards, Seating Overview, Menus, Name Cards, Welcome Sign (for welcome drinks and wedding), Weekend Itinerary, and Swag Bag Welcome Note, Napkins, - Modern and Minimalist Design Aesthetic using elements we already have designed Ideal Skillset: - Proficient in Graphic Design Software - Experience with Wedding Stationery Design - Strong Portfolio of Modern and Minimalist Design Styles Please submit your bid with links to relevant work samples.
...attending this will already have advanced knowledge of the topic. - Therefore, I need a freelancer who is deeply experienced in flood modelling, able to confidently present to experts in the field. - The successful candidate should be ready to prepare presentations, conduct interactive sessions, breakout groups, and Q&A sections. - As the facilitator, you should be able to guide analytical and technical discussions effectively and ensure the workshop runs smoothly. You should be able to provide clear demonstrations and examples, and handle challenging questions from participants who are familiar with the field. A background in environmental engineering, water resources management, or a similar discipline would be especially advantageous. Exceptional presentation ...
...improvement in some section - more detail can be discussed. Programming language is using Visual C++. Key points to develop: - change development logic of game bot single player (without using Bot Ticket) - change all the wording of broadcast (if any) from other language to english language - change some of item configuration that can boost exp/pang that's hardcoded in the code into some soft config table that can be administered by game admin. - Client-side app development : key points to develop: 1. Create a simple yet interactive Game Client Launcher that can check the latest update game file, start game and perform new player registration system. More detail can be discussed. 2. Gacha & Guild Management (Client-side app) : In-Game Built-in system already have Gacha ...
I'm at the prototype stage of my product and I need a skilled mechanical engineer to help me improve it. - Areas of expertise: Even though I didn't specify a particular area in mechanical engineering, a broad knowledge in the field, particularly in structural analysis, fluid dynamics, and HVAC systems, could be beneficial. - Main objective: Improvement and optimization of an existing prototype. You'd revise the current design and propose enhancements that will increase efficiency, reduce costs, or improve performance. - Skills needed: Prototype testing and debugging, design improvements, and knowledge in production processes. Experience with similar projects is highly valued. Let's refine and perfect my product together.
I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minimal supervision....
I'm in need of a motion graphics designer to create a powerful, engaging video that promotes a trading platform. This is a significant project that requires a skilled and imaginative professional. add same text and can use same idea and effects of the video in this link: and use this link to add to the video: Key Requirements: - The video should be in a captivating Motion Graphics style. - The primary goal of the video is to promote the trading platform, so it should be designed to engage and attract potential investors. - I want the video to highlight the simplicity and ease of use of the platform, using simple but effective animations
I'm in need of an experienced video editor who can skillfully enhance a promotional video targeted towards business executives. Key features that will be required for this project include: - A warm, professional delivery that appeals to a business executive demographic. - The ability to complete the project promptly without compromising quality. - An...complete the project promptly without compromising quality. - An in-touch and current understanding of editing styles, color grading, and music trends. Interested bidders should have a robust portfolio that showcases their knack for creating engaging promotional videos. Extensive experience in editing, especially for corporate environments, is highly recommended. Add proficiency in the latest video editing software in your re...
...Panel Three new data boxes will be added: latitude, longitude and area. These fields will be incorporated into the user data entry form in the HR dashboard. 1.2 Database Update Three new columns will be created in the database users table to store the geolocation data: latitude: Stores the latitude of the work location. longitude: Stores the longitude of the work location. distance_radius: Stores the distance radius allowed for marking a point. 1.3 Modification of PHP Code Only the PHP file responsible for inserting data into the database will be modified due to existing restrictions in the panel. Validations and functionalities will be added to include new geolocation data during the insertion process. 2. Mobile Application 2.1 Application Features Employees will log into...
I would like to modernize this page: The website is written in basic HTML. I would like the content to remain exactly the same (including a table), but to use modern technology so that it would be displayed well on various mobile devices. In principle, the colors and style should also remain the same.
I'm seeking an OCR expert to extract data from scanned tables in PDFs for analytical purposes. Key Requirements - Data Extraction: You should be able to efficiently extract table data from scanned PDFs with accuracy. - Formatting: The extracted data needs to be formatted into an Excel spreadsheet for easy analysis. - Language: The tables are in English, so proficiency in English is a must. Ideal Skills & Experience - OCR Tools: Proficiency with OCR software/tools, and experience in extracting data from scanned PDFs. - Data Management: Good understanding of data management and formatting, particularly in Excel. - Accuracy: Attention to detail and accuracy are crucial to ensure the extracted data is error-free. - English Proficiency: Strong command of the English languag...
Integrate a staking smart contract with a React frontend page for interaction. The necessary components including the staking contract, staking react page and token contract have already been prepared. Initially, we will conduct trials on the Sepolia testnet or other testnet to ensure all systems are operational before launching on the Ethereum mainnet. I have already source code for UI. Budget: 1k timeline: 1 week Our staking contract and staking page have been forked from this project: - Staking contract: - Staking page: How to apply: 1. Video introduction -time: 1~2minutes -format: link url -content: full name, location, skills
I need a skilled Python developer to add functionality to my existing Python code. This is a time-sensitive project that requires immediate attention. Key Responsibilities: - Modify the existing Python code to incorporate new functionality as mentioned in the requirements. - Make sure the code can run on Linux and Windows systems. - Make sure the system can run on multiple monitors simultaneously. - Ensure the code remains optimized and efficient after implementing new features. - Test the updated code thoroughly to identify and fix any potential issues. - Delete the ''About'' tab - Modify how the system looks. Ideal Candidate: - Proficient in Python programming language. - Experience in modifying existing code to add new functional...
I am in need of an experienced legal professional with an expertise in Sports Law. Your role will be to assist in drafting a comprehensive sponsorship agreement. The agreement must highlight key areas including the duration of sponsorship, payment terms, and the rights and obligations of both participating parties. When applying, please focus primarily on your experience in this field. Specific experience with sports related sponsorship agreements will be a significant advantage.
Description: We are seeking motivated individuals to join our team as Outbound Dialers for Health Plan Eligibility. In this role, you will be responsible for reaching out to low-income prospects using the data provided, to determine their eligibility for $0 health plans. Responsibilities: Conduct outbound calls to individuals and families identified as poten...each prospect's status and outcomes. Requirements: Excellent verbal communication skills and a pleasant phone manner. Ability to empathize and connect with individuals from diverse socio-economic backgrounds. Strong attention to detail and accuracy in data entry. Comfortable working independently and managing time effectively. Prior experience in customer service, telemarketing, or a related field is preferred bu...
...here should shows the names of directed referral members and the numbers of all three stages referral members. $30 Button Members names Numbers of referral of three stages Ahmad Direct referral, sub referral members, sub referral(just numbers) Ali 3, 5, 10 Three is five is ten is Direct referred referred referred by three by five Zakir 4, 6, 8 Omar 6, 12 20 ➢ For example In the above table Zakir has four(4) directed referral and the four members invited six(6) more members which are sub referrals for Zakir and the six members has invited eight(8) other members. ➢ A member can invite unlimited members, but when the numbers of referral(direct and undirect) reach to six hundred the members gets salary of this stage which is depend on level cost, the salary is sendin...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm seeking a skilled videographer who can create a compelling short video about my futuristic project, SmartSmile: Robo-Dent Diagnostics. The purpose of the video is: • To showcase the future of dentistry via innovative technologies, specifically focusing ...video will be tailored to: • Dentists – demonstrating how this tool can revolutionize their practice • Investors – providing an insight into the uniqueness of the project and its profit potential • Hospitals – showcasing how we can enhance their dental care services Ideal candidates should possess: • Established experience in producing engaging, informational videos • Knowledge in the dentistry field or the ability to conduct necessary research • Excellent storyte...
Small task: I need a solution for D2. Currently the formula is: B2 * C2. If there is no value in B2 or C2, there is still value 0,00 appearing. I need a new formula: If B2 or C2 is empty, then D2 must also be empty. If there is B2 and C2 given, then the value B2 * C2 should appear. It tried with IF(ISBLANK) but I wasn't successful: **expression is faulty**
I'm looking for a talented developer to help me with my internship project. The project itself is in the field of coding, focusing on Python as the primary language. The application I need is a chat bot. Key requirements: - Strong proficiency in Python coding - Experience in developing chat bots or conversational AI - Interpretation of programming briefs efficiently - Ability to conduct necessary research Given this is an internship project, I'd appreciate guidance and explanations throughout the project. Your expertise in these areas will be crucial in helping me meet the project's objectives.
...correspondance en fonction du numéro de facture, facilitant ainsi la concordance avec les comptes clients spécifiques. Intégration et lettrage directs : Une fois les extraits traités, le module intègre les données directement dans la base SQL, générant des références de rapprochement et facilitant le lettrage. 1- Intégrer le fichier à traiter : • Récupération automatique des extrait bancaires déjà reconnus dans sage à partir de son paramétrage • Dans le dossier d’extrait bancaire ??? 2- Lui donner un nom précis dans un paramétrage ou on a déjà le nom 3- Créer une table de correspondance : &bu...
I'm looking for a dedicated and creative individual to assist with a unique MBA project in the field of financial forecasting, focusing on the banking industry. I am keen on exploring the intricacies of financial forecasting in banking which can set the project apart from the usual. Key tasks will involve: - Conducting thorough and original research on financial forecasting within the banking sector. - Developing a detailed and insightful report on your findings. - Ensuring the work is plagiarism-free and adheres to the highest academic standards. The ideal candidate for this project will have: - A strong background in finance and preferably experience with financial forecasting and banking. - Excellent research skills and the ability to distill complex information into cl...
...simple, and clutter-free design that is effective at conveying information and maintaining user focus. Think simple, sleek, and modern. - Contact Form: The main feature of this website is the contact form. I'd like the form to collect: - Name and Email: Basic personal information fields - Message Details: A text area for users to write their message - Service Inquiry Specifics: An additional field where users can specify what their inquiry is about Ideal skills and experience include: - Proficiency in web development and design with a focus on minimalism - Experience in creating and integrating contact forms - Strong understanding of UX/UI design principles - Capability to create a responsive website - Excellent communication skills to ensure the website meets my spe...
I'm currently creating my website. It's a Dutch (Belgium) website for a company that buys used cars from private individuals. People landing on the site through Google fill out a form and are then contacted with a price offer. The site can only succeed if it ranks well on Google . I need an action plan regarding the site's content. What content should I create? Which keywords should I target? What pages should I create? How can I surpass my competitors as much as possible? How can I analyse competition and outpass them ? How can you help me, and what would it cost?
I am currently in need of a technical writer with expertise in developing quality technical documentation related to the manufacturing sector. I am targeting individuals who can simplify complex information and communicate it effectively. The documentation level will cater to users with intermediate understanding of the field. Key Tasks: - Develop accurate, intensive technical documentation with an understanding of manufacturing processes and technology. - Break down complex manufacturing processes into easily understandable instructions. Ideal Skills and Experience: - Significant experience in technical writing within the manufacturing industry. - Ability to explain technical content to an intermediate audience. - Excellent organizational and analytical skills. - Attention to de...
Add new table to store existing order. Work with ftp only. Freelancer who can follow only
I'm in need of a top-notch translator who can h...top-notch translator who can help me optimize the Spanish translation of marketing content for my industrial tech startup's website. The main goal is to create awareness among Spanish-speaking consumers. Ideal candidates should possess the following: - Fluency in Spanish and familiarity with formal business style of writing - Proven experience in translating marketing content - Knowledge in the field of industrial tech would be advantageous Please provide past translation samples or projects you've worked on. I need this project to resonate with our target audience, making it critical for the voice and tone to be extremely appealing, attracting attention to our products. Let's connect if my requirements align wi...
As a busy business owner, I'm in search of a seasoned digital marketing expert who can take over the management of my online selling platforms. This will include Amazon, Messho, Instagram, and potenti...needed - Providing regular reports on performance and sales The right candidate should have a strong background in digital marketing and e-commerce, as well as experience in managing multiple online selling platforms simultaneously. They should also be comfortable with taking the lead on projects and have excellent communication skills. In your application, please detail your past work in this field. I'm particularly interested in seeing examples of your success in managing multiple platforms. I prefer to communicate via phone calls, as it allows for more immediate disc...
...communicate professionalism, modernity and expertise in the field of electrical and electronics solutions. The colors used should be sophisticated and reflect the high-end nature of our services. Key Responsibilities: - Design a professional, modern, and sophisticated logo that represents our comprehensive home entertainment solutions. - Utilize colors that reflect a sense of high-quality and professionalism. - Ensure the logo conveys our expertise in the field of lighting solutions, sound systems, home theater, and interior design. - Understand the importance of the electrical and electronics solutions industry and incorporate this understanding into your design. Ideal Freelancer: - Experience in designing logos for businesses in the field of electrical and elec...
