Sql query tree childrendela

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

- poslovna inteligenca na Microsoft tehnologij tako on-premise kot v Cloudu - Programski jeziki: DAX, MDX, C#, TSQL, SQL, python, spark

Potrebujemo programerja za občasne dodelave v okolju Microsoft dynamics CRM, office 365 z bazo Microsoft SQL. Plačamo po urnih postavkah.

Izdelava aplikacija (za začetek working verzija - brez avtomatskih in EndToEnd testov) za prikaz: -Drevesnih struktur iz sql tabel -Logiranje -Shranjevanje aktivnosti na drevesnih strukturah -Poročila -Komunikacija med uporabniki Več v priloženem PDFju. Gre za osebni projekt - ne predstavljam podjetja.

I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.

I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v...  4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs.    NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal   6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...

I'm seeking an experienced and passionate 2D animator who can bring to life an engaging children's cartoon filled with adventure, comedic moments, and educational themes. The project is targeted at children, but should still be appealing and entertaining to a broad age range. Key Responsibilities: - Create and deliver high-quality 2D animations. - Contribute to story development and artistic direction. - Translate and infuse educational, comedic, and adventurous themes into creative animated sequences. Ideal Skills and Experience: - Proven experience in 2D animation. - Prior work on children's content, preferably cartoons./freshers are also welcome - Solid understanding of storytelling, pacing, timing, and character development. - Knowledge or experience with ...

I'm looking for a talented Photoshop expert to help me with a family portrait. Key Requirements: - Children are not looking at the camera or smiling, the editing should make them do so. - The background should be kept as is, without any changes. - this will be a large print so hires is required Please ensure that you have experience with portrait editing, particularly working with children and ensuring realistic and natural expressions. Your skills should include: - Advanced Photoshop skills - Experience in portrait editing, specifically with children - Strong attention to detail - Ability to create natural and realistic expressions Your ability to understand and replicate the desired expressions in a way that looks genuine and unforced is crucial for this pro...

...author to create an engaging book targeted at children aged 0-3. The primary goal of this book is to introduce basic vocabulary in a fun and interactive way. Key requirements: - Target Audience: 0-3 years old - Educational Goal: Basic vocabulary I'm specifically looking for a writer who can craft engaging, age-appropriate content. It should be not only educational but also enjoyable for young readers. I'd like the book to be written in prose, so I'm seeking someone who excels in this writing style. Ideal skills and experience for this job include: - Proven track record in children's book authoring - Proficiency in creating educational content for toddlers - A deep understanding of how to engage and retain the attention of very young children - Expe...

Milestone for the translation of the story "The Princess Sophie" to "La Princesa Sofía" in simple US standard Spanish language, suitable for children readers.

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

Create a JS-based WYSIWYG Editor integrated into WordPress Website run a WordPress-based website that is a UGC (User Generated Content) platform. I want users to be able to format their blog posts before publishing. WordPress core and TinyMCE are too heavy and too expensive respectively. I want to implement the same functionality of TinyMCE 7 (free version) via custom code in...para below/after every block - Noneditable: Like I mentioned we have some buttons to insert specific content. This content could include shortcodes, embeds, and various things that are plug and play, no need for user to edit. So, once added we want them to non-editable by user. They can backspace it to remove it, but can't as such change it. So, perhaps a CSS class that makes the div and all its children...

I need a ...time, drop off location - Every day 3 buses are departing to airport. Say morning 8am, 1pm and 8pm. We need to get auto emails based on this bus timings of scheduled pax list and they take manually report with date/time filter. Ideal Skills: - Strong background in web application development - Experience in booking system or related is a huge plus - Fluency in database management, preferably SQL - Proficiency in PHP or a similar back-end programming language - Strategic problem-solving skills and attention to detail The success of this project requires not just technical expertise, but also a clear understanding of travel agency operations and the importance of efficient booking management. If you have relevant experience and the right skill set, I look forward to...

Description: We are looking for a creative and skilled illustrator to collaborate on a unique children’s workbook designed to teach financial literacy concepts to children aged 5-8. This project will involve the creation of vibrant and educational illustrations to engage young learners in understanding money management, earning, saving, and spending through interactive activities. Project Objective: Our aim is to produce a 50-page workbook that not only educates but also captivates and motivates young readers. The illustrations will be critical in making financial concepts accessible and fun, helping children visualize and understand the lessons effectively. Illustrator Responsibilities: Collaborate closely to grasp the educational goals and content of the workbook. D...

I'm hiring for the creation of captivating and fun cartoon-style illustrations of an Indian family, primarily featuring the mom and children in various scenes related to cooking, eating, and enjoying food. A significant part of the project includes: • Illustrating in a cartoon style that would appeal to children. • Creating artwork to be used for commercial purposes. • Developing characters with emphasis mainly on mother and children, engaging in various activities revolving around food. Ideal candidates should have experience in creating kid-friendly, cartoon-style characters, and understanding the cultural nuisability of Indian family dynamics. A portfolio that demonstrates the ability to create a diverse selection of engaging and delightful c...

I'm currently in need of an experienced full stack developer who is proficient in both JavaScript and PHP. Key requirements: - Strong skills in front-end development, specifically using JavaScript. - Proven experience in handling backend development with PHP. - Knowledge of SQL is also important. - While not a strict requirement, familiarity with JavaScript frameworks such as React, Angular, or Vue and PHP frameworks like Laravel or CodeIgniter would be a big plus. - Experience with SSL implementation is a must, but there are no strict preferences as to the type of SSL to be used (Wildcard or EV SSL). Being able to pick the right SSL depending on the project’s needs will be part of your responsibility. If you're the kind of developer who is adept at managing the f...

...illustrator with a creative eye and excellent technical skills who can provide an artistic and visually stimulating experience for kids. This storybook is one in a series and the layout and text already have been created. The ideal candidate will bring the animals to life through a biologically correct rendering of them with a bit of “personality”. The target audience for this storybook are Vietnamese children ages 6-12. As such, the illustrations must capture the imagination of young readers. Although the animal characters are the main theme and focus of the book, the illustration style should also render an accurate portrayal of the forest habitat in which the animals live. If you possess the perfect blend of artistic talent, creativity, and passion required to bri...

...walk-in wardrobes and ensuite bathrooms, toilet must be separate from the bathing and shower area in all rooms including guest rooms, and all bedrooms to have a separate study room, must have a staircase leading to the other floors from the rear of the property also a staircase from the rear leading directly to the roof but must have lower floor guard on the staircase to prevent intruders and children from accessing without permission. Master bedroom must have His and hers walk-in wardrobe, his and her bathroom, male bathroom to have a urinal Master Room Master bedroom must have His and Her’s walk-in wardrobe, one large bathroom with all the regular amenities 2x toilets in a separate compartment attached to the main bathroom, one large emperor bed, bed frame should be wal...

...time a change is detected. Freelancers with experience in creating similar systems or possessing a deep understanding of the workings of Windows OS will be preferred. Additional Details: Monitor Regedit for the changes related to the policies applied through Service. Send notification to server, send mail to a group, in case of change not applied through Service. 7. Logs needs to be updated to SQL via a API POST call (this endpoint is developed you need to call this Only) and keep a backup at local database. POST JSON - { "Username": "", "MachineName": "ABC", "Timestamp": "", "appliedPolicies": [ { "Policy1": "0", "Policy2": "2" } ], "removedPolicies": [ { ...

I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...

I'm looking to add to our production some outstanding and engaging elements by hiring a sound and light technician for our children's theater performance. - Current equipment: We already have a spotlight, par lights and other lighting equipment. - S...performance will involve more than 25 child actors in each cast but only 6-8 will have individual mics. Ideal experience and skills for this role would be someone who has prior experience with children's theater and is comfortable in operating modern lighting and sound equipment, QLab, and managing the complexity of a large performance cast. I invite you to contribute to our cause of educating children through engaging narratives. Specific dates needed, May 11, May 15 & May 17-18 about 36 hours total for set up...

I'm looking for a skilled logo designer to evolve my current logo's graphics and ...The existing logo design is of an olive; I'd like it to be transitioned into an olive tree. While maintaining the design's integrity, I desire a color change as well, shifting it to black and white. I appreciate freelancers with a keen eye for color theory and logo transformations. Key requirements: - Expertise in logo alterations without losing original essence - Adequate experience with black and white image design - Strong skills in color theory, preference given to those with proficiency in transitioning colors - Ability to modify fonts and shapes of logos The final product should beautifully blend the original's features with the requested alterations, resulting in...

...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the r...

I'm looking for a skilled C++ software developer to create a software on a esp32 which talks to a nrf24 module. The Software parts can be taken from the Github directory: I need only the functionality which can be seen on the pictures in the code. All the web and network stuff can be ignored.

I am an aspiring writer and I need 10 one-sided illustrations for a children's book (cover included). I need aspiring artists, preferably children,so they can use this project as a real work practice, as my whole budget is only 20 pounds of sterling or so

I'm launching a brand new enterprise and am in need of a logo. I'm specifically looking for a style that appeals to children. Key Requirements: - The logo should be creative and engaging. - It must have a child-friendly appeal. I'm on a tight deadline and need this project completed as soon as possible. Ideal Freelancer: - Prior experience designing logos for children's brands. - Able to work in a fast-paced environment. - Creative thinker with a flair for child-centric design.

...for jobs, and managing profiles and portfolios. - Build an admin portal with role-based access for monitoring user activity, managing complaints, and generating reports on job listings and user satisfaction. Preferred Tech Stack: - Front End: TypeScript framework with Server Side Rendering (React.js or Vue.js for web, React Native or Flutter for mobile) - Back End: Utilize GCP services (Cloud SQL, Cloud Functions, etc.) - Payment Gateway: Midtrans Indonesia. This work is going to be divided into 6 major stages, corresponding to 6 milestones: 1. Planning 2. Designing (Software design) 3. Developing 4. Testing 5. Implementation & Integration 6. Maintenance Details upon each stage will be discussed through online meeting If you're passionate about creating innovati...

I'm in need of an app designer for my iOS/Android app. The app is a simple kids education app, aimed at children aged 6-13. The core feature of the app is the quiz questions part and should be interactive. In total i need 1 - starting page UI - 2 setting UI - 3 - help page UI - 4 quiz page UI. Its a minimalistic app and user friendly. I have a drawn a sketch and will give you idea examples. I trust you expertise and you can choose the right colors and theme. You should have experience in designing educational apps, especially for children. An understanding of child psychology and what makes an app appealing to this age group is highly desirable. A portfolio that showcases a similar type of project would be a huge plus.

As an energetic entrepreneur, I am interested in starting an eBay re...do extensive product research across different categories. - Product Categories: The researcher should cover diverse eBay product categories including electronics, clothing and accessories, and home and kitchen items. The objective is to identify popular and profitable items for reselling. - Target Market: The research should comprehensively cater to a broad audience including men, women, and children. The product selection should reflect this inclusivity. Ideal Skills and Experience: - Experienced eBay seller or reseller - Deep understanding of eBay's user demographics and pricing strategies - Proven track record in product research and market analysis - Strong analytical skills with the ability to interp...

I am on the lookout for a full-time governess with significant tutoring experience for an ten-year-old child. Responsibilities: - Primarily, the candidate will be responsible for tutoring. Qualifications: - Proven tutoring or teaching experience. - Must have at least 4 years of experience as a Governess or/and Teacher/tutor - Must...candidate will be responsible for tutoring. Qualifications: - Proven tutoring or teaching experience. - Must have at least 4 years of experience as a Governess or/and Teacher/tutor - Must have EU passport or residency - Must speak english fluently - Teaching background is a huge plus I look forward to receiving your applications. The ideal candidate is someone who is passionate about education and children, and can create a nurtu...

I need to integrate Tableau with my SQL database, and I'm looking for a skilled freelancer to handle this. Key Responsibilities: - Setup Tableau integration with SQL database - Ensure seamless connection and data flow between the two - Deliver a functional, user-friendly interface for data visualization Ideal Skills: - Strong experience with Tableau and SQL - Excellent understanding of database management and integration - Ability to create interactive dashboards - Proficiency in optimizing data for Tableau visualization This project will require a keen eye for detail and a commitment to delivering a quality, tailored solution.

AI ENTRIES WILL BE AUTOMATICALLY REJECTED! No need for mockups just the plain design. I'm looking for a designer who can create an attractive, modern premium label for a carbonated soft drink that will be appealing to both children and adults. The soft drink is orange carbonated soft drink like fanta. The package is 0.5L PET bottle. Ingredients and barcodes can be placeholders. Key design elements should include: -Premium Design - Incorporation of our brand logo (Lower text premium water can be removed and logo can be made white). - A section for nutritional information - Inclusion of engaging, eye-catching images Graphic designers with experience in packaging and FMCG are preferred. A portfolio showcasing similar projects would be highly beneficial. Creativity and a keen e...

I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...

...and the following slogan written at the bottom below the roots: “Perfect English. For everyone.” V2 Tree similar to attached Photo 2. But with these changes: the leaves will be more fat and lush and very densely populated like the leaves in attached Photo 3. And the roots will be thicker and more 3 dimensional like the roots in Photo 3. “EnglishTree” written under it and the slogan “Perfect English. For everyone.” written at the bottom. V3 Similar to attached Photo 4 with with the following written below it: “EnglishTree” and the following slogan written at the bottom: “Perfect English. For everyone.” V4 Similar tree shape as attached Photo 5 but the tree will be similar to Photo 2. The tree wil...

The main idea of ​​the project is stories for children. Story information, pictures and voice recordings can be uploaded from the admin panel of the application. This information will be kept on the Firebase platform. Since it is kept on the Firebase platform, pictures and sound recordings will be cached on the user's own phone or saved as a file, so the server will not be occupied unnecessarily on the Firebase server side. Registration etc. for end users. It will happen too. There will also be Ads management within the application, and if the user becomes premium, then the ads will be removed. You can contact us for detailed information. The application will be on both platforms (Android & iOS).

I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm currently experiencing some problems with SQL Server 2019 regarding a synchronization error in my Snapshot Replication model. Present issue: - Synchronization process follows an error. Desired solution: - Ability to correct the synchronization errors to allow for smooth data replication. Ideal Skills: - SQL Server 2019 expertise - Solid understanding of Snapshot Replication model - Proven experience in troubleshooting synchronization errors. I'm seeking assistance from someone with these expertise, who can provide a quick and efficient resolution to this problem.

I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...

...Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`....