Sql select from multiple tables 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
Task 1. Take these pages away from the HTML- sitemap: Al – käyttöehdot Al – Kiinteistönvälittäjän kilpailutus Al – kiitos Al – rekisteriseloste Al – tulos Al – Välityspalkkiovertailu Task 2. Enable our text-logo () to all affiliate pages. It is not enabled on our affiliate templates now.
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 looking for an experienced web developer to create a robust residential rental website. The site's primary function will be to facilitate online booking and payments that support Arabic and English. Key Features: - Real-time availability: Tenants should be able to see property availability as it changes. - Multiple payment options: The site should accommodate various payment methods for tenant convenience. - Automated email confirmations: Once a booking is made, an automatic email confirmation should be sent to the tenant. - Safety Refund: Implement a system that ensures the safety of tenant refunds. - Safety Platform: A reliable platform that guarantees the safety of transactions. User Roles: - Property Owners: They should be able to list their properties, manage bo...
I am looking for a professional who can convert my AutoCAD files into a format suitable for 3D printing. The primary purpose of the 3D printed model is to build a modular model of a house and compare possible options. Key Responsibilities: - Split one existing plan into multiple modular plans which together give the total model - Convert AutoCAD files into 3D printable files. - Work closely with me to finalize the modularity of the the 3D model. - add modules as we understand options - Potentially add levels of detail as necessary. Ideal Skills: - Proficiency in AutoCAD. - Experience with 3D printing and corresponding software. - Excellent English/German communication skills for collaboration. While the scale of the model is yet to be defined, I am open to suggestions based on y...
I am in need of a sophisticated and timeless logo for my e-commerce venture, 'Ranas Prime Enterprises'. Below are the detailed requirements: Key Aspects Style: The logo should embody a classic and elegant aesthetic. Color Palette: Preferred colors are g...Candidate Qualifications Proven experience in logo design, particularly in creating classic and elegant styles. Strong understanding of color theory with the ability to apply it creatively to enhance the logo's appeal. A portfolio showcasing work with animal icons, especially big cats, in a sophisticated and high-end context. Capability to deliver high-quality, scalable vector graphics suitable for multiple formats and platforms. I am looking forward to receiving unique design concepts that capture the essence of &...
I'm seeking a meticulous freelancer for a data entry project focusing on numerical data. The data will be sourced from various databases. Ideal candidates should: - Have experience in data entry, particularly with numerical data - Be proficient in working with databases - Have a keen eye for detail to ensure data accuracy - Be able to maintain confidentiality and handle data securely
...and sleek design for a ride-sharing mobile app. The app will cater to both drivers and riders and will need to cover the following user flows in the initial design: - Sign-up/Log-in process - Ride booking process - Payment process I plan to work on multiple projects in the future, with each milestone focusing on 5-10 screens. Therefore, I'm keen to establish a long-term collaboration with the right designer. Please note: - I will only consider quotes that include a PDF of your design work. - Competitive rates are a must as I plan to do multiple projects. Ideal skills for this project include: - Expert-level knowledge of Figma - Experience in designing for mobile applications - Strong understanding of modern and sleek design principles Please send me your design ...
I'm looking for an expert to assist with migrating our email solution from an on-premises Exchange to Office 365. Key Requirements: - Migration of over 200 mailboxes - Transferring of contacts and calendars alongside emails - Ensuring minimal downtime during the transition Ideal Skills and Experience: - Proven experience with Office 365 migrations - Proficiency in handling large scale email migrations - Expertise in data transfer including contacts and calendars - Excellent troubleshooting skills to handle potential issues during the migration process
...and user-friendly online store to sell my products. The store should include the following features: 1. E-Commerce Functionality: • Product catalog with categories and filters. • Product pages with detailed descriptions, images, and pricing. • Shopping cart functionality. 2. Online Payment Integration: • Secure payment gateway integration (e.g., PayPal, Stripe, or others). • Support for multiple payment options (credit/debit cards, digital wallets, etc.). 3. Shipping Integration: • Integration with shipping carriers for real-time shipping rates. • Automatic tracking updates for customers. 4. Responsive Design: • Fully optimized for desktop, tablet, and mobile devices. 5. User-Friendly Admin Panel: • Easy-to-manage invento...
...Services: The app should support user profiles, matchmaking, and chat functionalities. - Wedding Planning Tools: It should include checklists, budgeting tools, and a vendor marketplace. Ideal Skills & Experience: - Proficiency in modern frameworks such as React Native, Flutter or similar is crucial. - Strong backend development skills (Node.js, Python, or comparable). - Expertise in database design (SQL/NoSQL). - UI/UX design skills to create an elegant, user-friendly interface. - Knowledge of best security practices is a significant plus. Please share your portfolio or any relevant case studies. I look forward to collaborating with you to bring this project to life....
I need help in analyzing my network logs to identify attack and non-attack logs. I'm looking for a freelancer who can employ multiple feature representation techniques such as Auto Encoder, Variational Auto Encoders, WGAN, and Kernel PCA to extract features and learn patterns from my aggregated data. The problem I am facing is that none of the feature representation techniques I've tried so far is able to generalize well and perform on test data. Your final deliverables would be: - At least three feature representation techniques for comparison - A comprehensive final report detailing the performance of the different techniques. Ideal skills for this project include: - Strong background in data analysis, machine learning and feature representation techniques. -...
We are looking for an experienced developer to create a module for FOSSbilling that extends the existing HestiaCP controller. This module will allow clients to manage various aspects of their hosting directly from the FOSSbilling panel, eliminating the need to remember multiple passwords. Key Responsibilities: Develop a module for FOSSbilling that integrates with the HestiaCP API. Enable clients to perform tasks such as adding SSL to their website, managing DNS records, and potentially managing mail features directly from FOSSbilling. Design and implement both front-end and back-end components for seamless user interaction and API communication. Ensure the module adheres to best practices in security and usability. Submit the module as a PR to the FOSSbilling reposi...
I'm seeking an experienced agency / professionals to help me generate 150-200 leads for B2B sales in the education sector. Target client audience in K-12 schools across India and US. The methods of lead generation can be any including : - Email Marketing - Social Media Outreach - Cold Calling - Partnerships The ultimate goal of this campaign is increase in pipeline. An understanding of or experience in the education industry would be an advantage.
I'm seeking a skilled team to construct a comprehensive online igaming/casino platform. The platform must feature: - Integration with Slotegrator as the game provider - Compatibility with multiple payment providers including PayPal, Stripe, Nowpayments, Gpay, and Apple pay - A robust referral system - Advanced analytics functionalities focusing on player behavior tracking, revenue reports, and game performance metrics - A solid admin panel for complete platform management Ideal candidates should have extensive experience in iGaming platform development, with specific expertise in integrating with Slotegrator and the aforementioned payment providers. Proficiency in creating advanced analytics systems and user-friendly admin panels is also crucial. Please include releva...
...distributed exchange. This system will allow each client to manage its own instance of an order book, where orders are submitted, distributed across nodes, and matched in real-time. Responsibilities: - Develop a distributed exchange system using JavaScript. - Implement communication between nodes using Grenache. - Design a simple order-matching engine. - Ensure seamless distribution of orders across multiple instances. - Handle remaining unmatched orders by updating the order book. Requirements: - Strong proficiency in JavaScript. - Experience with Grenache or similar P2P communication tools. - Familiarity with Node.js and asynchronous programming. - Understanding of order-matching logic. - Ability to work independently and deliver within 6-8 hours. Nice to Have: - Knowledge o...
I've developed a construction management workbook in Excel ...QuickBooks. I also want to integrate a construction schedule into the workbook. Specifically, the types of data analysis tools I want to improve are custom formulas, pivot tables, and data visualization techniques such as charts and graphs. Ideal Skills and Experience: - Expertise in Excel, specifically in creating and modifying workbooks - Experience with construction management tools or software - Proficiency in designing user-friendly interfaces - Knowledge of QuickBooks for potential syncing - Ability to create advanced reporting features - Skills in data analysis, particularly with custom formulas and pivot tables - Experience in data visualization techniques - Good communication skills for discussing...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I need assistance with a data entry project involving loan information. The data is contained in scanned documents and includes various financial details. Specifically, the data entry involves: - Financial details such as income information - Credit scores - Bank statements Ideal skills for the job include: - Proficiency in data entry - Excellent attention to detail - Experience working with scanned documents - Ability to handle sensitive financial information with confidentiality and integrity.
...services with high-quality images. Brief about our company and mission. Clear Call-to-Action (CTA) buttons for booking consultations or inquiries. Service Pages: Detailed descriptions of each service offered (Event space rental, Photography, Floral Arrangements, Catering, etc.). For each service, we would like a gallery section showcasing past events. Pricing plans (if applicable) with easy-to-read tables or a "Request Quote" form. Portfolio/Gallery: Showcase of past weddings and events with high-quality images. Interactive gallery with categories like "Wedding Venues," "Photography," "Floral Arrangements," etc. Option to view larger images when clicked. Booking & Inquiry System: A user-friendly booking system where clients can submit e...
Spanish 200 Short sentence recording from Native Spain only . Are you a native Spanish speaker born and raised in Spain ? We have an easy and rewarding task for you! Task Details: - **Record 200 Short Sentences:** Use the Funcrowd APP to record 200 short sentences. It take only 20 minutes to complete it - **Recording Device:** A good quality latest mobile phone. ( Preferably iPhone) - **Environment:** A quiet setting to ensure clear recordings. **Compensation:** - **Payment: $7 for this quick and simple task. - - **. We need over 100 participants! You can also provide other people recordings **Requirements:** - **Exclusivity:** This task can only be done once per person. If you have previously recorded the same 200 sentences on Funcrowd APP, you are not eligible. Receive a 5-...
Hello Khalil, having worked with you on multiple projects, i am confident that you will be able to help me with implementing this project too.
...different audiences - General awareness of a variety of topics - Willingness to learn and improve task management - Familiarity with grammar basics to produce error-free content - Eagerness to develop technical and social media writing skills - Basic editing skills with attention to clarity and coherence - Enthusiasm to learn time management and audience analysis - Openness to multitask and handle multiple assignments Experience: - No prior experience is necessary, though any relevant experience is a plus - A basic understanding of content creation and the ability to meet deadlines Working Days: - Mon to Sat - 10 am to 7:00 pm ** We always give you 5-star feedback ** We will not create or release milestones in advance. I will make payments on a weekly or monthly basis. ** Mayb...
Project Overview: We are seeking a creative and professional logo designer to design a logo for Aripta Foundation, a non-profit organization dedicated to Social wel...The logo should include the name "Aripta Foundation." You may also incorporate abstract symbols or elements that represent concepts like growth, unity, education, etc. We are open to your interpretation and ideas. Typography: The font should be easy to read, professional, and align with the overall style of the logo. It should work well in various sizes. Format: Please provide the final logo in multiple formats (e.g., .ai, .eps, .png, .jpg, etc..) and ensure it is scalable for different uses . PS: The logo will be also used for legal purposes like Stamps & Seals, Letter head positively consider colour &...
I'm seeking a web developer to create a 'middle man' e-commerce website. The platform will sell products for other people and will require a comprehensive database structure with customer tables, business tables, product tables, etc. Key Project Aspects: - I have ER diagrams (19 tables), a data dictionary, a journey map, and web page designs. While the designs can be flexible, they may require minimal changes. - The website needs to be optimized for both desktop and mobile equally. - As for the technology stack, I have no specific preferences or technologies to avoid. However, I would like the scope to allow for future development into an app. Ideal Candidate: - A confident professional who can create this product. - Honest, with the ability to...
I'm seeking an Executive Technical Assistant who will primarily support me with technical tasks, project management, and data analysis. The role will require a strong proficiency...will require a strong proficiency in MS Word and Excel, particularly with their advanced features. Key Responsibilities: - Call the clients - Follow up for data - Preparation of reports Essential Skills: - Proficiency in MS Word and Excel - Experience with technical support, project management and data analysis - Ability to prepare comprehensive reports Preferred Excel Skills: - Simple excel tables and summary The ideal candidate will have a strong ability in data interpretation, with a focus on operational metrics analysis. Experience in interpreting market research and financial data will be
I'm looking to set up DRBD for replicating database data and virtual machine images. This project involves using Linux's block device replication (DRBD) for high availability and r...DRBD for replicating database data and virtual machine images. This project involves using Linux's block device replication (DRBD) for high availability and redundancy. Key Tasks: - Data Replication: Implement DRBD for replicating DB data, LVM for VMs, utilizing RBD device for SQL Server and MongoDB. - Configuration: Set up DRBD within an LVM for VMs storage configuration. - Database: Primarily focusing on LINBIT DRBD with SQL Server and MongoDB. Ideal Skills: - Proficient with DRBD and LVM - Extensive experience with SQL Server and MongoDB - Knowledgeable in configuring r...
I'm seeking a skilled computational chemist to help calculate the vibrational characteristics of various compounds, such as OSR (Emeramide, NBMI). This research project will delve into different regions of the spectrum, including visible light, Raman, and potential low-frequency vibrations. Key Tasks: - Select appropriate software for the task. - Develop a suitable process (potentially a script) for analyzing any substance given its formula and structure. To be considered for this project, you must demonstrate: - Your expertise in computational chemistry. - Your proficiency with the software you're planning to use. Fields of Interest: While there are no specific compounds or spectrum types set in stone, a focus on organic compounds and the Raman spectrum could be bene...
I'm seeking an interior designer with a strong grasp of the industrial aesthetic to transform a space in my home into a unique man cave. Key Responsibilities: - Conceptualize and design an industrial-style man cave - Optimize the use of space while ensuring comfort and style - Select appropriate materials, colors, and furnishings that embody the industrial theme Ideal Candidate: - Extensive experience in residential interior design, particularly with industrial style - Strong portfolio of similar projects - Excellent spatial awareness and creative thinking skills - Ability to work within a set budget and timeline
Position Summary: We are looking for a rigorous and competent data entry professional to ensure the entry, processing and management of data in our systems. The i...and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Google Sheets. - Good knowledge of advanced Excel functionalities (pivot tables, complex formulas, etc.). - Strong data security skills (access management, encryption, best practices). - Experience in using Adobe InDesign for document creation and editing. - Convert manual documents to di...
...my software to be used for profit and for my business. Key Requirements: 1. Motion Capture from Video: Track actor body movements and facial expressions from video. Using tools that have no subscriptions. 2. Facial Expression Capture: Automate facial animation using for real-time facial tracking. 3. Seamless CG Character Integration: Use Blender (free) for animation, rigging, and rendering of CG characters. The system must apply motion capture data without manual intervention. 4. No Expensive Subscriptions: The platform should use free or inexpensive one-time purchase tools (no ongoing subscriptions). 5. User-Friendly Interface: Provide a drag-and-drop interface where users can upload videos, select CG characters, and replace actors automatically. 6. Real-Time Rend...
...different audiences - General awareness of a variety of topics - Willingness to learn and improve task management - Familiarity with grammar basics to produce error-free content - Eagerness to develop technical and social media writing skills - Basic editing skills with attention to clarity and coherence - Enthusiasm to learn time management and audience analysis - Openness to multitask and handle multiple assignments Experience: - No prior experience is necessary, though any relevant experience is a plus - A basic understanding of content creation and the ability to meet deadlines Working Days: - Mon to Sat - 10 am to 7:00 pm ** We always give you 5-star feedback ** We will not create or release milestones in advance. I will make payments on a weekly or monthly basis. ** Mayb...
I'm looking for an experienced Android developer who can create an app for generating GST sales invoices. This app should include a backend SQL database for data management. Key Requirements: - The app must be able to create sales invoices. - It should include invoice templates for ease of use. Ideal Skills: - Proficient in Android app development. - Experienced with SQL database management. - Good understanding of GST regulations. - UI/UX design skills for creating intuitive templates.
I'm experiencing some issues on my website that need urgent attention. - Elements like the footer area aren't functioning properly. - There are multiple errors on various pages, particularly the homepage. - I need someone who can identify and fix these issues as soon as possible. Ideal skills for this job include web development and troubleshooting experience, as well as a good understanding of website structure and elements.
I'm looking for a professional data entry specialist. The job involves transcribing information from scanned PDF documents into online forms. Ideal Skills and Experience: - Proficiency in data entry - Experience with online form data entry - High level of attention to detail - Ability to maintain confidentiality - Comfortable working with scanned PDF documents
