How to insert values in particular column in sql 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 an advanced photo editing tool that allows for image cropping and Photoshop level editing. The primary requirement though is the ability to insert objects into images. Key Requirements: - Compatibility: The editor should run on Windows, MacOS, and Linux. - Features: Image cropping and a level of editing akin to Photoshop are essential. - Object Insertion: The ability to add objects to images is a key requirement for this project. Ideal Skills and Experience: - Proven experience in creating or customizing advanced photo editing tools. - Strong understanding of Photoshop level editing features. - Familiarity with object insertion tools. - Cross-platform development experience would be a plus.
I need help with my Google Chrome extension. I developed a JavaScript script that retrieves the content of a post and intends to insert . However, I am having difficulty with the process. The feature should apply to platforms like Facebook, Instagram, Twitter and LinkedIn. This should be a simple task.
...background in e-commerce development and digital marketing. - E-commerce Website: The project involves creating a website for branded fragrance, beauty and haircare products. The site should have all standard e-commerce features including product search and filtering, shopping cart and checkout, and user registration and login. The site is expected to host more than 500 products so it needs to be scalable and have efficient product management. - Branding & Stationery: In addition to the website, my project involves related design services such as logo design and stationery, including business cards. The branding must be sleek, modern, and appealing to our target market. - SEO & Social Media: Finally, I am looking for someone skilled...
I'm looking for a p...professional resume writer with marketing expertise to revamp my current CV. My goal is to highlight my experience in the food trade sector, particularly in brand management and market research roles. Key Requirements: - Proficient in resume writing and formatting - Experience in the marketing field, particularly within the food trade industry - Familiarity with the responsibilities of a marketing manager (brand management, market research) - Please provide the details from your resume that you'd like to include and specify any particular focus areas or key achievements you want to emphasize. Please ensure that the new resume emphasizes my accomplishments and responsibilities in these s...
I am in need of a skilled individual who can meticulously extract table data from approximately 7500 pages of PDF files and transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Ple...
I'm looking for a skilled 3D designer who can create a mod...apartment. The project involves visualizing the living room, bedroom, and kitchen in a contemporary and stylish manner. Key Requirements: - Skill in 3D design software - Experience in creating modern interior designs - Ability to translate design vision into 3D form I haven't specified particular features or elements for the rooms, so I'm looking for a designer who can bring creative flair to the project and suggest elements that will enhance the overall design while keeping it modern. Ideal candidates will have a strong portfolio that demonstrates their proficiency in 3D design and an understanding of modern design principles. A background in interior de...
As a growing industrial entity in Louisiana, we require expert guidance on hazardous industrial waste disposal, specifically in the initial phase of waste generation and segregation. Prospective consultants should possess: - Expertise in environmental waste management with a particular focus on industrial waste - Knowledge and understanding of Louisiana's environmental waste regulations - Proven experience in advising on waste generation and segregation processes - Capacity to implement best practices for preserving environmental safety. Your insights will contribute significantly to our effective handling of industrial waste, ensuring we meet regulatory requirements while preserving the environment.
...professional to develop a very small, two-screen mobile application for Expo. This project does not require integration with any external database or backend creation. There is no login functionality. Your responsibility will be to develop an interface similar to figma and with the functions below. *Does not need to be identical to figma, but maintain logic. Link Figma: How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database
I'm looking for a proficient PHP developer who can assist me with an e-commerce web development project. Here are the specifics: - The project involves building an e-commerce platform. - The website should be developed using core PHP. - Aside from ... Here are the specifics: - The project involves building an e-commerce platform. - The website should be developed using core PHP. - Aside from the e-commerce functionality, no further special features are needed for the site. The ideal candidate should have a strong background in PHP development, specifically in building e-commerce websites. Familiarity with core PHP is required for this particular project. If you believe you have the necessary skills and experience, feel free to place your bid and I will b...
Seeking a standout designer to spearhead the creation of a comprehensive brand identity that authentically embodies our company's ethos. Our brand thrives on creativity and innovation, and we're on the lookout for a visionary who can translate these values into compelling visuals and messaging. Key Responsibilities: Visual Brand Design: Craft an irresistible visual identity that captures the essence of our innovative and creative spirit. Voice Tone: Establish a distinctive tone of voice that resonates with our brand personality, ensuring consistency across all communication channels. Brand Values & Principles: Infuse our core principles and values into every aspect of the brand identity, reinforcing our commitment to authenticity and int...
...problems surfacing on this particular Safari version. These issues have been present for over a week now. I require a skilled web developer who can identify the root causes of these discrepancies and make the necessary adjustments to ensure the website renders correctly on Safari 13.1.2. Key responsibilities include: - Diagnosing and resolving text alignment, image display, and layout problems specifically on Safari version 13.1.2 - Running tests to confirm that all changes made have successfully resolved the issues - Ensuring that any modifications do not negatively impact the website's performance on other browsers or devices The ideal candidate should have: - Proficiency in HTML, CSS, and JavaScript - Extensive experience in web developm...
...skilled designer to create a brand-new logo for our video company, Simtech V. The logo needs to reflect a sleek 'techno' feel, while encompassing the sophistication associated with our brand. Key Requirements: - I want the company's name, Simtech V, to be incorporated into the logo, with a particular emphasis on the "letter V". The design should align with a modern look and feel. - The logo will be used across our website, social media profiles, and on offline marketing materials. It needs to be versatile and adaptive for these various uses. Ideal Skills and Experience: - Graphic design expertise - Experience creating versatile logos - Understanding of current industry trends - Ability to communic...
...developed, with specific functionalities catering to a particular audience. I'm looking for a skilled PHP developer to create a website for me. While the exact purpose of the website is yet to be determined, I'd like it to be versatile and user-friendly. Ideal skills and experience for this project would include: - Proficiency in PHP, HTML, CSS, and JavaScript - Experience in designing and developing user-friendly websites - Ability to create dynamic and interactive web pages - Understanding of various web security issues and how to prevent them While the target audience is not specified yet, the website should be designed with a potential business audience in mind. This means a professional look ...
...developer to optimize my .NET and Angular project. The main areas I need improvement in include: - Performance: The project currently suffers from slow loading times. I'm looking for a professional who can optimize the code to ensure faster loading speeds. - Code Structure: The backend code in particular requires attention. I want to restructure it for better readability and maintainability. - Routing and API Optimizations: I need someone to optimize routing and API calls to decrease loading times and improve overall project performance. -Lazy Loading, Eager Loading optimizations Ideal candidates will have: - Proficiency in .NET and Angular - Experience with optimizing projects for performance, especially in add...
...a talented 3D artist to design a modern, sleek bag, suitcase and combo set for an upcoming product line. The designs should encapsulate a sophisticated and contemporary aesthetic that appeals to a stylish, discerning clientele. Although I didn't specify an emphasis on any particular features, creativity is encouraged! Ideal skills & experience would be: - Proficiency in 3D modeling and design, preferably with a portfolio of similar work - Strong understanding of modern design principles - Ability to interpret and execute creative vision - Excellent communication skills to facilitate the design process. We are looking for someone who will make a nice suitcase and a bag like a set. We have the idea but we want to modify it, s...
I'm looking for a developer who can replicate a person based...looking for a developer who can replicate a person based on gpt. The functions I want are as follows. Development environment: Python 1. When I put in a YouTube link, I create a gpt model that has the person's personality, tone, and knowledge. 2. The model made in No. 1 and the app that can chat using gpt api (this is already made with flutter). What I want is to develop No. 1 into Python. If I have to use llm other than gpt, it doesn't matter if I can just get an answer with api. If I can't completely replicate a person with YouTube link alone, I welcome anyone who has other options. The key is to create a chatbot that has the way a particular person speaks, ...
The objective of this task is to evaluate the understanding of students on distributed consensus algorithms and their ability to apply them to solve real-world scenarios. Through these questions, students can demonstrate their knowledge of the Paxos and Raft algorithms, their ability to analyze scenarios, and their problem-solving skills in designing and implementing distributed systems. Additionally, the assignment can assess students' ability to evaluate the trade-offs between the different algorithms and determine which one is better suited for a particular scenario.
Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.
...orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT INTO #O...
I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and ...
I'm looking for an experienced professional to assist me in reverse engineering with IDA Pro. This is a personal project, and my main goal is to create an offset values emulator. Key Responsibilities: - Utilize IDA Pro to reverse engineer specific C# applications - Develop an offset values emulator - Assist in understanding the functionality of the application Ideal Skills: - Proficient in C# and reverse engineering techniques - Experience with IDA Pro - Strong understanding of software vulnerabilities - Ability to create an offset values emulator - Excellent communication and team collaboration skills The project deadline is within 10 days. I look forward to working with a skilled and experienced profess...
I am seeking an ad designer to create compelling print magazine advertisements that will resonate with working professionals aged 25-45. The ads should primarily boost brand awareness within this demographic. Details of what I'm looking for include: - Creating visually captivating designs that align with my brand identity - Ability to research and understand the professional market segment - Crafting messages that effectively communicate the brand's values and mission Skills & Experience: - Proven track record in graphic design, specifically in print media - Strong portfolio showcasing brand-centric ad designs - Excellent grasp of marketing and how to appeal to the 25-45 professional demographic - Knowledge of print a...
...talented software engineer to construct a minimalist portfolio website for me on a custom domain. I believe the minimalist design will promote simplicity and emphasise my portfolio itself rather than the design aspects of the site. Ideal Skills and Experience: - Proven experience in website creation on custom domains - A strong understanding and appreciation for minimalist design principles - Ability to bring concepts to life, balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional ...
I'm in need of a comprehensive presentation on the topic of IOT for generators, with a particular focus on the benefits of Teltonika Devices. The goal of this presentation is to educate and inform our management and decision-makers about the potential advantages and improvements that IOT technology can bring to our generator systems. Key Content: - The basics of IOT for generators: The presentation should start by explaining what IOT is and how it is being utilized in the context of generator monitoring and control. - Real-life applications and outcomes: It would be ideal to include some real-life case studies or examples of how IOT, specifically using Teltonika Devices, has improved generator performance and overall operational...
...skilled and professional writer to create a comprehensive company profile that will be used to represent our business to potential clients. Key Components: - Company History: I'd like a detailed, yet succinct, overview of our company's origins, growth and milestones. - Mission and Vision: This section should clearly articulate our company's purpose and long-term goals. - Products and Services: A concise, yet informative, description of the range of products and services we offer. Tone and Style: - The profile should maintain a professional tone throughout. It should be engaging, informative, and reflect the core values of our business. Testimonials: - I'd like to incorporate some customer testimonials in the profile. The...
I'm seeking a social media specialist with a particular focus on Instagram. My key requirement includes: - Creating and managing tailored content. The focus here will be "behind-the-scenes" content as this aligns well with my brand strategy. - The pivotal message I'm aiming to convey is in the creation of new content. Your creativity in this aspect will be essential. Ideal skills would hence include Instagram marketing, content creation, and brand strategy. Proven experience in these areas would be a bonus. The goal is to evolve my Instagram presence while maintaining the brand's core values in view.
I'm currently in need of a logo designer who can help me create an innovative design for my new venture. The logo should incorporate certain elements, such as letters and icons. Key Aspects of the Project: • The logo design: The design will be from scratch. I'm not looking for designs made using AI or Canva. • Style: The style is flexible as I skipped answering the specific style I wanted, so feel free to use your creativity. • Essential Elements: The logo should incorporate letters and icons. It's up to you to decide how to intertwine these elements to produce a striking, memorable logo. • Color scheme: I'm open to color suggestions. Use your expertise to create a color scheme that ap...
I am in need of a talented game developer who can modify the existing code of my game to make it compatible with both mobile devices and the Telegram platform. Key Requirements: - I am looking for someone who has prior experience in developing games for both mobile and web, especially Telegram. - The game is currently built around a particular genre, but I need you to modify the code to make it more engaging and user-friendly. In essence, the tasks revolve around: - Code modification to ensure that the game is compatible with mobile devices. - Code modification to ensure that the game is compatible with the Telegram platform. - Game enhancement to appeal to a wider audience. Ideal Skills and Experience: - P...
I'm looking for a creative logo designer who can help me create a logo that will be the foundation of my marketing efforts. Key Points: - The logo should effectively convey the essence of my brand. - It needs to be visually appealing and memorable to leave a lasting impression. - The output should be in a high-quality format suitable for various marketing materials. Ideal Skills and Experience: - A strong portfolio of logo projects, particularly those with a marketing focus. - Ability to understand and interpret brand values into designs. - Excellent communication skills to understand my marketing goals and deliver a suitable design.
I'm looking to have a vintage style logo designed for my company. The logo should only consist of the company's name, and it should be designed in earth tones. Key Requirements: - Vintage Style: The logo should have an old-fashioned or retro feel. It should be reminiscent of classic design styles. - Company Name: The logo should consist of the company's name exclusively. No additional text, symbols or icons are required. Ideal Skills: - Graphic Design: A seasoned graphic designer with experience in vintage style logos will be ideal. - Branding: Understanding of how to create a logo that reflects the company's identity and values. - Color Theory: Proficiency in working with earth tones and understanding how to...
In the field of materials resistance, according to the provided data (ed3-09), you're required to carry out tasks in sequences 2, 3, and 4. You won't have to come up with anything new, as you'll be provided with the final results you need, albeit with different values (ed3-10). Your task will be to replicate the processes I've sent you, but with the updated values given in (ed3-09).
...looking to hire a skilled professional to convert the raw footage of this year's family gathering into an engaging and warm documentary-style video. This will serve as a heartfelt memento that chronicles our time together. Key Tasks & Responsibilities: - Closely work with me to understand the essence of our family reunion - Convert raw footage into a 15+ minute-long engaging, documentary-style video - Bring creativity into play to make the project more attractive Ideal Candidate: - Proficiency in video editing software - Experience in crafting documentary-style videos - Ability to understand and capture family dynamics, values, and emotions - Maintains excellent communication and is open to feedback - Has a ke...
...purpose of the website is to provide information about a particular subject. The website should be designed in a way that is engaging, user-friendly, and easy to navigate. - Square payment gateway integration: I need the website to be integrated with Square payment gateway. This is crucial as I plan to accept payments for services/products through this channel. - 1-10 pages: The website should have between 1-10 pages. I want the information to be presented in a clear and concise manner, and for the design to be clean and professional. Ideal Skills and Experience: - Proficient in web design and development - Experience with integrating payment gateways, specifically Square - Able to create a clean, user-friendl...
I am looking for a skilled individual to assist with the sales and marketing aspects of my business. The ideal candidate should have a strong background in both sales and marketing, with particular emphasis on increasing brand awareness and generating leads. My business is related to saree suit and lehnga i have got a shop in karol bagh ,new delhi and would love some support of yours. Key areas of focus include: - **Sales and Marketing Strategy:** Design a comprehensive plan for boosting sales through strategic marketing efforts. - **Brand Awareness:** Increase the visibility and recognition of our brand through targeted marketing initiatives. - **Lead Generation:** Implement strategies to attract and capture more leads, with a focus on quali...
...artist to create an engaging and entertaining business introduction video. The video should be created in a cartoon style to provide a light-hearted and inviting feel. Here's what I'm looking for: - Spunky, Cartoon-styled Motion Graphics: As the theme of the video is cartoon-styled, it would be ideal if you have experience in creating entertaining and fun cartoon graphics. - Color Scheme: As I have no specific color preference, I encourage artistic freedom in your use of colors. However, ensure that the overall color scheme complements the essence of our business and isn't too overbearing. - Business Introduction: The central focus of the video should be introducing my business to the audience. Please create an engaging storyline...
I'm searching for a skilled web developer to create an exceptional attendance system. Duty based attendance, For a given date and for a given duty you will be having only one employee working We should be able to add new duties. For given day you will be having fixed duties….we fill employee names into those duties….there will be some optional duties….we might assign it or not. Kitchen duties assignment form, and restaurant duties assignment form…..word formats of these forms are attached. Duty type – full or half Employee table – name, role, salary type, salary, and other personal details, Based on the duties assignment we should calculate summary reports…head count reports…..cost incurred report…. Weekly Du...
...microservice application and are having problems with crashing pods. Need an expert to review our implementation/deployment/architecture and recommend solutions to remediate this issue and prevent it from happening again in the future. FREELANCER DESCRIPTION I'm in need of a professional to help me deploy my microservices application onto an existing Kubernetes cluster. Key requirements include: - Expertise in Kubernetes: A deep understanding of Kubernetes is a must, as the successful candidate will be responsible for deploying and managing my microservices on an existing cluster. - Microservices experience: An understanding of microservices architecture and best practices will be critical. - Troubleshooting skills: Assist in id...
...help me create a comprehensive food costing spreadsheet. In particular, I would like the following sections: - **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes. - **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients. - **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs. - Inventory management: - **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels. - **Predict Future Inventory Needs**: an analysis that could help me foresee when I'll need to restock certa...
I'm seeking a data analyst to help with processing and analyzing financial data. Key Responsibilities: - Your main objective will be to identify significant patterns and trends within the provided financial data. - I need you to provide a comprehensive, written analysis of these patterns, along with the necessary context for a non-specialist to understand. Ideal Candidate: - Proficient in financial data analysis. - Previous experience in identifying financial trends and patterns. - Skilled enough to produce comprehensive written reports. - Familiar with common tools used for financial data analysis. This case will measure your analytical skills, your ability to use Excel/Google Sheets and also give you a glimpse of what some...
...mentor proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly i...
