Sql query find child parent items table jobs
Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.
i need to find wordpress plugin and make integration to my website with below detail. reservation system 1. hourly base reservation as we always work at night, today as ours is starting from 5pm until 4am next morning 2. duration (how many hours) and number of people per reservation when request reservation 3. able to post only limited rooms to online (we will make availability with only 3 salas out of 7 salas on online) 4. back end, admin has no limit to post reservation even out of open hours 5. Admin (Backend) able to move reservation hour or reduced / extend duration 6. clients can't change reservation after confirmed or can't cancel 7. reservation status showing either by color or text (sala unassigned/arrived/left) 8. able to work with stripe (payment method : c...
I need to convert my word document into a fillable PDF document. This is a template for continence assessments. The person using the document will need to be able to input information into text fields, tick checkboxes, and select from dropdown menus. The converted PDF does not need to retain the original layout but the order of the items must stay the same. Ideal skills for this project include: - Proficiency in Adobe Acrobat or similar software for creating fillable PDFs. - Understanding of form design and user experience. Please let me know your experience with similar projects and how you would approach this task.
...brake). The ideal candidate will have: - Experience selling to the automotive and industrial manufacturing sectors - Know related product importation process, import duty, custom clearance, local transportation - Homologation if any - A strong network and knowledge of these regions - Familiarity with the specific products, their applications, and market demands Your role will involve selling these items to your local customers, establishing a steady sales channel for my products in these regions. Let's collaborate and create a mutually beneficial partnership. I also have sponge product with a super nice price. Or you have some exsiting channel, I could provide your local products. Or another way around, I become your Chinese local sales channel. This is not one-time coop...
I am seeking a passionate video editor to create a compelling 30-second video ad for the upcoming release of my game. The main aim of the video ad is to promote the new rele...Utilize the gameplay clips I've taken to create a high-energy, captivating narrative. Ideal Skills and Experience: - Proven experience in creating video ads, particularly in the gaming industry. - Proficiency in video editing software and techniques. - Ability to understand and cater to the preferences of hardcore gamers. I'm looking for a freelancer who can bring fresh and creative ideas to the table, and deliver a high-quality video that will drive interest and excitement for the new game release. I have the video clips ready just need someone to mimick the style of this enshrouded ad
I am looking for a highly skilled developer to create an AI image generator capable of creating images for clothing items. The aim is to provide unique designs for various clothing items including T-shirts, Hoodies, and sweaters. The AI should not be limited in its creativity and the generated designs should span multiple themes including Abstract, Cartoon characters, Nature patterns, and more. Key project requirements are: - The AI should generate images on T-shirts, Hoodies, and sweaters. - A vast array of style/theme options must be incorporated. - The image resolution must be high (300 dpi), formatted as PNG. Ideal candidates should have experience in AI programming, graphic design, and an understanding of clothing design. Poting your previous works relate...
I'm in need of an experienced designer to create a retail space for my clothing store that specializes in wedding dresses. The overall look and feel of the space should be elegant and classic. Key items is to find a way to design with being in a very limited budget,. need a welcome desk area need a seating area need an area that we need to use for photo of the bride purchased the gown. enhance current area for fittings. can move or build more dress hangers. using curtains as elements is an option using greenery and other plantery is an option. re location items is possible. need 3d rendering the pictures are in the order of entry to the store al the way back to the fitting area. Key Requirements: - The design should be luxurious and timeless, appealing to ...
It's time for an essential task: looking for an experienced freelancer who can single-handedly generate leads for medical supplies. I'm focusing on three indispensable items: masks, gloves, and sanitizers. These supplies are high in demand and we need to constantly keep finding new distributors. Key Details Needed: - Contact information, including full name, phone number, and email - Physical location - Company name Ideal Profile: - Our ideal customers are wholesale distributors. Experience in this segment is a significant plus, and any knowledge or connections in the medical supply industry are warmly welcomed. Skills and Experience: - Proven lead generation record - Strong understanding of the medical supply industry - Excellent communication skills for collecting con...
Project Title: "Customer Order Management System" for an online retail business in MS Access. Objective: To develop a comprehensive database system that allows for efficient tracking and management of customer o...Generate sales reports by date, product, or customer. - Inventory level reports. - Customer order history and patterns. Instructions: Based on the given information do the following: 1: Create a DFD using Visual Paradigm. (Note: we have worked on VP in class) 2. Choose Entities 3. Create ERD based on the entities chosen 4. Create tables/files for each entity 5. Enter minimum 3 records in each table. Read the Key Features to create Columns/Fields in the tables. 6. Create ERD inside MS Access and join the tables based on the ERD 7. Create min 3 queries using...
I am seeking a talented video ad creator to help promote a specific luxury car model, ...Details: - The video must creatively emphasize the luxury and comfort the car offers, showing it as an appealing choice for business professionals. - The storyline, graphics, and aesthetics should all contribute to an elegant, luxurious ambiance that reflects the quality and comfort of this car model. Ideal Skills: - Experience in creating high-quality video advertisements, especially for luxury items - Ability to curate a video ad that communicates luxury and comfort - Knowledge of the luxury car industry and its target customers - Great storytelling abilities that can captivate the target viewers and persuade their buying decisions - Strong understanding of how to appeal to business prof...
I am seeking a talented video ad creator to help promote a specific luxury car model, ...Details: - The video must creatively emphasize the luxury and comfort the car offers, showing it as an appealing choice for business professionals. - The storyline, graphics, and aesthetics should all contribute to an elegant, luxurious ambiance that reflects the quality and comfort of this car model. Ideal Skills: - Experience in creating high-quality video advertisements, especially for luxury items - Ability to curate a video ad that communicates luxury and comfort - Knowledge of the luxury car industry and its target customers - Great storytelling abilities that can captivate the target viewers and persuade their buying decisions - Strong understanding of how to appeal to business prof...
...consumers to view menu options, order meals online, and make reservations seamlessly. Key features of the application: - Menu Display: Should allow customers to easily browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous wo...
More details: Our projects starting price is $4000 to $10000 for website development clients (Realestate, Wellness, Clinic, Coaching) you need to find people who can afford and buy this service
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. ...criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate, and provide it as well. Start the search from most recent and search backwards in time. Once you find 30 sea-related records, you can stop (+ include a link to the last record you searched).
...expressions, capturing nuanced emotions such as smirking and pensiveness among others. - Platform: Though the primary deployment platform isn't specified, a PNG format that can openly be edited and used across varied platforms is required. Ideal Skills: - Graphic Design: Expertise in designing refined, elegant, and vibrant PNG emojis. - Creativity: Ability to bring intuitive and refreshing ideas to the table. - Attention to detail: Capability to capture and design nuanced facial expressions accurately. A proven track-record on similar projects or in creating personalized emojis will be highly beneficial. This project demands a keen eye for detail and a knack for understanding and channeling emotions into graphic design. If this intrigues you, place your bid and let's ...
I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.
I'm in urgent need of a logo for my company that deals in household items. I'd like the logo to be primarily in a dark purple color. Key Points: - The logo should be simple and professional, reflecting the nature of my business. - Ideally, the design will incorporate a house symbol (though I'm open to other suggestions as well). Experience: - Previous experience in designing professional logos is necessary. - Knowledge of color psychology and branding. I need this completed as soon as possible, so prompt availability is a plus. Looking forward to seeing your ideas!
...Please bid only if you're willing to work with me live via zoom. *** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, par...
I'm looking for a removalist to help me move 15 cartons from Melbourne CBD to a storage facility in Ringwood. The job is pretty straightforward, no need for additional packing materials, just transporting the boxes and putting them into the storage unit. K...Melbourne CBD to Ringwood - Put all the boxes into the storage unit Additional Information: - No stairs involved, the apartment has elevator access - No requirement for packing or unpacking assistance, just need someone to follow the instructions and lay all the boxes in the storage Ideal Skills and Experience: - Experience in removalist or moving services - Reliable and careful in handling delicate items - Familiarity with Melbourne CBD and Ringwood area Please provide your quote for the job and indicate your availabil...
...create a unique yet timeless space. Lighting and Color Scheme: Develop a sophisticated lighting plan that complements both daytime and evening settings, along with a color palette that enhances the room’s architectural features. Furniture and Decor: Select and arrange furniture that reflects the dual-style theme while ensuring comfort and quality. Include recommendations for artworks and decor items that enhance the overall design theme....
I am currently battling cancer and going through chemotherapy. I have recorded some videos and need a skilled video editor to help me with the post-production. The goal is t...Strong portfolio of editing projects, preferably with experience in social media content. - Ability to add effects and transitions creatively, in a way that's appealing to a young adult audience. - Empathy and understanding of the sensitivities surrounding cancer is a plus. - Understanding of social media algorithms and best practices for engaging content would be highly beneficial. I hope to find a compassionate professional who can help me share my story in a compelling and engaging way. I will need someone that can help me long term and edit for things to be put on instagram shorts, TikTok and even...
• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finan...
...follows: - The color scheme should predominantly be a mix of deep blue and black, with the option of using midnight blue as well. - The art deco style should be based on geometric shapes, symmetry, and abstract motifs. Please ensure that the design is sophisticated and not cartoonish or childish. - The font used in the logo should be simple and elegant. I have attached several examples of logos that I find visually appealing in this regard for reference. need to be in also in pdf, vector. Ideal Skills for this project: - Experience in designing art deco style logos - Proficiency in using a color palette of deep blue, black, and midnight blue - Ability to create a design that is both sophisticated and visually appealing - Strong typography skills for creating a simple and elegan...
I have a physical part for a radio that I need to be 3D modeled for printing. The item is a simple part with basic shapes, so the complexity is relatively low. Key Requirements: - Create a 3D model suitable for 3D printing based on the physical part provided - Design should be simple with basic shapes, ensuring it's ready for printing - P...format that is compatible with most 3D printers Skills and Experience: - Proficiency in 3D modeling software, particularly for 3D printing applications - Experience in reverse engineering or replicating physical parts into 3D models - Understanding of designing simple parts with basic shapes - Ability to deliver high-quality designs ready for 3D printing Please include any relevant portfolio items or previous experience in similar projec...
...dependability. This color could be used for the hand, enhancing the feeling of security and professionalism. Orange: A soft, cheerful shade of orange that contrasts with the blue, used for the medical symbol to inject vitality and warmth into the design. Usage: The design’s simplicity ensures broad versatility across digital and print mediums, maintaining clarity and impact whether scaled down for small items like business cards or enlarged for banners and signage. This logo effectively balances a casual yet professional aesthetic, making Hanai Medical appear welcoming and trustworthy to both medical professionals and patients, true to its core values of care and inclusivity....
I'm in need of a versatile and comprehensive ERP system specifically tailored for a jewellery store. This system will need to be compatible with both Windows and Mac operating systems. Key Features: - Inventory Management: A robust tool to manage my stock of jewellery items, including tracking and updating inventory levels in real-time. - Sales and Order Management: A seamless system to handle the processing of orders and managing sales records effortlessly. - Customer Relationship Management (CRM): A centralized platform to store and manage customer information, with a focus on providing personalized and exceptional customer service. - POS & Credit Management: An integrated point of sale system that also incorporates credit management functionalities. - Finance Management...
... we have some events that we want to target with Geo fencing - about two events per month We have creative done for several ad sizes, but no video yet. We have a graphics person on staff to provide additional jpg ads as you request, and are willing to pay for video ads. We also will provide headline and description ideas, but you will also have to use some of your own knowledge and testing to find the right mix of messaging for conversions. Conversions mean people buy our product which is legal drafting through , such as AI drafting a lawsuit for $49. We have accounts set up, but no ads running as of now. You must have significant experience In managing these Types of campaign and will be expected to convert sales to remain our partner. We are looking for someone to manage t...
...to use the exact colors from the images. Pay attention to the fonts as well, use the fonts you see in the images, also use the silly phrases if you see one... for example "Beach Bum" If we are doing a christian collection and are doing a product giveaway for a beach collection you may want to use "Bible & Beach Bum". Something like that. Here are some inspiration items, if you already use Printify please come up with some items based on this faith and beach scenario as an example. It is easy to upload files in Printify after designed like the images i shared with you. **If you see a name on a picture do not use the name, Put something like Faith or ask me eventially for top selling phrases....
...in these aspects of security to ensure the entire system is robust. - Ability to identify and address firewall misconfigurations: This is of particular concern, given the specific issues I'm looking to address in the network security. Your role is to simulate various hacking attempts and identify any potential weaknesses in the system's security. This includes: - Conducting penetration tests to find vulnerabilities in the network, applications, and data security. - Specifically, identifying and correcting any firewall misconfigurations to ensure our system is well-protected. Ideal candidates should possess: - Proven experience in system security testing. - Strong understanding of network, application, and data security. - A track record of successfully identifying and...
I'm looking to have a virtual wardrobe we...outfit recommendations based on the user's inventory. Key Requirements: - Outfit Suggestions: The website should be able to provide personalized outfit recommendations. This will include suggestions for different occasions and mix and match ideas. - Clothing Inventory Management: The system should allow users to manage their clothing inventory. This may include adding, modifying, and deleting items from their virtual wardrobe. Ideal Skills: - Experience in developing websites with outfit recommendation systems. - Strong background in front-end and back-end development. - Knowledge in database management and integration. I'm open to discussing the specifics of the project with interested freelancers, so feel free to reac...
(Please check the PDF ) We require a 3D escape room level designed in Unity with a simplistic approach. The main objective is to collect three items to unlock a door. The design should incorporate interactive elements such as sound-triggered hotspots for item collection. The document it’s in 2 languages Spanish and English
I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data import/export mechanisms would be advantageous. Moreover, an understan...
I'm in need of a de...Key features of this project include: - Extraction of table data: You should have knowledge and experience working with web data extraction, specifically with table data. - Selection of stocks data: The script should have the ability to select and extract information from the stock table. - Capability for multiple companies: The tool should be versatile to handle data extraction for multiple companies, not limited to just one. Experience in the use of n8n for data extraction from websites, especially in the finance sector, will be a significant advantage for this project. One of the page is: And the table is in the "premium" div. The credentials will be provided to the selected freelancer. The table looks lik...
I'm in need of an interior designer with experience in modern design aesthetics who can completely transform my living room and dining area. My preference is for a neutral color scheme with whites, grays and browns being the prominent tones. Key Elements include: - A medium sized and mpressive dining table, as I often entertain guests - A comfortable seating area that promotes relaxation, chats, and comfort. - Media Wall - Maximization of natural lighting - an aesthetic that capitalizes on light will be highly favored - Incorporation of features like a console, mirrors, wall art, center rugs, a media wall, and sofas with accent that combine style and utility. Special Attention should be paid to: - Nice, lush curtains that complement the modern aesthetic and enhance the spa...
I'm looking for a skilled marketing expert to increase the member count of an established Discord server. With more than 500 members, the server is to buy or sell your ingame items or accounts. Key Tasks: - Brining Organic members who will buy or sell accounts . - Engaging these targeted individuals with compelling and persuasive techniques. - Successfully growing the member count of the server. Ideal Candidate: - Previous experience with Discord and its functionalities. - Strong understanding of mobile gaming communities. - Proven record in successful marketing and member growth strategies. - Ability to effectively engage a targeted audience.
I'm in need of a skilled cartoon illustrator to bring my children's book to life. The target audience for this book is young children, specifically those in the 0-3 years old age range. Key Requirements: - Style: I'm looking for a vibrant, engaging and child-friendly cartoon style for the illustrations. The images must be bright, colorful and easy for young children to understand and enjoy. - Quantity: I require more than 10 unique illustrations, so the ability to maintain consistency in your style across various scenes and characters is important. Ideal Skills and Experience: - Proven experience in creating high-quality children's book illustrations, particularly in a cartoon style. - A strong understanding of visual storytelling and how to engage a very yo...
When button clicked, the field of another table will changed to required. Only FTP no cpanel
Design and implement one page website. The website shall have a design similar to...libraries or APIs. Something like bootstrap + vanilla JS would be ideal, or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server that h...
I am offering source codes for 26 unique Android games ready for purchase. Having developed these games, I can guarantee their quality and potential. Potential buyers, such as a budding game developer or a gaming company, would find this extremely beneficial. Ideal Skills and Experience: * Familiarity with Android Game Development * Profit-oriented mindset * Interest in code acquisition * Game re-skinning capabilities would be a plus Since I missed out on detailing game categories and project timeline, I'm open to discuss these and more at the prospective buyer's convenience.
...examples is provided in the json format. We plan to have 1000 entries in this json at least. The database includes: Photo (each person will have at least one phone), name, birthday, occupation, transaction table, ... (please see the json file). Animations: when a user scrolls down new information block appears. Layout: The page should start with a photo of the person and a name on the left. See the attached file. In the middle of the page should be a table with trasactions, use a component from react here (or other possible framework): DData for the table comes from the json file. Please add in the bottom after all information from a user sign: Need more info come to us. Please add 2024 to the end of the page. The website should be mobile and
I have a google sheet with 400 exercises. I need to copy them all over to a notion document with a slightly different format. Here is the google sheet — https://docs.google.com/spreadsheets/d/1SCYzmyfXgZfhu4TFkBi0YQzbXjrzl4O-hVyZZ1eo1HQ/edit#gid=0 Here is the notion table (I will provide access to edit) — I need all of the videos from “Jen’s Exercise Demos” copied over with the name, the video url and the howToTips into the correct columns. All of the videos are vimeo links so should have “vimeo” selected in the videoType column Many of the tips have multiple number bullet points, I need there to be 2 lines between each bullet point, as demonstrated in the example rows. Equipment and
...tasks for my project. Although I chose to skip specifying the exact functionalities, the developer should anticipate working on tasks such as: Work on 45 pages, each very simple. There are 3 main page features: 1. View table from DB 2. Create new record in that table 3. Edit record in that table Most the pages are the same, just a different table. A few tables have some other functionality but it's all very easy. All html design has been done already, you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Techn...
...number Parent email Next appointment date Medication needed Patient / kid user Should arrive at the login page Once logged in should have a dashboard page listing Navigation should allow them to enter a games page, info page listed at the top A welcome card welcoming the firstname + lastname on the dashboard page Info page should list the details of what is on file Patient number Patient first name Patient last name Parents first name Parents last name Assigned Doctor Notes from doctor Date of birth Parents contact number Parent email Next appointment date Medication needed Parent user Parent users should arrive at the login page and use the same login details as a normal patient . If the tick box whic...
Only FTP will be provided. Link 1 column with another table. and amend existing API only
I'm looking for a talented designer to create a comprehensive brand guidelines document for my real estate company. The primary goal of this project is to ensure consistency in our brand representation across all platforms. Key Deliverables: - A detailed brand guidelines document: This document will serve as a blueprint for our brand identity to be shared with partners, ensuring that ...guidelines for companies - Strong understanding of visual identity, color theory, and typography - Ability to interpret and translate brand values into visual elements - Experience working in the real estate industry would be a plus, but not a necessity. The successful candidate will play a key role in shaping how our brand is perceived in the market, and I'm excited to see what you can bring ...
Please Sign Up or Login to see details.
...WordPress WooCommerce migrate to SHOPIFY * Current site * PHASE 1 $500: SHOPIFY TEST SITE 1. Please purchase the template under my account. 2. Banking will been updated once completed 3. Every page you see on needs to be transferred to Shopify. Shop products and menu items are already there. SHOP page products wasn’t done correctly so need to redo. (Please note that there is a custom WooCommerce child product “Swarovski detail” pop up with ability for user to select a custom design on their main product which needs to be implemented). Go to > click on Swarovski and you’ll see what I’m talking about. There are accessories that are meant for each style. Please upload them accordingly
...tasks include: - Creating 20 distinctly designed Instagram posts - Designing 10 seamless Instagram carousels All designed content must be original - no templates are allowed. Designers have to submit 1 demo post before we award the project. We will also need the source files/editable that are used inside the poster or carousels. The posts and carousels will highlight my store's top-selling items, seasonal promotions, and new arrivals. To drive customer engagement, each design must include catchy call-to-action buttons. You will have the freedom to use your content inside designs. Key Objectives: - Increase brand awareness - Drive traffic to our website - Promote new whisky releases Target Audience: - Whisky enthusiasts - Men aged 30-50 - Regular social media users Id...
...business. I currently own the domain, so I need someone that can take my ideas and turn them into an engaging digital storefront. Key Features: - Shopping cart and checkout functionality for customers to make smooth and secure purchases. - Customer reviews section to allow for feedback and to build trust with prospective buyers. - Advanced product search and filter to help customers navigate and find exactly what they're looking for swiftly. - A dedicated offer page to frequently update customers about sales, deals or new product launches. Skills & Experience: - Proficient in creating minimalistic and clean designs. - Proven experience in developing e-commerce websites. - Strong understanding of user-experience design for mobile and desktop. - Familiarity with creating...
