Compare select statements sql oracle työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I need ...data on a range of deregistered public companies in the US - Analytical Skills: I require a thorough analysis of the reasons for their deregistration - Financial Expertise: You will need to dissect the financial history of these companies for the past 3 years Ideal Skills: - Data Mining: Extracting and organizing relevant data is key - Financial Analysis: Understanding financial reports and statements - Research: Ability to dig deep to find pertinent information - Report Writing: You will be expected to present your findings in a coherent and compelling manner This project would suit someone with experience in corporate finance, investigative journalism or related fields. If you have a keen eye for detail and can deliver high-quality, fact-based reports, I'd like to...

I am looking for a female voice artist who can create audio stories & JOI based on very erotic role-plays and fantasies. The voice should be original & seductive, and native to Hindi or Bengali language. The ideal candidate should have experience in voice acting and storyt...teacher-student, director-heroine, secretary etc. If you are a talented voice-over artist with a seductive voice and you are comfortable with adult erotic contents, then this project is perfect for you. Rest assured that your talent will be respected with an adequate payment. This is a personal project and your work won't be published anywhere. You need to send your voice samples so that I can select the right candidate. You should also include your comfort level in doing erotic voice acting with...

I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.

...Development: Implementing the design onto a live website. • Back-End Development: Ensuring the website runs smoothly and effectively. As this will be an e-commerce website, special focus must be given to online payment processing, shopping cart system, and product listing. Knowledge and experience with these items are vital to the success of this project. The final website should enable visitors to view, select, and purchase products effortlessly. Please showcase any related work in your bid....

...Development: Implementing the design onto a live website. • Back-End Development: Ensuring the website runs smoothly and effectively. As this will be an e-commerce website, special focus must be given to online payment processing, shopping cart system, and product listing. Knowledge and experience with these items are vital to the success of this project. The final website should enable visitors to view, select, and purchase products effortlessly. Please showcase any related work in your bid....

...Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity with configuring SQL Server on Linux. - Ability to troubleshoot and resolve issues with domain attachment and site deployment on a VPS without a GUI. **Responsib...

A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.

I'm in need of a fashion designer who specializes in adult clothing. The designs should be suitable for everyday wear. Ideal Skills and Experience: - Demonstrable experience in adult clothing design - A strong portfolio showcasing previous everyday wear designs - Ability to understand and interpret current fashion trends - Knowledge of materials and ability to select appropriate materials for wearable, comfortable garments - Excellent communication skills to understand and translate my vision into a tangible clothing line.

I'm looking for an expert in Google Ads to review my account. - I'm aiming to generate more leads, so I need a thorough analysis of why the account isn't performing as well as it used to. - I need you to compare the current state of the account to a previous time when it was delivering good results. - I need you to identify all the changes that have been made to the account since that time. - I need a detailed understanding of the effect of these changes on the account's performance. The ideal freelancer for this project would have: - Extensive experience with Google Ads - A proven track record of lead generation through Google Ads - Strong analytical skills and the ability to interpret data and derive meaningful insights - Excellent communication skills to...

...subreddits: @rSlash As you can see he has just copied and pasted the original thread comment + other comments in the video. The total videos will be 10-20 minutes long. 1. User inputs link to subreddit --> scrapes everything 2. AI memorizes all the text in the tread 3. AI writes the script - a brief intro --> copies and pastes original post --> writes a brief transition statements --> copies and pastes the comments - making sure the flow makes sense and is interesting. 4. AI creates title options for the video. ChatGPT already kinda does this well (image below), but having trouble inputting large amounts of reddit and output longer text, and just trying to automate the process. Maybe there's a tool out there that can already do this out there? If you are able t...

Description: We are seeking an experienced Data Analyst to assist in a comprehensive market analysis project. The objective is to gather and analyze housing data to compare rental market trends in specific regions. This will help inform business decisions and strategies. Responsibilities: Collect housing data from multiple sources, ensuring all data is accurately gathered in compliance with all applicable laws and website terms of service. Analyze data related to rental amounts, property types, locations, and amenities. Provide detailed reports comparing market trends, prices, and available amenities. Create visualizations that clearly illustrate market dynamics. Requirements: Proven experience in data collection and analysis, particularly in real estate or similar markets. Stron...

I'm setting up a bike rental bus...business. The company will offer different types of bicycles such as mountain bikes, road bikes, and hybrid bikes. - The rental company will provide accessories like helmets and locks. - I need a professional who can create an online booking system for the bike rentals. The system should be integrated into our website. - This system should make it easy for customers to browse available bikes, select the ones they want to rent, choose any accessories they need, and make the payment. - The ideal candidate should have experience in e-commerce website development, with a specific focus on building booking systems. A background in the bike rental or similar industry would be a big plus. - I'm open to suggestions for the best approach to t...

I'm seeking a skilled professional to create a comprehensive loan statement on a...designed to be updated annually. Ideal Skills: - Proficiency in Excel is a must; the ability to handle complex calculations is highly preferred. - Previous experience in creating and maintaining financial spreadsheets, particularly loan statements, is a significant advantage. - Attention to detail is crucial to ensure all transactions are accounted for and calculations are accurate. I'm looking for a freelancer who can not only deliver on the technical requirements of this project but also has a good understanding of financial statements, particularly loan statements. Your ability to work accurately and efficiently is highly valued. Please provide examples of similar work yo...

I need a professional to create financial statements for my website in real-time. This should be presented in an interactive web dashboard. The ideal candidate should have experience in: - Financial statement preparation - Web development (dashboard creation) - Data visualization and incorporation of bar charts.

I need a very comprehensive method statement for a 155m2 construction project. I'll provide a sample, and you need ...construction project. I'll provide a sample, and you need to make sure the statement is detailed and well-structured. Key Requirements: - The method statement should be in a Word Document format. - It needs to cover all aspects of the project, with particular focus on the Excavation, Structural, and Finishing phases. Ideal Experience and Skills: - Previous experience in creating detailed method statements for construction projects. - Strong understanding of construction processes and terminology. - Proficiency in writing comprehensive content in a clear and structured manner. - Attention to detail is critical to ensure no steps are overlooked. Contact ...

...changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with handling Excel files in a cloud environment will be particularly valued. Remember, the aim here is to create an automated system that ensures no changes go unnoticed, while avoiding constant email notifications. Your propos...

...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting for accessing a...

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easily accessed and analyzed wit...

I require a highly experienced assembler who can proficiently use Emu8086 to write and verify software programs. Though the details about the specific programs weren't provided, candidates should be skillful in at least the following areas: - Arithmetic operations - Control flow statements - File handling operations The purpose of these programs has yet to be confirmed, thus a candidate with a flexible approach who can rapidly adjust to altering requirements will be advantageous. This project is urgently required, hence a freelancer who can complete tasks promptly is desired. To confirm the validity of your work, you'll also need to test the developed programs and verify the correctness of your written code by initializing and checking relevant registers and memory locatio...

I'm looking for an expert digital artist who can alter an image to create a humorous bachelor party concept. Your task will be to perform face swapping and uniform modification to make it appear as if a particular person is donning JTAC gear. Key requirements: - Ability to select an appropriate photo for the edit - Proficiency in face swapping and image manipulation techniques - Experience in photo modification towards a military theme - Detail-oriented, ensuring the final photo appears professional Please note that it is a military-themed fun project, not intended for misuse. I encourage photoshop experts with a good sense of humour to place their bids!

I require a meticulous professional, experienced in the workings of Microsoft A...Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...

Se requiere un sistema diseñado en Python que trabaje en sistema operativo Wndows, el cual a través del uso del WebCam pueda hacer reconocimiento de rostros comparando el rostro en la cámara vs el rostro almacenado en formato digital en una base de datos en SQL Server 2016+. El resultados debe ser un True o False. El sistema debe trabajar localmente (No en la nube).

Mevcutta hibrit bir uygulamamız var. Sql üzerinden veri çeken bir servis mevcut Bu projeye rapor eklenecek

Preparation of complete sets of 2024 financial statements based on the required period.

I'm seeking a professional with expertise in financial documents, specifically balance sheets and profit & loss statements. - You'd be responsible for updating these documents with new figures - no structural or comprehensive changes required. - The modification will be minor, focused on figures and data. - Your role is to maintain the integrity of the documents while reflecting the new information accurately. Ideal candidates will have experience in: - Financial accounting, specifically with balance sheets and profit & loss statements. - Attention to detail, ensuring accuracy in the modification process. - Proficiency with financial software/tools would be an advantage. Your expertise in this area will be crucial to ensure our financial documents re...

...a folder structure on your computer to organize the images by product category (e.g., Shoes, T-Shirts, Sofas). Ensure you have a stable internet connection for browsing and downloading images. 2. Finding Images on Amazon: Go to Amazon. Search for a product category (e.g., "Men's Shoes"). Click on individual products to view their detailed pages. Select images that meet the quality and content requirements. Right-click on the image and select “Save Image As…” to download. Name the file appropriately (e.g., "") and save it in the corresponding folder. 3. Finding Images on Shopify: Go to Shopify. Browse through the "Examples" section or search for specific product categories. Click on stores or products that showcase...

This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Applicants with su...

Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability f...

I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.

I'm looking to develop an on-demand service application that focuses on car services. Here are some key features I'm looking to include: - **User Registration and Login**: The app should have a smooth and secure user registration and login system. - **Service Provider Profiles**: It's important for users to be able to view and select service providers based on their profiles. - **Booking and Scheduling**: Users should be able to book appointments with service providers easily. - **Tracking**: It would be great if an in-app feature could allow users to track the status of their service requests. - ** Service Reminders: Automatic reminders for upcoming maintenance based on service history - ** Emergency Services: Provide options for emergency roadside assistance, such ...

I am seeking a professional writer who has experience in crafting personal statements, specifically for Pediatrics and Family Medicine Residency applications. The project involves helping me create a compelling personal statement that focuses on key qualities like compassion, empathy, leadership, and teamwork. Key Requirements: - Experience in writing personal statements for medical residency programs, particularly in Pediatrics , Family Medicine - Ability to highlight my compassion, empathy, leadership, and teamwork skills effectively - An understanding of what medical admissions officers look for in a personal statement - Excellent written communication skills - Previous experience or understanding of the medical field would be a plus I would appreciate a swift turnarou...

I have a simple powerbi poject. I have a dataset in excel based on which i need a table in the dashboard. I also require a filter to filter the rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can ...rows The filter should be based on 3 columns in the table. In the dataset a user can be in more than one column. for example lets say the 3 columns are A, B and C. the values can be A, B, C or blank in those columns. user X had values A, B and blank in the columns A, B and C In this case if you filter the data using value A from the dropdown, it should show user X also if you select B. However if you select value C in the filter the user/row wil...

I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...

...dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you hav...

I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.

...expenses, and depreciation based on assumptions - Balance Sheet Projections:Project key items like working capital, fixed assets, debt, and equity based on historical ratios and expected changes. - Cash Flow Projections:Derive operating cash flow from projected income statements and balance sheet changes. Estimate capital expenditures and financing activities. - Dynamic Model: - Create a dynamic model in Excel, ensuring that changes in assumptions automatically update all related financial statements. - Assumptions Tab: - Develop a separate tab to document key assumptions, ( also can use screenshots with source link) including revenue growth rates, cost inflation, capital expenditure plans etc. 3. DCF Analysis: - Free Cash Flow (FCF) Calculati...

I'm in need of a website that can cater to new users and make scheduling appointments, managing user profiles, and processing payments an easy and seamless experience. Please go through figma file for detailed flow and screens of web needed. You can select react.js or any platform that will be easier for you.

I'm in need of an experienced application developer who can build a robust database application. The application will need to provide th...application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this remains to be finalized. However, skills in handling different types of data - textual, numeric and multimedia - will be considered an advantage. Understanding of standard SQL language, knowledge with various database systems and strong problem-solving skills will be ideal for this project. Strong knowledge of frontend and backend development with user interface design skills will also greatly contribute to our collabo...

Hi, I need to extract data from some sites and compare them in a unique database. In few words i need a scraping code in python that extract data from some sites and the data have to saved in a mysql database.