Sql query find child parent items table 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 skilled developer who can assist me in creating a basic function within OpenAI's ChatGPT. This function will retrieve a number from a table, aiding me in my AI related tasks. Key Requirements: - Create a function within ChatGPT that can extract a specific number from a table. The table will be structured similarly to the example provided in this video: Ideal Skills and Experience: - Prior experience working with OpenAI's ChatGPT or similar AI assistants. - Strong programming skills, particularly in Python, which is the language used to interact with the OpenAI API. - Knowledge of data manipulation and extraction from structured data sources, like tables. - Ability to understand and implement the requirements specified in

I'm looking for a skilled Shopify developer to build a modern and minimalist online store. Key Requirements: - The main focus of this store will be fashion items, so it's crucial that the design and layout are geared towards showcasing these products effectively. - It's important that you have a good understanding of e-commerce best practices, particularly in relation to fashion retailing. Ideal Candidate: - Experience with Shopify design and development is a must. - A strong portfolio of previous e-commerce sites, especially those in the fashion industry, would be highly beneficial. - A keen eye for design and a good understanding of modern, minimalist aesthetics would be a big advantage. Please get in touch if you have the experience and skills to take on this p...

Looking for a skilled developer to assist with configuring Apache Kafka for a distributed messaging system. I have running zookeeper, kafka-server and kafka-connect. the project requires: 1) configure kafka source connector for receiving a Json and store it on a topic. 2) configure a kafka sink connector for storing the json data into a PostgreSQL table 3) guidance for installing the plugins 4) setup the connectors over kafka-api the kafka server will be running on ubunut 24.x without a docker Ideal Skills and Experience: - Familiarity with Apache Kafka platform - Experience in distributed messaging - Strong problem-solving skills - Attention to detail We are eager to work with someone who is able to provide solutions promptly and efficiently.

I'm looking for a talented designer to create a vibrant and eye-catching flyer that promotes an upcoming HSC Music Workshop. The flyer will primarily target parents of high school students, so it should be engaging and appealing to them. Key Requirements: - The flyer should be colorful and vibrant, in line with the style I envision for ...understand and breaks it down into checklists and formulas that ensure students can tackle any question Natalie Claire Woodcock is an experienced high school music teacher with a thorough knowledge of the HSC Music 1 course. She regularly attends teacher training workshops to extend her HSC Music teaching strategies and resources. Pizza lunch and afternoon tea provided Location: Engadine $62 per child Limited places available (put this text n...

Looking for someone proficient to create the design of my book. It is a book like a workbook or photo album. Book size: A5 (148 x 210 mm) The book consists on: - Introduction - Table of Contents - 100 activities. One activity per page (please see the example attached) - Quotes that intersperse the pages - Conclusion PLEASE READ - PLEASE READ - PLEASE READ Start your proposal with the budget and delivery time

Add new table to store existing order. (No CRUD, just save) Work with ftp only. Freelancer who can follow only. Additional work, additional pay

I am in need of a Programmer who is experienced in Python, Machine Learning , SQL and have working knowledge of full stack development. We need someone who can help us training a LLM coding assistant. You would not be working on coding side of LLM, you would be working mainly on creating conversations for a programming problem to train LLM. Ideal Skills and Experience: - Proven expertise in Python programming and Django framework - Hands-on experience with Scikit-learn library for model training - Demonstrated knowledge and experience in Machine Learning and AI Model Training - Working knowledge of ReactJS & NodeJS If you think that you fulfill above criteria. I would be more than happy to talk to you.

Add new table to store existing order. (No CRUD, just save) Work with ftp only. Freelancer who can follow only. Additional work, additional pay

I'm looking for a talented designer to create a vibrant and engaging flyer for an upcoming youth event. Your primary goal is to ensure the flyer is eye-catching, appealing to the target audience of youth and teenagers. The style should be energ...appealing and energetic designs INSTRUCTIONS: Please use the following text: Sutherland Shire Children’s Choir (use logo text) School Holiday Program Tuesday 16th July 8:30am - 3:50pm Ages 4 - 16 Singing activities Music activities Music games Outdoor games Craft activities Mini performance for parents at the end of the day Pizza lunch and afternoon tea provided Loftus Community Centre $62 per child Limited places available (put this text next to QR code) PLEASE REFER TO INSPIRATION DESIGNS ATTACHED PLEASE USE OTHER PICS AT...

I'm looking for a skilled mechatronic engineer who can help me develop a custom food vending machine. This machine, based on my concept, should primarily cater from frozen food to food made ready to eat. Key requirements: - The machine should automate the vending process. - It must be designed to store and dispense the specified food items. -I require design drawings, 3D models, and a fully functional vending machine prototype sample machine As my vision is quite specific, it's important that you have experience in working on similar mechatronic projects. Your expertise in robotic arm control, sensor integration, and automated assembly will be pivotal in bringing this idea to life. If you feel you have the skills and experience to make this project a reality, I'...

I'm looking for a sales partner to help me sell branded electronics, clothing, and home goods on my online shopping platform. Key Responsibilities: - Selling our branded products to your network or target audience - Promoting our items in effective ways to boost sales - Providing excellent customer service to ensure customer satisfaction You will receive a 5% commission on every sale you make. All payments will be processed within 24 hours of the item being sold. Please note that we currently do not offer international shipping, so you should focus on customers within our shipping region. Ideal Candidate: - Experience in sales, particularly in the e-commerce sector - Strong communication and negotiation skills - Good understanding of the branded product market - Ability...

I am in need of an individual to assist in extracting email addresses of all child care centers and compiling them into an Excel spreadsheet. Key project details: - Purpose: The extracted email addresses will be used as part of a contact database. - Usage: The contact database will primarily be used to offer services or products to these child care centers. Ideal skills and experience: - Proficient in data extraction and Excel spreadsheet handling. - Ethical data practices - the extraction must be legal and compliant with GDPR and any other relevant regulations. - Previous experience in email extraction or database creation would be a definite plus. This project will require a keen attention to detail and the ability to ensure accuracy in the data extracted.

...professional who can install and configure Metin 2 game server files on a BSD system. The successful completion of this task will involve the integration of various features including: - User Account Management: The system should have a robust user account management system that ensures player data is securely saved. - In-Game Purchase System: I need an in-game purchase system that allows players to buy items and upgrades within the game. - Leaderboard Integration: A competitive aspect is essential for player engagement. I need the freelancer to set up a leaderboard system within the game. I'm expecting the project to be completed as soon as possible, hence the need for a freelancer with experience in setting up similar game servers and systems quickly and efficiently. It&...

...goal is to identify key media contacts who could be potential affiliate partners in driving traffic and audience to our website Your task will involve internet research to compile a list of media outlets with high traffic websites, significant relevance to our industry, and an active social media presence. As a prospector, not only would you help identify these valuable media resources, but also find ways to schedule online meetings for our closure. For each affiliate partnership our closers finalizes, a reward of $2000 is in place. homepage with trailer and documentary free Ideal skills for this job will include: - Experience in forensic internet research - Proficiency in lead generation and outreach - Exceptional communication skills for scheduling meetings

I'm in need of an R Programmer skilled in time series analysis, correlation and regression. Your task is to analyze a dataset and find correlations between various weather variables. The aim is to forecast future trends, identify patterns and relationships, and make predictions that are precise. Your responsibilities will include: - Analysing and making predictions about specific variables such as temperature, precipitation, and wind speed. - Applying time series analysis to establish forecasts for weather patterns. - Understanding and interpreting relationships between different weather variables using correlation and regression techniques. The ideal candidate should have significant experience with the R programming language and a strong understanding of statistics and f...

I am in need of a skilled scriptwriter to create a YouTube script that will focus on a comparison theme. The script should be primarily focused on being entertaining, making effective and engaging use of the comparison topic. Key Requirements: - The main topic for the script is comparison. The script needs to be able to effectively contrast different items/topics to create an entertaining video. - The script should compare items from the following categories: Products, Services, and Ideas. The ability to create witty and engaging comparisons is therefore essential. Ideal Skills and Experience: - Proven experience in scriptwriting, particularly for YouTube or other video platforms. - A strong understanding of what makes content entertaining and engaging. - Excellent communi...

I am seeking an expert in Wix website development to create an engaging online store for my numerous art products. This e-commerce platform will primarily focus on selling my diverse art range. Key Responsibilities: - Design an attractive and user-friendly online store on Wix. - Instil options to categorize and ...Ensure the website is optimized for search engines. Ideal Candidate: - Proven experience in Wix website design, particularly e-commerce. - Knowledge in SEO principles. - Ability to work with a multitude of products and categories. - Great attention to aesthetics, understanding the niche nature of the products being sold. - Prior experience in working with websites selling art or similar creative items would be an added advantage. Style: I am looking for Zillow type...

...management software - Customer relationship management (CRM) software If you possess the above skills and have previous experience with these integrations, please place your bid. Thanks! — — — — — UPDATES: We pre-purchased Spocket, DSers, and Zendrop. We want to use a pre-built theme so we can manage everything ourselves. We like the Enterprise theme, but we're open to suggestions. We want 100+ items added to our store. - products must be popular/trending and well-reviewed - shipping must be under 1 week (on average) - suppliers must be well-reviewed and reliable We want everything to be as automated as possible. We want to sell globally. We're starting with Shopify, but we also want to sell on Am...

...- Ability to follow design guidelines and coding standards - Strong communication skills and ability to understand and translate requirements. - Since the game converter 3d file tools only recognize from format file .MQO, candidate must understand how to operate 3D Application such as Metasequioa ( ) Understanding our term of product: 1 Golf Clubset Product consist of 4 items such as 1 file for wood, 1 file for iron, 1 file for wedge, 1 file for putt and 1 file for preview in game shop (that consist of wood/iron/wedge/putt) so you need to provide me with this 5 different 3d file+texture in JPG format In this project post, I also attach example of .mqo file that can be used as baseline to create the club design (position, variable/parameter name later on when design

I am seeking an experienced editor or writer who can dig into the first three chapters of my novel. The manuscript is a mystery ro...manuscript is a mystery romance set in contemporary times, with the overarching theme of love. Here's what you need for this job: - Proficient in the mystery and romance genres - Exceptional in providing constructive criticism on plot, characters, continuity and overall theme consistency - Able to deliver detailed feedback in a tactful manner - Understand and enjoy contemporary settings in novels Find your way through my characters' twists and turns while helping me deliver a compelling, believable love story. Help me kick off this tale of mystery and romance on the right note. Your input will be invaluable in shaping the depth and directio...

...existing API for streamlined reservation management. • A minimalistic yet attractive design. • A customizable layout for future adaptability. - An admin side with full report of all data added, this data need to be filtered by data or by user that have added the reservation - in registred user are must be able to see his full list of reservation that he have added Also, it is critical for me to find someone who can locate and source appropriate content and images for this booking page. Ideal Skills And Experience: • Proficient in WordPress development. • Experience in API integration. • Good eye for visually appealing, minimalistic design. • Proven ability to source and select relevant content and images. • Experience in building event book...

Are you a passionate digital marketer with a proven track record of driving sales? Do you want to make a real difference in people's lives? We're seeking a skilled freelancer to promote a life-changing book, "Anhedonia Survival Guide", designed to empower individuals struggling with anhedonia. What is Anhedonia? Anhedonia is a debilitating condition that robs people of the ability to experience pleasure. Our book, "Anhedonia Survival Guide", has already proven its value in the market with strong digital sales. We're looking to expand its reach and impact even more lives. Here's what we offer: A highly impactful product: "Anhedonia Survival Guide" is a proven resource that provides hope and practical strategies for coping with anhedoni...

I'm in need of a talented designer to help me create my wedding stationery items. I would like the designs to be modern and minimalist in style. We already have key design elements used in our save the date and invite, we just need help with pull-through in different deliverables. Key Requirements: - Design of Table Number Cards, Seating Overview, Menus, Name Cards, Welcome Sign (for welcome drinks and wedding), Weekend Itinerary, and Swag Bag Welcome Note, Napkins, - Modern and Minimalist Design Aesthetic using elements we already have designed Ideal Skillset: - Proficient in Graphic Design Software - Experience with Wedding Stationery Design - Strong Portfolio of Modern and Minimalist Design Styles Please submit your bid with links to relevant work samples.

...improvement in some section - more detail can be discussed. Programming language is using Visual C++. Key points to develop: - change development logic of game bot single player (without using Bot Ticket) - change all the wording of broadcast (if any) from other language to english language - change some of item configuration that can boost exp/pang that's hardcoded in the code into some soft config table that can be administered by game admin. - Client-side app development : key points to develop: 1. Create a simple yet interactive Game Client Launcher that can check the latest update game file, start game and perform new player registration system. More detail can be discussed. 2. Gacha & Guild Management (Client-side app) : In-Game Built-in system already have Gacha ...

I'm seeking a highly skilled fullstack developer who is proficient in PHP, .NET, and especially SQL for diverse web application projects. Your primary role will be equal focus on both front-end and back-end development on multiple platforms, including WordPress and PHP. Mandated Features: * Database Integration - Structuring, optimizing, and ensuring smooth functioning of databases within applications. * API Integration - Implementing third-party APIs comprehensively. Ideal Skills and Experience: * Proficient in PHP, .NET, and SQL. * Strong experience with WordPress. * Proven full-stack capabilities. * Expertise in Database and API integration. * Good problem-solving abilities and attention to detail. We're expecting high quality work with minimal supervision....

...workplace. The implementation will be split between the administration panel (HR) and the employee mobile app. 1. Administration Panel (HR) 1.1 Adding Fields to the HR Panel Three new data boxes will be added: latitude, longitude and area. These fields will be incorporated into the user data entry form in the HR dashboard. 1.2 Database Update Three new columns will be created in the database users table to store the geolocation data: latitude: Stores the latitude of the work location. longitude: Stores the longitude of the work location. distance_radius: Stores the distance radius allowed for marking a point. 1.3 Modification of PHP Code Only the PHP file responsible for inserting data into the database will be modified due to existing restrictions in the panel. Validations and ...

Andriod app to run on android tablet , the tablet device is connected to a display TV screen . The app shall contain 4 main items, each item linked to a specific video. Interaction 1: 4 icons on the main screen when clicking on each icon, it shows the linked video on the TV screen. Interaction 2: Option A: Image recognitions, 4 image reference to computer vision and a video animation linked to each image. Option B: Trigger via QR code instead of image recognition. When the user show the reference to the camera, it shall trigger the video linked to this image on the TV screen. The app also should contains an AI chat assistant, with saved info about each item of the 4 items. Please contact only after ready with your proposal of delivery time and cost.

I am seeking an experienced developer to deploy my web application. Details: - The web application is built using JavaScript Node.js - The preferred hosting platform is Amazon Web Services (AWS) Key Skills Needed: - Experience with JavaScript Node.js - Experience with AWS - Strong understanding of web application deployment I am expecting a seamless deployment with minimal...application is built using JavaScript Node.js - The preferred hosting platform is Amazon Web Services (AWS) Key Skills Needed: - Experience with JavaScript Node.js - Experience with AWS - Strong understanding of web application deployment I am expecting a seamless deployment with minimal downtime. If you have the needed experience and skills, kindly submit your bid along with any relevant portfolio items. ...

I would like to modernize this page: The website is written in basic HTML. I would like the content to remain exactly the same (including a table), but to use modern technology so that it would be displayed well on various mobile devices. In principle, the colors and style should also remain the same.

I'm seeking an OCR expert to extract data from scanned tables in PDFs for analytical purposes. Key Requirements - Data Extraction: You should be able to efficiently extract table data from scanned PDFs with accuracy. - Formatting: The extracted data needs to be formatted into an Excel spreadsheet for easy analysis. - Language: The tables are in English, so proficiency in English is a must. Ideal Skills & Experience - OCR Tools: Proficiency with OCR software/tools, and experience in extracting data from scanned PDFs. - Data Management: Good understanding of data management and formatting, particularly in Excel. - Accuracy: Attention to detail and accuracy are crucial to ensure the extracted data is error-free. - English Proficiency: Strong command of the English languag...

...here should shows the names of directed referral members and the numbers of all three stages referral members. $30 Button Members names Numbers of referral of three stages Ahmad Direct referral, sub referral members, sub referral(just numbers) Ali 3, 5, 10 Three is five is ten is Direct referred referred referred by three by five Zakir 4, 6, 8 Omar 6, 12 20 ➢ For example In the above table Zakir has four(4) directed referral and the four members invited six(6) more members which are sub referrals for Zakir and the six members has invited eight(8) other members. ➢ A member can invite unlimited members, but when the numbers of referral(direct and undirect) reach to six hundred the members gets salary of this stage which is depend on level cost, the salary is sendin...

Small task: I need a solution for D2. Currently the formula is: B2 * C2. If there is no value in B2 or C2, there is still value 0,00 appearing. I need a new formula: If B2 or C2 is empty, then D2 must also be empty. If there is B2 and C2 given, then the value B2 * C2 should appear. It tried with IF(ISBLANK) but I wasn't successful: **expression is faulty**

...correspondance en fonction du numéro de facture, facilitant ainsi la concordance avec les comptes clients spécifiques. Intégration et lettrage directs : Une fois les extraits traités, le module intègre les données directement dans la base SQL, générant des références de rapprochement et facilitant le lettrage. 1- Intégrer le fichier à traiter : • Récupération automatique des extrait bancaires déjà reconnus dans sage à partir de son paramétrage • Dans le dossier d’extrait bancaire ??? 2- Lui donner un nom précis dans un paramétrage ou on a déjà le nom 3- Créer une table de correspondance : &bu...

As the one leading this project, I'm looking to create a social networking mobile application. The primary feature of this app should be a robust and user-friendly messaging system. With this app, people should find communication easy and efficient. Therefore, I need someone who not only excels in mobile app development but also understands user experience and interface design. Below are the ideal skills: - Experience in developing social networking applications - Proficiency in user interface design - Knowledge of user experience (UX) principles - Experience in building messaging systems for apps If you have these skills and think you're a good fit for this social networking app project, I encourage you to place a bid.

I'm seeking a creative content writer to craft compelling product descriptions for a range of fashion items. This task demands a flair for storytelling and strong knowledge of fashion terms and trends. Ideal skills for this project include: - Strong copywriting skills - Experience in fashion writing - Ability to write concise, engaging content - Proficiency in English Your primary role will involve transforming bland information into powerful content that can impact consumers' purchase decisions. Therefore, it's key to have a thorough understanding of target audiences in the fashion industry and the ability to write in a manner that appeals to them.

...enhance my Parent Company's policy and processes on IT asset management, with particular focus on the documentation process and IT Asset Management Workflow diagram (From registering the asset to retiring the asset). Key deliverables: 1. Provide a document that lists all relevant terminology for IT Asset Management, including formal definitions and simplified definitions. These definitions must be aligned to Parent Company's terminology. 2. Provide a diagram that explains the desired lifecycle of IT Asset Management and how Cybersecurity, ICT Operations, Data office and Business Unit fit into this flow via clear RACI. This must aligned to Parent Company's lifecycle descriptions. 3. Complete an excel based GAP analysis of desired Asset Management sta...

I'm seeking an experienced web developer to create an e-commerce website for my online clothing store. Key Requirements: - Build a platform that is primarily focused on selling clothing items - Ensure seamless integration with a specific payment gateway for smooth transactions Ideal Skills & Experience: - Proven expertise in e-commerce website development - Experience with payment gateway integration - Knowledge of current web standards and trends in e-commerce - Proficiency in UX/UI to ensure an engaging, easy navigation for customers. This project calls for a professional who can deliver a robust, secure, and efficient platform to drive my online sales. Your technical input and suggestions are also welcome to add value to the project.