Sql select from multiple tables with join 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 am in need of a professional who can assist in parsing technical reports from PDF format, extracting key information and generating concise summary reports. Key Responsibilities: - Parsing technical reports from PDF files - Extracting relevant information: summary data, detailed metrics, and graphs and charts - Creating concise and accurate summary reports Ideal Skills: - Expertise in text processing and natural language processing (NLP) - Proficiency in automation tools to ensure consistency across multiple runs - Strong analytical skills to identify and extract key information from complex reports Experience with technical reports and PDF processing is a must. Please only apply if you have the necessary skills and experience to deliver high qualit...
...for a professional web developer with extensive experience in blockchain and security to create a robust, user-friendly airdrop website for my EDUTUBE token. This platform will integrate multiple social media platforms for user task authentication and provide a submission of Solana wallet addresses by pasting on a column and a referral link will be generated to invite others. Key Features: - An intuitive, easy-to-navigate website designed for EDUTUBE token airdrops $EDUT. - Integration of various social media platforms for user authentication. This includes Twitter, Instagram, TikTok, Telegram, Discord, and Medium. - A secure, reliable system for users to submit and store their wallet addresses. Ideal Candidate: - Proficient in Blockchain development with a focus...
...The mobile app revolves around user profiles that need to be integrated with the existing web app. Each user should be able to create and customize their own profile and resume, production, venue and company pages. - Developer will also be asked to fix Github errors. App Details: - Profile Picture: Users should be able to upload a profile picture. - Bio/Description: Each profile should have a section for a brief bio or description about the user. - Contact Details: Users should have a space to include their demographic and personal data. - Artist Magnet will provide PDF design templates that the Coder will need to turn into figmas and share with the Developer. - Some of the design templates will need to be derived from the current web app and turned into figmas by...
...and organizing product data, including pictures and descriptions, into a professional catalog format. Project Scope: 1. Review the websites of approximately 10 suppliers (the exact number may vary). 2. Extract and organize the following information for each product: • Product Name • Product Description • Specifications (if available) • Packaging Sizes (if applicable) • Images (downloaded from the website or product sheets) 3. Prepare one catalog per supplier, ensuring clear formatting and organization. 4. Deliver the catalogs in Excel, PDF, or another agreed-upon format. Requirements: • Strong attention to detail and ability to accurately extract and organize product data. • Experience in building catalogs or product lists (preferab...
I am looking for an expert in Active Directory Lightweight Directory Services (AD LDS) configuration to help me integrate it with multiple forests and sync users to Cisco Call Manager v15. The key functionalities I need are user authentication across these forests and directory synchronization. Key requirements: - Configure a one-way directory synchronization system with Cisco CUCM - Implement LDAP as the primary authentication protocol for cross-forest user authentication Skills and experience: - Proficient in AD LDS configuration - Extensive knowledge and experience with LDAP - Prior work with multi-forest integration is a plus - Familiar with directory synchronization methods, especially one-way sync
I'm in need of a custom tech pack for a unique head covering clothing prototype. This piece is aimed at the everyday user, with a focus on being hygienic yet fashionable. The tech pack should feature separate designs for male and female, and include a holding pouch for clean and used items. Key elements to be included in the tech pack: - Free design consultation - Construction call-outs - Technical drawings to scale - Multiple colorways, print; embellishment details - Basic Graded Specs - Point of measurement diagrams - Bill of Materials - Brand; Care Labels, Folding instructions, Tags I'm eager to discuss the specific design and application of this head covering with you. A zoom meeting or call can be arranged to go over the details. Ideal candidates shou...
...and efficient solution designed for educational institutions to enhance security and streamline operations. This software provides a seamless way to track attendance and verify the identities of students and parents using QR codes. Developed with scalability and reliability in mind, it includes intuitive interfaces, robust functionality, and professional branding to meet the needs of modern schools. Key Features 1. QR Code Generation The system generates unique QR codes for parents and students: Parents retain a single QR code, even if they have multiple children. Each student has a unique QR code linked to their parent. QR codes are organized into folders named after the student(s), ensuring easy access and management. All generated QR codes are saved in a directory (C:...
I am seeking a dedicated and versatile Female Virtual Assistant from India to assist with a variety of tasks. This role requires flexibility as the tasks may vary. Key Requirements: Indian Female candidates only. Must be open-minded and willing to take on different responsibilities. Strong proficiency in English is essential. Freshers are welcome and will be given priority. Ability to follow instructions diligently. Responsibilities: Daily reporting of completed tasks. Handling miscellaneous administrative tasks as required. Payment Details: Pay will be on a weekly basis. Please provide details of your past experience and pay expectations. If you meet the above criteria and are interested in this opportunity, please submit your application.
...tools, a user-friendly interface design, advanced reporting features, and syncing with 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 technique...
Join Our Team! Kashafa Sukses Bersama is seeking dynamic, creative, and motivated individuals to join us as Freelance Marketing Professionals. We are a company specializing in certification and regulatory support services, including ISO, BPOM, SNI, Halal, and other relevant certifications. Qualifications: Minimum education: Associate Degree (D3) in any field. Experience in regulatory and certification fields (ISO, BPOM, SNI, Halal, SOP, business processes, and other relevant certifications) is an advantage. Excellent communication skills and results-oriented. Capable of working independently to meet assigned targets. Prior experience in marketing is preferred. Job Responsibilities: Promoting certification support services, including: ISO 9001:2015, ISO 22000:2018, ISO 14001...
I'm looking for a ...will sell physical goods and needs to include a quick commerce (q-commerce) checkout process. Key Features: - The website should have a seamless q-commerce checkout process to ensure fast delivery of goods. - Integration of multiple payment methods including Credit/Debit Card, Bank Transfer, and Razorpay gateway. - Implementation of Delhivery for all shipping needs. Ideal Skills: - Extensive experience with Laravel framework. - Proficiency in eCommerce website development. - Familiarity with q-commerce and its integration in web platforms. - Knowledge of integrating multiple payment gateways and shipping services. This project requires a professional who can ensure the website is user-friendly, secure, and efficient. Your expertise w...
...social networking platform with the following functionalities: Audio and video calls: Users can call any streamer on the platform. Live streaming: Users can join live streams hosted by streamers. This project includes the development of two apps: User App: Modify the existing Rayzi App APK. Streamer App: Develop a new app from scratch for streamers. Scope of Work 1. User App (Rayzi App APK) Additions: Introduce new features as outlined in the sheet. Enhance functionalities to improve user experience. Modifications: Update existing features to align with the new requirements. Removals: Eliminate unnecessary features as specified in the sheet. 2. Streamer App Development Scope: Build the app from scratch for streamers. Features to Include: Host li...
...save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validation rules. Excel Reports: Generating comprehensive and structured reports for decision-making. Financial Modeling: Creating models for budgeting, forecasting, and performance tracking. Excel Templates: Designing reusable templates for recurring tasks. Data Consolidation: Combining data from multiple sheets or workbooks. Excel Integr...
I'm in urgent need of a hi...server. This proxy will primarily be used to bypass internet restrictions and access fps gaming websites. The ideal candidate for this job should have extensive experience in setting up proxy servers and ensuring they can support multiple users simultaneously without any lag. Key Requirements: 1. Excellent performance: The proxy must be incredibly fast with no lag. 2. Web Accessibility: Users should be able to access the proxy simply by typing in a link, without any other configuration. 3. Multi-user Capability: The proxy should support simultaneous access for multiple users. This project is time-sensitive and needs to be completed as soon as possible. Please only bid if you have the necessary skills and experience to deliver a high-...
I'm seeking a full-stack developer to implement new features into an open-source CMS and design a responsive/mobile-friendly website. Key tasks ...open-source CMS and design a responsive/mobile-friendly website. Key tasks will involve: - Adding a Reviews Plugin, Embed Social Media Plugin, and Referral Plugin to the CMS - Prioritizing the development of the Reviews Plugin - Ensuring the website design is responsive and mobile-friendly Ideal skills and experience for this job include: - PHP, SQL, Javascript, and HTML & CSS - Proficiency in full-stack development - Experience working with open-source CMS - Strong web design skills, particularly for responsive and mobile-friendly sites - Previous work integrating plugins into a CMS - Expertise in developing user-fri...
...People Person? A Go-Getter? Ready to Make Serious Money? ? We are looking for dynamic, driven, and results-oriented Sales Specialists to join our team and help us grow! This role is perfect for anyone who loves to hustle, close deals, and build long-lasting relationships. What You’ll Do: ✅ Generate Leads – Discover new opportunities and connect with potential clients across platforms. ✅ Cold Leads? No Problem! – Set up the first meeting, showcase our offerings, and make that killer first impression? ✅ Hot Leads? Close the Deal! – Connect high-potential leads with our executives and watch the deals roll in. ? What’s in It for You? ? Base Salary of $25 - 50$ with an Increment according to Performance. ? Unlimited Earning Potent...
...developer to create a Prestashop module that integrates with the Trendyol Marketplace API. The module should support product listing, inventory management , message management and order synchronization. Key Features: - Product Listing: Seamless integration for listing products on Trendyol - Inventory Management: Real-time inventory syncing reflecting on the marketplace and prestashop - Order Synchronization: Automatically syncing orders from Trendyol to Prestashop Additionally, the module must support: - Multiple Languages: To cater to the diverse Trendyol customer base - Different Currencies: As Trendyol operates in various currency zones Ideal skills for this project include: - Proficient in Prestashop module development - Experience with Trendyol Marke...
UI/UX Designer for Dashboard and Mobile App We are seeking a talented UI/UX Designer to create intuitive, visually appealing designs for our dashboard and mobile app. The ideal candidate has a strong portfoli...appealing designs for our dashboard and mobile app. The ideal candidate has a strong portfolio showcasing user-centered designs, wireframing, prototyping, and knowledge of modern design tools (Figma, Adobe XD, etc.). You’ll collaborate with cross-functional teams to ensure a seamless user experience that aligns with our brand. Strong problem-solving skills and attention to detail are essential. Experience with responsive design and understanding of front-end development is a plus. If you’re passionate about crafting outstanding user interfaces, app...
We seek a freelancer with a proven track record in branding and design who can deliver the following: 1. Brand Name Development Creative and Unique: The name should reflect the essence of women’s fashion—feminine, stylish, and forward-thinking. Memorability: Easy to remember and pronounce for a global audience. Domain Availability: Must verify the availability of domain names in extensions like .com, .in, .store, .shop, etc. 2. Logo Design Aesthetic Appeal: A visually compelling logo that captures the brand’s core values—elegance, empowerment, and sustainability. Versatility: A design adaptable across different platforms—website, social media, product tags, packaging, etc. Modern and Minimalistic: The logo should stand the test of time and align w...
...cab. - Comprehensive Transportation Support: The software should cater to all modes of transport. This includes air, train, and road travel. - User-Friendly Mobile App: The software needs to be delivered as a mobile application with an intuitive interface. - Efficient Communication: Instead of manually getting travel requests signed by multiple officials, the software should facilitate direct communication with authorities. Travel requests should be sent directly for approval. - Urgent Request Handling: The software should have a feature for urgent requests, with direct notifications sent to the main authority. It should also include an immediate approval option for critical situations. If a request is pending or not approved, an alert should be sent to t...
I'm seeking an experienced data modeler with a strong background in the healthcare industry, particularly with handling patient records. The primary goal of this project is to integrate various data sources into a cohesive model. Ideal Skills: - Proficiency in data modeling techniques - Experience with patient record data - Strong understanding of data integration processes - Familiarity with healthcare industry standards and regulations Please bid if you have relevant experience and can help me reach efficient and effective data integration.
...the website with content, and it is ranking on Google. However, the UI has many issues, and the website is slow. The website is hosted on a shared cloud server owned by the developer, which I have paid for. Now, I am seeking a developer who can understand the current setup and make the necessary changes according to my requirements. I also need help migrating the website to a different cloud server. Additionally, I need assistance with SEO setup. I know what needs to be added for SEO, but I am unsure where and how to add it in the code. Other tasks include email integration and Google Console setup. We can arrange a meeting with the previous freelancer, and he can provide access to the current setup. From there, we can continue with the work. I am...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
... This project requires high-quality rendering with realistic textures and materials—not just basic shapes and colors. Project Details: Ski Goggle Model: The goggle strap must include the logo HØKEN in the font TT RUNS (a free font). The model should be based on attached photos and reference images. I can provide additional photos if needed. The finished 3D model should be highly realistic, almost like a photograph. Color Variations: The final model should be rendered in 36 color variations: 4 different frame colors 9 different lens colors The lenses need to appear extremely realistic in all visualizations. Its only 1 model. Deliverables: Raw 3D file: This allows me to make future color changes. However, I’d prefer to work long-term with someone as...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...Recommendations based on users' viewing shares. Interactive Features: Features such as polls, voting, and live chat with viewers. Subscription and Advertising Model: Paid prices, ad revenues, or both instantly. Platform Support: Combination of iOS, Android, web, and Smart TV. Notifications: New content and live broadcast announcements. Parental Control: Restrictions for content suitable for children. 2. Technology and Infrastructure For Live Broadcast: Wowza, Amazon IVS, or WebRTC-based solutions. Fast and continuous broadcast using CDN (Cloudflare, Akamai). Application Development: Mobile: Flutter (iOS and Android with a single code base). Web: React.js or Vue.js. Backend: Provided in a powerful API with Node.js or Laravel. Database: MySQL or MongoDB. 3. UI/UX...
I'm looking for a seasoned web developer with comprehensive knowledge in HTML, CSS, JS, and WordPress. I need to transfer my current website, , to a custom-coded WordPress site. Key Requirements: - Preserve the current design of my website. - Retain and enhance the E-commerce capabilities of the site. - Implement key e-commerce features including: * Product search and filtering * Multiple payment gateways * Order tracking Ideal candidates should have: - Prior experience in custom WordPress development - Strong understanding of HTML, CSS, and JS - Proven track record in E-commerce website development - Ability to replicate and enhance existing website design. Please check my current website for a better understanding of the project scope.
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 professi...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 your expertise. The level of detail will also be determined during the project. I look forward to working with a professional who ca...
I am in need of a sophisticated and ...Prime' as the text. A lion motif should serve as the central visual element, symbolizing strength and nobility. The lion design should avoid being overly cartoonish, aligning with the classic and elegant style. Ideal 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 ...
...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 m...
