Sql select from multiple tables without 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). --------------...
Your task is to design automated solvers for the shift and Vigen`ere ciphers. You must use C as the underlying programming language, in order to get prepared for the following assignments. Each solver should be completely automated, i.e., upon reading a text file containing the target ciphertext (given as command-line argument), it should print the encryption key and the decrypted plaintext without any user interaction. Test your code on the following ciphertexts, and answer these questions: (a) What is the key of the cipher? (b) What is the decrypted plaintext? Ciphertext 1 (shift cipher) ODKBFAXASKBDQEQZFEMPURRUOGXFKZAFRAGZPUZZADYMXMOMPQYUOPUEOUBXUZQEFTQZQQPRADFTQBDABQDUZFQDM OFUAZARODKBFASDMBTKMZPODKBFMZMXKEUEFTUEMDUEQEAGFARFTQRMOFFTMFUZFTQMNEQZOQARDQMXOAYYGZUOMF UAZEDQCGUDQYQZ...
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 ;)
...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. The key functionalities I need are user authentication across these forests and directory synchronization. Key requirements: - Configure a one-way directory synchronization system - 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
...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 should have: - Extensive experience in creat...
...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:UsersUmarDesktopsecurityqr codes). Includes a footer displaying: "Made by Nexgen Solutions." 2. QR Code Scanning and Authentication The scanning module ensures smooth and accurate verification: Single Scan Mode: Scans one parent QR code and one student QR code, notifying if the student is safe to go. Multiple Child Mode: Allows continuous scanning for parents with multiple children. Ends scanning upon pressing "Enter&q...
Malay Recording Project We have a project, that needs Native Malay speakers, we will give you the text, and you need to record 569 Short sentences. you just need to download our software, to read our text and record it, it's a very easy job. 1. You will need to record in a quiet place without loud background noise. and without echo. 2. Each person is $10 dollar for 569 sentences record. If you are interested please let me know sure.I will contact u. A Good Opportunity For New Freelancers For taking 5 Star Review after their completion of the project. Thanks :
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.
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...
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 will help bring...
...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 live streams with interactive features for users...
...and creating custom macros to 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 workboo...
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 ...
I'm seeking a full-stack developer to implement new features into an open-source CMS and de...full-stack developer to implement new features into an 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-friendly, ...
Are you a 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 Potential! – E...
...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 Marketplace API - Knowledge in multi-language and currency support in e-commerce platforms - ...
...customizing Odoo, particularly the Payroll and Attendance modules. Strong understanding of Mauritius labor laws and payroll requirements. Ability to customize Odoo modules to meet specific legal and organizational needs. Excellent communication skills for effective collaboration and training delivery. Additional Information: kindly quote this code: ODOO877 (When submitting your quote - Quote without this code will be rejected/deleted) Please include examples of similar projects you've completed, particularly those involving Odoo and compliance with local labor laws. Provide an estimated timeline and cost for the project. Specify any additional resources or information you will require to complete this project successfully. We are looking for a professional who can deliver ...
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 portfolio showcasing user-centered designs, wireframing, prototyping, and knowledge of modern design tools (Figma, Adobe XD, etc.). You’ll collaborate with cross-funct...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, apply now to jo...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...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 with current trends in fashion branding. Deliverables: Files in multiple formats (e.g., AI, EPS, PNG, JPG) with both full-color and monochrome versions. 3. Domain Name Research Relevance: Suggest domain names aligned with the brand identity. Availability: Ensure domain names are available in various extensions such as .com, .in, .store, and others to accommodate e-commerce needs. Future-Proofing: Consider domains that allow for scalab...
...well as provide relevant suggestions, such as booking a 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 app...
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.
...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 not comfortable working with the previous freelancer because he takes too long to make simple changes. I often have to remind him multiple times, and he outsources the work to other freelancers, which slows down progress. The tech stack used is Laravel for the backend and HTML5, CSS, JavaScript, Bootstrap, and jQuery for the frontend. If you are proficient in these technologies, we can potentially work together long-ter...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...of the VALLON goggles attached. Lens Model: Additionally, I need a 3D model of the lens by itself. this is the same lens as in the ski goggle, and same colors. This model should be rendered in 9 different color variations (matching the ski goggle lenses). Lens renderings should be from a straight front view and as realistic as possible. Skills & Experience: Proficiency in 3D rendering software. Expertise in creating detailed textures and materials. Ability to produce realistic visualizations from multiple angles. Experience with similar product 3D modeling projects is highly preferred (please share examples if you have them). We’re a startup, so this is an important project for us. If successful, there will likely be more opportunities as we introduce...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I'm looking for a meticulous freelancer to assist with data entry from digital files (PDFs). The task involves working exclusively with text data, which needs to be accurately transcribed into a Word document. Ideal skills for this job: - Proficiency in English with excellent typing skills - Experience with data entry and transcription - Attention to detail to ensure accuracy - Ability to handle and respect the confidentiality of sensitive information
An editor specialized in translating our content, i.e. the ch...Translate English live streaming video into German - Maintain the same level of energy and engagement as the original content - Engage audiences in a way that reflects the original broadcast Ideal Skills and Experience: - Fluency in both spoken and written English and German - Experience in live streaming and audience interaction - Previous experience with YouTube content - Instant translation without losing the message or tone of the original content. key features I'm looking for 1 editing 2-scenario 3- sound 4- cover so what I'm looking for is a cash cow team or youtube editor, I'm waiting for experts in the field. channel link:@MrTruthOG we will broadcast this channel in similar formats in German...
...live currency and exchange rates and stock exchange Personalized Recommendations: Content recommendations based on viewers' viewing history and preferences. Broadcast Stream: A real-time table showing live broadcast and program selections. Instant Rewatch (Catch-up TV): Ability to rewatch missed live broadcasts for a certain period of time. Offline Watch: Viewers download their content and watch without the internet. Multi-Camera Options: Users can control the viewing experience by opening different cameras. Interaction and Social Media Features Chat and Discussion Rooms: Continuing conversations are held during the live broadcast. Social Media Integration: Viewers' content can be shared directly on social media platforms. Voting and Polls: Taking parts by conducting po...
I'm looking for a seasoned web ...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 sc...
Graphics for newly formed company which must portray professional ...(1920x1080 px). Formats: PPT or Google Slides. Icons: Custom brand-aligned icons for services/products. --- Additional Notes: 1. File Formats: Request source files (AI, PSD) for future editing. Include both RGB (for digital use) and CMYK (for print use) color formats. 2. Revisions: Ask for a set number of revisions (e.g., 2-3). 3. Scalability: Ensure all assets are scalable without losing quality, especially logos and vector graphics. 4. Naming Convention: Files should have descriptive names (e.g., ). By considering this detailed list, the graphics designing company should get to know exactly what to deliver, ensuring a consistent and professional brand identity for the company
