Access 2007 advanced sql query 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). --------------...

Access-tietokanta, joka sisältää tiedon syöttämistä, raportteja ja mahdollisuutta muokata tietoja.

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ä.

PSD file should be encoded in HTML5 as a ...a MySQL database, which is pre-coded. Player makes bitcoin transfer us, and the transfer is calculated to 20-digit binary number which determines a coin shop. 0 = right and 1 = left. Binary and bitcoin transfer calculation are encoded completed, but the playing area and mainsite should be encoded bit in the same style as has been done site. This would be good to manage HTML5, Canvas Advanced Animation Toolkit, jQuery, Windows animateframe, maybe socket open. Mysql database is complete, 20-digit binary number and the database is ready, but the game on the site is not yet as a PSD file. The coin must looking good when it comes down to. The coin must move a the same way as site and the end of the multiplier must be the final effect.

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 am in need of an expert in interactive PDF creation with extensive knowledge in fillable fields, interactive buttons, and conditional logic. The PDF form must contain mandatory questions that are only visible under specified conditions. The interactive buttons should support functionalities such as form submission, form clearing, and form printing. This task is urgent and requires swift completion. Ideal Skills: - Prior experience in interactive PDF creation - Excellent understanding of conditional logic - Capable of working under tight deadlines.

I need a sophisticated Excel spreadsheet designed and developed for tracking key performance aspects of my dumper truck and excavator rental company. The spreadsheet needs to be well-organized, easy to navigate, and detail-oriented, focusing on the following elements: - Expenses: Detailed tracking of an array of expenses. The ability to enter itemized costs is a must, and other daily expenses (office, car fuel..). Also monthly expenses like rent, salaries, bonuses and truck or excavator maintenance ect. - Income: This should include a breakdown of different revenue sources. - Employee tracking: A system to input and manage each employee's work hours. - Machine rental: Documentation of the equipment rented, including the duration of rental. - Fuel consumption: Dedicated section to re...

...highly skilled freelancer who can develop an AI-based search engine tailored towards the customers and employees use for a company. The key features required for this project include: -Natural language processing: Understanding and interpreting human language effectively is crucial. -Relevance ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experienc...

...Qualification: Conduct thorough research to gather information about prospects and understand their pain points. - Lead Nurturing: Engage with leads through multiple touchpoints to educate them about Transitials value proposition and build relationships. Understand their challenges and needs to position Transitials’ services as a solution. - Value Demonstrations: Collaborate with internal teams to take up advanced stage discussions for qualified leads. Ensure a smooth handoff of leads to the sales team. - CRM Hygiene Management: Help creating a consolidated view of all the leads, activities, and interactions. Enter accurate and up-to-date information in the trackers. Track progress and update sales opportunities accordingly. - Deal Closure Push: Navigate through the interna...

I'm looking for a skilled Excel expert who can 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 recipe...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 certain items. - **Update Costs Based on Supplier Prices**: a feature that lets me update the costs of ingredients based on the supplier prices, ensuring my calculations are always accurate. The ideal candidate would have: - Advanced Excel skills - Experience in food costing or inventory managem...

... Organic Traffic Growth: Other landing pages will incorporate a blog component to enhance SEO (Search Engine Optimization) visibility. This will attract organic traffic and establish our brand as a thought leader within our industry. For this project, we require a developer with the following qualifications: -Strong WordPress Skills: Experience building custom themes, plugins, and leveraging advanced WordPress functionalities is essential. -SEO Optimization: A solid understanding of SEO best practices is crucial. You should be able to optimize content structure, meta descriptions, and technical aspects for search engine visibility. -Modern Design: An ability to create visually appealing and user-friendly landing pages that align with current design trends is highly desirable. P...

We are looking for a highly skilled developer or a team of developers to address and resolve a series of bugs across multiple software systems. The ideal candidate(s) will have expertise in Java (specifically Swing), FileMaker, Artificial Intelligence, Django, and general web development. This project involves analyzing the current issues, proposing solutions, and implementing fixes in a timely manner. Key Tasks: - Analyze existing codebases to identify bugs and inefficiencies. - Develop fixes for bugs in systems built with Java Swing, FileMaker, Django, and related web technologies. - Apply AI techniques to optimize operations and improve system functionalities where applicable. - Test fixes to ensure bugs are completely resolved and systems are running smoothly. Ideal Candidate: - Str...

I'm in need of a highly-skilled professional who specializes in Azure Security Engineering and ForgeRock Training. Key tasks include: - Azure security configuration - Conducting vulnerability assessments - Undertaking threat hunting exercises Additionally, expertise in ForgeRock training covering the following topics will greatly benefit my team: - Identity and Access Management (IAM) - Single Sign-On (SSO) - User Provisioning The ideal candidate is required to hold an 'Azure Security Engineer Certification'. This certification will give me confidence in your capabilities to successfully execute the necessary tasks. Your adeptness in handling Azure security coupled with your ability to impart crucial knowledge in ForgeRock makes you an integral team player for ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Project entails designing PCB layouts for Cryptocurrency Miner PCB Design using ASIC chips for cryptocurrency mining. Deliverables consist solely of comprehensive PCB design files, ensuring reliability, accuracy, and meticulous attention to detail.

I'm looking for an advanced Python 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 in automa...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

...Responsibilities • Use ladders as needed to enter into attics or access roofs • Use hand tools to perform cuts into drywall as needed to measure rafters in inaccessible attics • Capture photos of the electrical meter and service panels • Handle basic interactions with homeowners in a polite & professional manner • Upload deliverables to shared cloud storage in a timely manner • Conduct site surveys independently, travel from your own home Skills & Qualifications • Written and verbal communication skills in English (Spanish is an asset) in a timely manner • Customer service skills (or similar) are an asset • Strong time management and organization skills • Mobile phone with internet capability is needed to upload images on ...

...Responsibilities • Use ladders as needed to enter into attics or access roofs • Use hand tools to perform cuts into drywall as needed to measure rafters in inaccessible attics • Capture photos of the electrical meter and service panels • Handle basic interactions with homeowners in a polite & professional manner • Upload deliverables to shared cloud storage in a timely manner • Conduct site surveys independently, travel from your own home Skills & Qualifications • Written and verbal communication skills in English (Spanish is an asset) in a timely manner • Customer service skills (or similar) are an asset • Strong time management and organization skills • Mobile phone with internet capability is needed to upload images on ...

I'm looking for an experienced video editor who can bring my drawing videos to life for TikTok. Your role involves: - Editing my drawing videos for post-production - Creating engaging and trendy TikTok videos without losing the essence of the art process Ideal skills include: - Proficient with video editing software - Knowledge of TikTok trends and user behaviour - Experience with editing art-related content - Detail-oriented with creative problem-solving skills.

I'm in need of a proficient mobile app developer who can bring my envisioned design to life. The focus is to create a straightforward Android app for customers to scan QR codes on our products and readily access product specifications and download quality documents. Key Features: - QR code scanning - Document download functionality Skills and Experience: - Proficient in Android app development - Experience in QR code scanning technology - Know-how on integrating document download functionality - Strong ability to adhere to provided design Please note: There's a requirement for no monthly charges associated with the use of this app. We aim to publish this on Google Play for easy customer download. Don't worry about any extra features such as customer login/acc...

We are seeking a skilled freelancer to assist in promoting an official website by implementing redirect ads on search engine platforms such as Google and Bing. The task involves showcasing ads for the official website, let's say , in search engine results. However, it's important to note that we don't have direct access to this website. The freelancer's primary responsibility will be to ensure that when a user clicks on the displayed ad for , they are redirected seamlessly to our designated website, www.abcxyz.com. This process requires a deep understanding of digital marketing strategies and proficiency in managing ad campaigns on search engine platforms. Key Requirements: Proficiency in digital marketing and ad campaign management. Experience with Google Ads...

...facilitate the synchronization of various data between Loyverse and Odoo 17. Key Requirements: - Synchronize Products, Invoices, Credit notes, Payment In, and Payment Out data from Loyverse with Odoo 17. - The synchronization should be manually initiated, meaning there is no requirement for automation or scheduled synchronization. Additional Details: - The task will include working with the Loyverse access token to effectively extract data from the POS. - The implementation should take into account potential data duplication and handle it appropriately, either by selecting a specific period or checking for duplicate records. Ideal Candidate: - Proficient in both Loyverse and Odoo 17. - Past experience working on similar synchronization projects. - Skilled in data extraction an...

I'm in need of a competent designer with strong skills in Figma who can design a minimalist wireframe for a Web Application. The core functionalities needed are user registration and login, payment gateway, and real-time chat. Content to be factored in includes text articles, frequently asked questions, advanced search capabilities, and an admin section, which includes adding products, listing products, and an approval workflow. You should have a sense of minimalistic and modern design, and be able to showcase these skills through your past works in your portfolio. 1) Listing of Products With Workflow Status 2) Add / Edit Products 3) Search with Product Result 4) Advance Search with Product Result Key Skills Needed: - Figma Web Application Design - User Experience & Us...

I'm in need of an experienced developer who's well-versed in ASP.NET a...well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database inte...

I'm seeking a freelancer to check a PDF document using Turnitin urgently. Pays 100 INR. This task involves ensuring originality, identifying possible plagiarism, and verifying correct citations with a robust tool such as Turnitin. While I have not specified the type of document or importance of the check, the right professional for this project would: - Have access to Turnitin for checking purposes - Provide a detailed report of the Turnitin check - Have experience in academic writing, plagiarism detection and report generation Experience and familiarity with Turnitin or a similar tool will be highly considered for this project.

...etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) PASIR RIS DRIVE 10,13-30,510643,SINGAPORE • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guideline. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site visit t...

...by >>> <<< Main Features User Registration and Login: Users can register and create a profile. Secure authentication and password recovery options. Personal Dashboard: Each user has access to a personal dashboard where they can manage their offered services, view requested services, and check their credit balance. Intern Credit point System: Users earn credits by offering services and spend credits to request services. Implement a system for purchasing additional credits. Search and Filter System: Users can search for services based on categories, location, or keywords. Advanced filters to simplify the search. Review and Rating System: After the completion of each exchange, users can leave reviews and ratings for the user they interacted with. ...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

I'm seeking for a skilled system administrator with hands-on experience in Linux Ubuntu 22, Proxmax, and Cloudflare. The successful candidate will be responsible for managing and maintaining these systems. Key Responsibilities: - Linux Ubuntu 22...configuring and monitoring our Cloudflare services, ensuring optimal performance and security. Your application should include: - Detailed project proposals: I'm looking for a freelancer who can present a clear, concise plan of how they will handle the tasks and what strategies they will implement to ensure the smooth running of our systems. Communication will be facilitated through Anydesk access. If you're confident in your system administration skills and have worked with similar setups in the past, I look forward to...

I am seeking a Unity game developer particularly skilled in multiplayer development for a player versus player (PvP) real-time web session game in the Runner genre. Your tasks would include: - Create full game from the beggining. The perfect freelancer for this project should have: - Advanced Unity game development skills (5+ years). - Proven experience specifically in real-time multiplayer game creation (2+ successfull projects). - Session games (execute server per each session [1vs1]) Good reference on what we will build -

I'm looking to develop an online platform for advanced professional training courses. The courses I envision will be rich in interactive simulations and assessments. This is to ensure that the learning experience is engaging and effective. Key requirements include: - Development of interactive simulations and assessments: This is crucial for the success of the courses. - Voiceover: The course content will be delivered through voiceovers, so the creator should be adept at syncing voice with visuals and animations. - Course structure: Creating a logical and engaging course structure that effectively conveys information and encourages learning. - Embedding into current website. I have created my own website and need to the course embedded into website. Ideal skills and experi...

...credentials. This is crucial for security and access control. - Seamless Integration: Ensure that the connection between the database and the AD server is seamless and reliable. - User Management: The system should allow for easy management of user privileges, ensuring that the right people have the right levels of access. Ideal Skills and Experience: - Experience with Postgres: You should have a strong background in working with Postgres, particularly in a configuration and security context. - AD Integration: A deep understanding of Active Directory and how to integrate it with other systems, including databases. - Security Focus: The ability to set up robust security measures to protect the database and ensure that only authorized users can access it. Pleas...

I'm in need of a professional for my YouTube gaming channel. This is an ongoing, monthly contract role. Key Responsibilities: - Video Editing: Help with video trimming, cutting, adding text, captions, and color correction. - Thumbnail Design: Create custom thumbnails for each video to ensure the channel stands out and attracts viewers. - SEO Optimization: Implement advanced SEO strategies including competitive analysis and optimization. Ideal Candidate: - Proven experience in video editing, particularly for gaming content. - A keen eye for design and experience creating engaging thumbnails. - In-depth knowledge of SEO, particularly for YouTube. - Easy to work with, with good communication skills and a commitment to meeting deadlines.

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

As the backbone for increasing my sales, I need a freelancer who can help me generate quality warm and qualified leads. This includes leads cultivated through social media advertising and search engin...target potential customer segments Ideal Skills: - Proven experience with SEO and social media advertising - Strong understanding of lead generation processes - Ability to deliver warm, qualified leads The end goal is a considerable boost in sales through an increased customer base. Connect with me if you've demonstrated skills in bringing qualified leads that convert to sales. I just need 10 advanced leads, like company name, contact person's name, email or LinkedIn account for my business and if the leads are successful then the person will be given the entire projec...

I am seeking an experienced SharePoint developer to create a site primarily for document management. The three essential features of this site include version control, advanced search, and access permissions, all of which are critical to properly manage our documents and ensure smooth workflow. This project should support less than 10 users. A developer who has handled similar projects with proven successes and has proficiency in Microsoft SharePoint is ideal for this project. Your well-honed skills in understanding client needs, attention to detail, user interface design, and SharePoint workflow configuration are also requisite.

Confirmis ( ) is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to over...Take pictures of the candidate’s residential address, as per Confirmis’ standard operating guidelines. • Provide observation about the address such as the location, the building, etc • Job will only take less than one hour to accomplish (excluding travel time) REQUIREMENTS: • Must be living in (or nearby) Las Pinas, Philippines • Has a camera or phone/tablet of quality with a camera, internet access Note: Payment will be released the following week after the site visit to give us time to organize the report and contact you if we need additional ...

I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email

I am looking for an experienced Verilog developer who can work on my Verilo HDL project. Design a digital circuit for a fruit sorter based on following specification. Develop the block diagram (consists of datapath and control units) and the ASMD chart. Assume that there is a 1-bit RESET signal to reset the circuit and it is asynchronous and active low. In addition, there is a 1-bit CLOCK as the clock. The circuit will start the operation when a 1-bit input signal START is asserted. A fruit detector provides a 1-bit input FRUIT that becomes 1 for one clock cycle if banana is detected and the FRUIT signal will be 1 for two clock cycles if orange is detected. There are 2 different outputs which are OUT1 and OUT2 that will be 1 for one clock cycle for the type of fruit where...

I have an APK which is crucial for the security of my device. To prevent unauthorized deletion, I need a professional with advanced knowledge in Android development to implement an anti-uninstall feature. Key Requirements: - Implement an anti-uninstall feature that requires Root access. - Ensure the feature is discreet, and can't be easily bypassed. - Ensure the feature doesn't significantly impact the performance of the APK or the device.

I'm seeking a skilled plugin developer with a talent for creating detailed and lifelike online environments. The project involves wo..."Horse Illness" feature. This should take into account various factors such as environmental conditions, the age and breed of the horse, and interactions with other horses. Experience with AI that can account for these dynamic variables would be ideal. - Additional features involving other realistic horse behavior, such as eating and drinking. The perfect candidate for this task is someone with advanced programming skills and a solid understanding of equestrian science or a demonstrable ability to research and apply the relevant knowledge in this area. Ideally, the candidate should have previous experience in developing similar reali...

I am looking for an experienced Python developer to create a scraper for Lazada. The ideal candidate must be skilled in web scraping and should reverse engineer API from mobile app because lazada blocks and throws captcha on web website is lazada . The script should work like i enter something in search box and it should scrape all the products from that search query Key Responsibilities: - Extract the following information: product names, prices, descriptions, stock, images, seller information, and product URLs. This list encapsulates the attributes you need to pay the most attention to. - Organizing the scraped data: The data, once scraped, must be organized in a well-structured CSV file. Ideal Skills: - Strong experience with Python. - Proficiency in web scraping tools. -...