Sql query find parents child 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). --------------...

Task is to include all these pages to the first footer area same style as they currently are on our live site 1. Remember to bring all these theme customisations to inside child theme folder - if this is correct way to work. 2. This modification is only to be done to the main template and the frontpage-template that you created. I want you to create these footer links (shown below) to the second lowest blue footer. These links needs to be nicely located and they need to be responsive with the theme as they are now at Kiinteistönvälittäjä Espoo POINT THIS TEXT TO > önvälittäjä Kiinteistönvälittäjä Helsinki > önvälittäjä Kiinteistönvälittäjä Jyväskylä > https://...

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

Firstname lastname company email City

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 ;)

Buy broken macbook pros Fix Resell

I'm looking for a Laravel expert to integrate Google Sheets into my system. Specifically, I want to connect it with a form on my site for seamless data handling. I have an html form php file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when ...file on my server (built in laravel). I would like a passcode (no username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data...

I'm seeking a software-based solution that will help me bypass facial biometrics without the need for the individual's physical presence. With split cam program The site to be worked on. What is required is to find an idea or script

I'm Brendah Awuor, the founder of the Awuor Support Initiative based in Uganda, dedicated to uplifting underprivileged children through education. Today, I'm reaching out to you with a heartfelt plea to support three remarkable children - Alice Alyeko, Ben Otim, and Emma Mukutu - in their educatio...can make a tangible difference in the lives of Alice, Ben, Emma, and countless other children across Uganda who deserve the chance to thrive. Your generosity will not only transform individual lives but also contribute to the collective growth and prosperity of our society. Thank you for considering supporting our cause and being part of our mission to make quality education a reality for every child, regardless of their background. With gratitude, Brendah Awuor Founder, Awuo...

I need an experienced data entry person to perform research on Twitter(X) for crypto/stock twitter influencers/posters with over 1,000 followers who make predictions on crypto/stocks. @CryptoCapo_ is one example of a desired crypto influencer account. I also want you to find stock and crypto prediction Substack accounts, there is no subscriber minimum. It is your job to find other similar accounts and make a spreadsheet with two sheets, one for twitter and one for substack. the twitter sheet will include the twitter handle and the link to their profile for each account. The substack sheet will include the link to the main substack page, the number of subscribers, and whether the substack is free or paid. if the substack is paid, please have different columns for the differ...

I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Your prompt attention to this ...

...a definition of a flowchart e.g. the intended flowchart is attached file It creates an image file of the flowchart. Simple example: See attached file The text file has 3 lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general it is. The above is just to show what I mean. 1. You could provide the flowcharts that some app allows you t...

... Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Ability in RESTful API development and OAuth security practices. - Excellent problem-solving skills and ability to work effectively in a team environment. Education and Experience: - Bachelor’s or Master’s degree in Computer Science, Software Engineering, or related field. - At least 7 years of full-stack development experience, with a focus on complex cloud-based solut...

Looking for a short Video Clip, not longer than 10 Seconds. We need a perfect Transition to present our Shirt Design. You decide the Intro and create a perfect Transition to show our final Shirt in a final Sequence. Attached you will find the Design and the Shirt you can usw for the Clip and final Outro ourLogo. If you need any Sequenze with the Shirt, just let us know, we try to create it. LONG TERM JOB CONTRACT IS POSSIBLE . Here are a few Ideas: 1. Turbocharger Transition Description: The image of a turbocharger appears as if it is being shot out of a vehicle. The turbocharger spins, and as it rotates, it transforms into the final image on the shirt. Animation: A fast, rotating motion that simulates a "boost" effect, transitioning the graphic from blurry to ...

I am seeking a skilled web developer to create a dedicated real estate we...information (photos, descriptions, amenities, rental terms, etc.). Interactive Listings: A "React" button under each listing allowing users to express interest in a property. Upon clicking the "React" button, the user's interest should be sent directly to our email, including details about the specific listing and the user. Search Functionality: An intuitive and easy-to-use search option for users to find properties based on various criteria (location, price range, property type, etc.). Filters and sorting options to enhance the search experience. Admin Dashboard: A backend dashboard for managing listings, user accounts, and tracking user interactions. Ability to add, edit, and de...

I'm looking for a logo designer to create a playful and fun logo for , an advertising platform aimed at helping girls find jobs in the adult industry. The ideal logo style should be playful and fun, while still maintaining professionalism. It should appeal to our target audience - women looking for job opportunities in the adult industry. Key points to consider: - The design should be bright and vibrant, to attract attention and make a statement. - The logo should include a symbol related to the adult industry, whilst remaining tasteful and not explicit. - The design needs to be modern and unique, setting us apart in this competitive market. - The end result should be a memorable and professional logo that represents our brand effectively. Skills and experience in creating

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ...features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations shoul...

...e-commerce potential. Key Points: - The domain is ideal for e-commerce purposes, which makes it a great opportunity for someone in the online sales space. - I'm particularly interested in connecting with individual entrepreneurs, small to medium businesses, and potentially large corporations who are searching for a domain that fits an e-commerce website. I'm looking for someone who can help me find potential buyers and close the sale. This job will require: - Strong networking skills and an understanding of the e-commerce industry. - Experience in domain sales or similar areas. - The ability to identify and connect with potential buyers in the specified categories. If you have experience in these areas or believe you can effectively market this domain to the right ...

I'm in need of a grant application specialist to assist with a government grant application. This grant is meant to support our operational costs. Key Responsibilities: - Find and apply for grants application - Ensuring all necessary documentation is included - Submitting the application within the specified timeline - Ensure the grand payout Ideal Candidate: - Proficient in grant writing, particularly with government grants - Experience with operational cost grants is a plus - Excellent attention to detail to ensure all necessary documents are included - Strong communication skills to ensure smooth submission process All the necessary documents are prepared so you can dive straight into the application process. Looking forward to your expertise in securing this grant for o...

I am in need of a research professional to conduct an in-depth study into nursery and early child learning centers. Specific areas of focus should include: - Curriculum and teaching methods for children aged 2 to 4 years. - Parent involvement and communication strategies used in these settings. The purpose of this research is to identify current best practices in these areas. Given this, the ideal candidate will have experience in education research, specifically within early childhood settings. Knowledge in curriculum design, early childhood development, and parent-teacher engagement strategies are a crucial requirements for the task.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sourc...approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for ma...

...available on both iOS and Android platforms. Key Features: - User Profiles: Users should be able to create and maintain profiles showcasing their work and experience in the movie industry. - Push Notifications: The app should feature push notifications to keep users informed about job opportunities and industry news. - Search Functionality: A robust search functionality is crucial for users to easily find relevant job postings. Ideal candidates should have experience in app design, particularly in developing user-centric and intuitive interfaces. Knowledge of job portals, or similar platforms, will be an added advantage. Your work will directly impact the careers of budding movie industry professionals, so a keen eye for detail and a passion for the entertainment industry will ...

I'm in search of a proficient freelancer who has expertise in utilizing MATLAB R2021a for complex Image Processing tasks. As my requirements are quite specific, it is crucial that the preferred candidate has in-depth knowledge of this software and can make the most of its advanced features. Key Responsibilities: - Conduct comprehensive Image Processing tasks - Utiliz...R2021a - Significant experience in Image Processing - High problem-solving skills using MATLAB Given the specificity and technical nature of this job, candidates who can showcase samples of their previous work with MATLAB, specifically in Image Processing, will be prioritized. This is an opportunity for seasoned MATLAB users; those with a more superficial understanding of the software may not find this pr...

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

Description: We are looking for a highly skilled and motivated frontend developer to create a cross-platform desktop application for Windows and MacOS using Electron.js. The application will man...including: A brief introduction of yourself and your experience relevant to this project. Examples of previous projects or similar desktop applications you have developed. An outline of your approach to this project, including your development process and timeline. Your availability. Any additional skills or experiences that make you a strong candidate for this role. We are excited to find a talented developer to join our team and bring this project to life. If you are passionate about web & desktop application development and meet the requirements above, we would love to hear from y...

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...

I'm starting a new children's clothing store, and I need a Shopify store built to cater ...infants (0-2 years), toddlers (2-5 years), and kids (6-12 years). We will be dropshipping, using Printful. Key Project Requirements: - **Design Style**: The store needs to have a playful design. It should be visually engaging and appeal to children and their parents. - **Functionality**: One of the key functionalities I need is a size guide. Ensuring customers can easily make the right size choices for their children is paramount. Ideal Skills: - Experience with Shopify and building e-commerce stores. - A good eye for playful and child-friendly design. - Previous experience with children's clothing stores would be a plus. Please provide examples of any similar projec...

I'm looking for a creative and skilled logo designer to help me create a logo for my online toy shop, Discovery Play Palace. The ideal logo will be: - Colorful and vibrant to appeal to children - Simple and easy to recognize - Reflect the educational and learning theme of my shop -...and learning theme of my shop - Available in all required formats for various applications Please consider the following in your design: - It should encompass toy animals, which are the primary products in my store - The name 'Discovery Play Palace' should be clearly integrated - The design needs to be versatile and scalable I'm looking for a creative individual who has experience in creating child-friendly designs and logos for educational purposes. Your portfolio should include...

I need a talented social media influencer to create compelling content and promote my new cushion range on Instagram and Facebook. Key Details: - Ideal influencers would have a following made up of parents, home decor enthusiasts, and home owners. - The ultimate goals are to increase brand awareness, drive sales, and encourage user-generated content. Required Skills: - Experience as a social media influencer particularly in the home decor sector. - Proven track record of successful promotions and sales generation. - Strong content creation and audience engagement skills. - Familiarity with Instagram and Facebook platforms.

...2-Adult-breeding-egg (Each species has its section without mixing) 2.1(Adult)Male-Female-Add adult-Edit 2.1.1(Male)List with data of each Male 2.1.2(Female)List with data for each Female 2.1.3(Add adult) Cover data (Name-sex-date of birth-genetics-terrarium) 2.1.4(Edit) Be able to edit adults or delete 2.2(Crias) Add-Edit-List 2.2.1.2 the same as adults but without sex 2.3(Eggs) Add-Edit-List 2.3.1 (Add) Select parents from adult list - Laying date...

Hi, I am looking for someone to help me with courier delivery plugin for Botble Laravel CMS. 1) Technical tasks for the delivery person part - I need to add the role of the delivery person (name, phone number, passport photo (2 photos), text fields for biography, login and password) - so that he can log in to his account via login password. - When a customer orders goods, the admin must assign delivery to a certain deliveryman (list of deliverymen) that he delivered the goods to the client and should be the delivery status (picked up the goods, on the way, delivered, canceled). - Deliverer should see how much what goods delivered, new ordered goods (from admin) - notifications of new orders in telegram bot for deliverymen 2) Inside the product in each article should generate a barcode, ...

...analysis, probability, and betting systems to provide valuable insights on betting odds. The particular sports/esports of interest are Football, Basketball, Cricket and Counter-Strike: Global Offensive. The detailed responsibilities are: - To provide one/two sure shot (can be multi) odd everyday with 1.5 odd minimum - Analyze real-time and historical stats for Football, Basketball, and CS:GO to find out possible outcome - Draw insightful inferences - Suggest betting strategies based on the analyzed odds - Provide regular reports and updates on the competitive odds in the market The ideal candidate will have an analytical mindset, strong mathematical skills, and a comprehensive understanding of the mentioned sports. Prior experience in sports/esports betting analysis is highly...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

...secured a location where I aim to establish a comprehensive soft play and swimming area. The site is all set to accommodate both indoor and outdoor arrangements for the little adventurers, aged between 0-8 years. We are looking at creating an engaging, fun, and safe environment for toddlers and pre-schoolers. Ideal Skills And Experience: - Proven experience in designing and implementing child-friendly facilities - Understanding of safety regulations and standards pertaining to kids' play areas and swimming pools - Expertise in utilising space effectively to cater to both indoor and outdoor activities Your Role: - Come up with creative ideas for the play area and swimming pool layout - Ensure safety standards are met at every step - Help design areas that are...

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

I'm in need of a skilled Social Media Manager with a knack for e-commerce SEO and driving traffic. Key Responsibilities: - Managing and growing our presence on Facebook, Instagram, Etsy, and other platforms. - Implementing SEO strategies that are geared...should have a solid understanding of the following: - Social media management and growth strategies, especially on Facebook and Instagram. - E-commerce SEO and its unique challenges. - Experience in increasing brand awareness and boosting engagement. - Proven track record in driving quality traffic to websites. Our target audience spans a wide range, covering key demographics such as Millennials, Parents, and Business Professionals. Understanding and reaching out effectively to these groups will be critical to achieving the...

...skilled UI-UX designer to overhaul the design and experience of our existing cashback and coupons website. The target audience for our platform consists of tech-savvy individuals and budget-conscious shoppers. The improvements we're looking for are: - Enhanced navigation: The current website's navigation is not smooth and as intuitive as we'd like. The new design should make it easier for users to find what they need without much effort. - Modernized visual design: Our platform needs a fresh and appealing look that resonates with our audience. This includes updating the color scheme, typography, and overall visual aesthetics. - Improved user-friendliness: The user experience on our site needs to be seamless, efficient, and enjoyable. We aim to retain our current...

I'm looking to create a Facebook ad campaign to find a missing person last seen in a public space. This project calls for a strategic approach to deliver the message across all relevant audiences. Key requirements include: - Compelling Ad Copy: The ideal freelancer should have strong copywriting skills, able to craft engaging and compassionate text that effectively communicates the urgency of the situation. - Targeted Outreach: Experience in defining and reaching specific demographic groups on Facebook is key. They must optimise the campaign to maximise visibility, specifically for those located in the same area as the public space where the person was last seen. - Customer Engagement: They need abilities to handle potential leads, answer inquiries and, importantly, coordin...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

...trading stocks business through a dynamic and engaging social media campaign. Key Requirements: - Proficiency in Instagram, Twitter, and TikTok, with a proven track record of success on these platforms. - Experience in increasing brand awareness, driving website traffic, and generating leads and conversions. - Understanding of diverse target audiences, especially young professionals, stay-at-home parents, and small business owners. Your responsibilities will include: - Crafting and executing a comprehensive social media strategy that aligns with our business objectives. - Creating captivating content and managing our social media accounts with consistent and engaging posts. - Monitoring the performance of our social media campaigns and making data-driven optimizations. - Coll...