Parent child tree sql querydela

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.

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush or...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I am looking for a knowledgeable and experienced researcher who can delve into the relationship between parenting styles and children's behavioral problems. Key aspects of focus should include: - The three parenting styles - internalising and externalising behaviour - Impac...styles - internalising and externalising behaviour - Impact of parental involvement and monitoring - relationship between parenting styles and children's behavioral problems A substantial understanding of the said topic and expertise in conducting similar research will be greatly advantageous. Speed is of the essence, as I require the project completed ASAP. Prior experience in Psychology, Child Development, or a related field is a plus. An excellent command of English and academic writing skil...

I'm looking for a skilled animator who can bring to life a selection of children's picture books. These videos are intended for children...animations that will captivate young audiences. - Understand the intricacies of children's book illustrations and translate them effectively into animation. - Deliver timely and polished videos that are suitable for online distribution. Ideal skills and experience for this job would include: - Proven experience in animation, particularly in a children's entertainment context. - Strong understanding of child psychology and the ability to create content that resonates with young viewers. - Proficiency in adapting existing material into animated form while preserving its essence and appeal. Feel free to send samples of your pr...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

...Where Knowledge meets Innovation near Masjid e Maaz, Millat Nagar Noori Our comprehensive online platform facilitates seamless communication among students, teachers, and parents during and after school hours. IIT and Medical Foundation from Primary classes Special remedial classes struggling students Admissions are open for Nursery to Tenth Indo embassy high school for the bright feature of you child Class rush for Admissions Special remedial classes struggling students Indo embassy high school Where Knowledge meets Innovation near Masjid e Maaz, Millat Nagar Noori Students are encouraged to offer Zuhr namaz in school, fostering a sense of gratitude Deeniyath Compulsory for All students Indo embassy high school school building is purposefully designed to cater to educationa...

I'm looking for a talented designer to create a logo for my company, Shire Group. The style should be traditional, with a color palette that includes green. It could be only green or green with other colors. Shire Group is a construction and real estate development company specializing in t...oriented to community interaction. The people who buy our homes value living in community, participating in the production of food, enjoy homesteading, appreciate historical architectural styles, and enjoy the outdoors. Many of the people interested in our homes are religious and appreciate the religious art in our neighborhoods. Some symbols that we connect with our brand: castle, tower, shield, tree, livestock, market, medieval or renaissance fonts and styles, fantasy fiction stories, ...

...comprehensive tool for tracking attendance, storing documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, etc. **Grid View and Dashboards** - Information should be displayed in a grid view with fil...

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

I run a non-profit dedicated to promoting literacy skills in young children. Our main focus is to ensure reading before kindergarten. We're in need of a skilled grant proposal writer who has experience in this field to identify and secure grants for our organization. Key responsibilities include: - Understanding our mission and target of achieving literacy skills before k...compelling grant proposal, specifically designed to secure funds for our unique focus on early reading skills. Ideal candidates will have: - Prior experience in writing grants for non-profits, preferably those related to education or early childhood development. - Strong research skills to identify relevant grant opportunities. - A deep understanding of early literacy practices and their importance in child...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle ...considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially Python...

..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

I've created codes using AI for the game doors, implementing two algorithms - Minimax and Monte Carlo Tree Search. I need a professional who can transform my work into a fully-fledged, web-based TD-Gammon board game. Key Requirements: - Bring to life the TD-Gammon board game based on my code - Integrate two AI algorithms: Minimax and Monte Carlo Tree Search - Implement an AI opponent with adjustable difficulty Critical Skills: - Proficiency in AI algorithms, particularly Minimax and Monte Carlo Tree Search - Experience in coding interactive games and board games - Ability to deliver high-quality web-based platforms Delivery: The final product should be a fully functional web-based game that accurately reflects the TD-Gammon concept.

I'm looking for someone experienced in running projects from GitHub repositories "" to assist me in setting up and running the demo-k6-operator project on my Mac machine. Your guidance should help me to understand how this project works, which is my primary goal. Key requirements: - Expertise in running and configuring projects from GitHub repositories on Mac machines - Solid understanding of the demo-k6-operator project - Ability to provide clear, detailed instructions and guidance for running the project on my machine - Patience and willingness to explain concepts to help me understand the project better The specific challenge we may face is that I'm using a Mac CPU that is NOT Intel, so experience with this kind

...and manage fee structures for different classes, including tuition fees, exam fees, and other charges. Allow for online payment processing with various payment gateways. Generate invoices, receipts, and financial reports. Communication Tools: Facilitate communication between teachers, students, and parents through messaging systems and announcements. Provide event calendars for scheduling exams, parent-teacher meetings, and other activities. Library Management: Catalog and manage library resources. Implement a check-in/check-out system. Provide search functionality for students and staff to find resources. Transportation Management: Manage bus routes, schedules, and transportation assignments. Track bus attendance and maintenance schedules. Inventory Management: Track school ...

I'm seeking a skilled graphic designer to develop a logo for my upcoming childcare center. Here's what I envision: - **Color Scheme**: The logo should prominently feature green and brown, reflecting a natural, nurturing environment. - **Imagery**: I envision the logo incorporating a tree or leaf as the central element. This will help convey a sense of growth, harmony, and safety - all important values for my center. I'm looking for a logo that's not only visually appealing but also resonates with parents and children. Ideally, it should be playful yet professional. If you have experience with childcare or education-related branding, that would be a definite plus. Experienced designers with a strong portfolio and a good understanding of brand identity are enco...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

I'm in need of a sophisticated and luxurious logo design that can effectively represent my brand across various platforms. Key Requirements: - The logo should exude an elegant and luxurious aesthetic, appealing to both adult and child audiences. - It needs to be versatile, working well on both digital and print marketing materials, as well as my website. Ideal Skills: - Strong experience in minimalist design. - Background in creating versatile brand identities. - Previous work with logos that appeal to multi-generational audiences.

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

I am looking to commission a print featuring an abstract palm tree island and a wave. The ideal candidate for this project would have the following skills and experience: - Ability to interpret and refine existing design concepts while incorporating their creativity - Keen eye for detail and aesthetic appeal Ive attached abstract prints for reference of style and colour, and 1 image of a wave and island.

Logo for my new business. The company name is "Cedar & Spirit" this is a holistic business where we connect with the client's inner spirit/self. The vibe I'm going for is healing, holistic, loving and kind. I love the look and softness of the water colour look. The cedar tree is important as it connects us with our inner self, intuition and our higher self... I have attached a few pictures for inspiration... I'd like the files in PDF, PNG, and JPEG. A copy in each: white, black, and colour (all with no background)... I'm open to fonts but please ensure they are readable if they are cursive style. please keep colours to a minimum - using only branding colours. i'd also like to see some sketch drawings... My brand colours are in an image below ...

I'm seeking a talented professional to design a comprehensive business case for my technological solution in child protection. This document will primarily be used for presenting our business to potential investors and stakeholders. Most of the content has already been compiled and available to include. Collaborating with me will be required to build out and contextualise content where necessary. Essential skills and experience for the job include: - Business case design experience - In-depth knowledge of business case requirements and necessary inclusions - Shrewd understanding of investor and stakeholder expectations - Previous work on startup projects is a bonus - Communication Your task will involve developing an investment-ready business case that effectively communicate...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I'm looking for a creative mind to produce engaging 15-second product level vide...Example of what we're looking for: Here are the products we want videos built for

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

I have a simple design in Corel Draw and need it converted to Illustrator. This includes adding a cutline around the design. - I have two designs. Very, very simple. One is the tree. The other is 400 leaves that need to be cut. - The primary task is to convert the entire design from Corel Draw to Illustrator format. - The secondary task is to add a cutline around the design. This will serve as guidelines for future cutting of the file. - You will be required to work with precision, as the cutline needs to be accurate and well-aligned with the design. - Experience with both Corel Draw and Illustrator is essential. Ideal Skills and Experience: - Proficiency in Corel Draw and Illustrator. - Attention to detail for precise cutline implementation. - Experience with simple design con...

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex ...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming l...

...- Significant experience working with SAP Cloud ALM data sources - Proven ability to provide step-by-step instruction catered to a beginner - Patience and passion for teaching complex topics in a simple to understand manner I'm eager to learn, and I look forward to your bid. Let's delve into data together and create a powerful Grafana dashboard. We have an example blog here. I will use my laptop as a test mashine, for this POC. So that is where we will be working. So we have to work on a shared screen, where you guide me what to do, to make it work. If you are not ok with this, then

...map renderer for creating an overhead map. The purpose of this map is visualization and analysis over a few acres. While I don't have a preferred software tool for the 3-D rendering, I encourage the use of a tool that best matches your expertise, such as SketchUp, AutoCAD, or 3ds Max. The map should have medium detail, capturing major landmarks and features without the need for detailing every tree or building. This includes topographic elements, key structures, and significant landscape features. Ideal Skills and Experience: - Proficiency in 3-D rendering software (SketchUp, AutoCAD, 3ds Max, or similar) - Experience realizing medium-detail overhead maps - Understands the balance between level of detail and clarity for visualization and analysis - Ability to deliver high-...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm in need of a talented UI/UX designer who can create a layout similar to the CDC Milestone app for both iOS and Android platforms. Key Requirements: - Proven experience in designing engaging and interactive user experiences - Strong understanding of Apple's and Google's design principles and ...high-level requirements into beautiful, intuitive, and functional designs - Excellent communication and collaboration skills to work with the development team - Experience in designing educational apps is a plus, but not required Please note that the focus here is on creating a similar layout to the CDC Milestone app. This project does not involve the creation of any content or features specific to child development. The goal is to replicate the app's layout and stru...

As you know, Magento displays the lowest priced simple product associated with configurable products. we want the price of a specific child product to be shown. There are modules designed for this, known as configurable preselect, but I couldn't get it to work. Although there are settings in the module for category or listing display, the preselect feature that works on the product detail page does not work on the category page. Can you solve this problem?

I would like to update this theme in Hugo to make a website look like the one below. The homepage would list all folders in the parent directory under content and then click into the subdirectories showing the md files of each respective category. It’s a very well done website and I’m having a hard time making the theme work exactly as they have it. I believe the theme is out-dated and needs to be update. Here is the theme I want to implement: Website I want to mimic: