One to many relationship 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.

Issues Stock with quantity 0 still able to make order. API - Orders are not sending to API. Fix with ftp only

...format) and a background image that fills the page. The website should include a top navigation menu (links to Transaction, Resource Investment, Global Exploration, My Assets, Quick Recharge, About Us). The homepage should also have the company’s tagline: "Turning Every Step Into Gold". The homepage should be responsive, adjusting to different screen sizes and devices. Transaction Page: Create a Transaction page with two options: Delivery Contract and Perpetual Contract. Each option should be a separate page, so there will be a total of 3 pages: Transaction (overview page with links to Delivery and Perpetual) Delivery Contract (trading chart to buy and sell GOLD (XAUUSD) with options to check balances, profits, and percentage gains) Pe...

I'm seeking a business coach with expertise in marketing strategies, specifically in email marketing. - Focus on Building Relationships: The primary goal of this coaching project is to enhance my email marketing skills to build better customer relationships. - Experience Required: A strong background in email marketing with demonstrated success in customer relationship building is essential.

...drawing. As a gift for a friend, I would like you to recreate a small painting or drawing memorializing a drunk fight between him and myself on our mutual birthday trip to Las Vegas (it was over something very silly, and we got over it immediately). It certainly does not need to be hyper realistic, and as long as it dramatizes and catches the spirit of the moment I will be so happy. I am almost picturing a baroque style painting depicting the chaos. Can also be like a cartoon with caricatures. If you think you can roughly do it, in the next steps I will explain the specifics of the scene and what I want in it (it is not too complicated, and you can take many liberties), and I will send you pictures of the few friends I need in the picture (just to get ...

I'm looking for an experienced developer to help complete my heavily documented site and move it from rough MVP to an evantually a launched site. The primary goal of the site is to enable easy access to data through visualizations and dashboards. This project involves completing a basic freemium model membership site that lists service offerings. Key Responsibilities: - Develop a freemium model membership site - Integrate role based auth system using 3rd party db auth system - Integrate listing scraping system using 3rd party scraper - Create a document generation feature - Establish a process management system (calendaring, scheduling) - Implement data processing and taggging system Ideal Skills: - Experience in developing membership sites, particularly ...

...with Photos, Quotes, and QR Codes Linking to Videos Project Description: Hi! I’m looking for a skilled and creative freelancer to design a personalized photo album for my wife’s 39th birthday. This will be a very meaningful gift, so I’m looking for someone who can take full ownership of the design process and deliver a polished, beautiful final product. Due to time constraints, I need someone who can take the initiative, manage the project end-to-end, and create a stunning album with minimal input from me. I will provide the photos, quotes, and video links, but I’m relying on you to manage the layout, design, multimedia integration, and quality control. Here’s what I’m looking for: Key Elements: Album Design Aest...

I'm looking for a comprehensive web app tailored for architects. This platform should encompass: - Project Management: Helping architects oversee their projects from inception to completion. - Design and Drafting: Offering tools and features to aid in the design and drafting stages. - Client Collaboration: Facilitating seamless interaction between architects and their clients. - Media Upload: Allowing architects to upload and share various media related to their projects. A crucial part of this web app is its collaboration features. Specifically, it should support: - File Sharing: Enabling easy and efficient sharing of project files amongst team members and clients. The ideal candidate for this project should have extensive experience in web app develop...

One month SEO for one website for one language version

I'm looking for a professional who can create multi-page Jotform templates for my insurance brokerage. I am looking to partner with someone to build a full suite of forms, for different application in my business. Once that project is complete, my next project will be engage a CRM and to store the data in an SQL database together with other data collected. Attached are some sketches of what is required.

...a skilled React and Node JS developer to take my project to the next level. What you will be doing: 1. **Styling and Design**: - Implement **responsive design** to create a seamless browsing experience across all devices. - Apply **UI/UX improvements** to make the project more user-friendly. - Update **branding and color schemes** for a fresher, more modern aesthetic. - Add a **'wow' factor** to the existing UI to impress users. 2. **Performance Optimization**: - Improve **page load times** for a swift and smooth user experience. - Optimize **rendering** to ensure pages look and function their best. - Reduce **network requests** to further speed up response times. 3. **Code Refactoring**: - Le...

I need a developer to troubleshoot and resolve several critical issues in my MLM system, primarily concerning user rebirth and position filling. - Issue 1: 'Rebirth Under Direct Recruit' is the top priority. The system needs to correctly identify and place a user's rebirth under their previous self post-rebirth. as well as root user rebirth fixing - Issue 2: 'Position Filling in Downlines' needs to be addressed next. The system must accurately reflect new recruits in a user's downline hierarchy. - Issue 3: Lastly, the 'Income Distribution Logic' requires attention. Direct and team income rules are not functioning as they should. The developer must be proficient in Laravel and MySQL. Given the nature of the issues, previous ex...

I need an expert in ASP.NET and SQL Server to assist with migrating my website and database from GoDaddy to a new host, Ionos.com. Need to scan for malware as well. Not sure of the number of tables but it's around 20. It's not a large dbase. Need SSL activate. Key Requirements: - Full migration of ASP.NET files and SQL Server database - Ensure all data is accurately transferred and the website functions seamlessly on the new host Skills and Experience: - Proven experience with ASP.NET - Extensive knowledge and experience with SQL Server - Familiarity with GoDaddy and Ionos hosting services - Strong troubleshooting skills to address any potential issues during migration

Taxation and Prequalification Relationship: Key Question: Does a company need to pay taxes in Germany to remain prequalified as a Leistungserbringer for Produktgruppe 16 and Produktgruppe 02? Maintaining Prequalification While Paying Taxes Elsewhere: Key Question: Can the company do its taxes in a country with lower tax rates and still stay prequalified in Germany under the gesetzliche Krankenkasse system?

...looking for a PHP expert to create a script or class that generates PDF/A-1a compliant files from the text stored in my database. The content of the PDF will primarily be text, with some logos and icons as images, as well as tables and bullet lists. Key Features: - The PDFs will generally include an index, with each entry linked to specific content via internal links. - The content is text, tables, lists, images (path to local images) to take from a database. - The images are and must be stored in folder on the server. - Proper data structure with titles, tags, labels, internal links, etc., to meet PDF/A-1a standards. - Validation of the generated PDFs for PDF/A-1a compliance. - Ability to append an existing PDF/A-1a document at the end. Add...

Per month GMB(google my business) for one website

I am looking for a modern-styled logo for a specific community within the Church. The community is Veterans, military servants. The new design should be able to reference our existing church logo, which I provided. Key requirements: - A keen eye for modern design. Type is SJE4Veterans - Ability to seamlessly integrate certain elements from our existing logo which is attached. - Proficiency in creating minimalist designs that will print well on many surfaces. - Strong communication skills for understanding and incorporating feedback Please note, the new logo should primarily use red, white and blue for patriotism. The logo is for Veterans, who require red, white and blue.

Need experience algo trader with ninjatrader and tradingview (projects eventually) I have a concept that includes BSL, SSL, swing high/low, FVGs, OBs Questions for coder: 1. how many years of trading ICT concepts do you have? 2. Do you understand L2 dom and order flow? explain a script that used orderflow analysis 3. What was the highest success rate you made with a indicator (if you have a picture please share the backtest with proof of technical competency) 4. Would you be open to partnering up as I have many requests for custom scripts and algo each month.

I'm looking for an ambitious developer to create a unique Bitcoin(fork) Lotto application where players can purchase a weekly ticket, the winner is selected at random and they receive the prize fund to their wallet automatically. I belong to a large community of users who will use this tool. I have a bunch of other bigger projects which I'm looking for a dev for and this lotto project will potentially lead to regular work in an exciting, leading edge of blockchain development. I am looking for a long term-relationship with a quality dev to build amazing things. Key features of the application will include: - No user signup, the user only enters their chosen name for their entry to the lotto when sending their ticket purchase:...

Project Title: Python Script to Query ArcGIS REST API and Save Layers (including Parcels) Data in PostgreSQL Description: I need a Python script to interact with the ArcGIS REST API of the provided service. The script should: Retrieve and list all available layers and tables from the service. Specifically query the (14) table to extract parcel data, including geometries and attributes. Save the retrieved data into a PostgreSQL database with a properly defined schema. API Reference: or or

I'm seeking a skilled video editor for my German-language educational YouTube content. The videos will alternate between documentary-style and interview formats... The videos will alternate between documentary-style and interview formats. Key Requirements: - Proficiency in Adobe Premiere Pro and After Effects - Capacity to comprehend and edit for a variety of educational content - Ability to adhere to a moderate post-production involvement, including occasional revisions and feedback - Native or fluent German speaker with excellent understanding of the language Potential for Long-Term Collaboration: If I find a freelancer who consistently delivers high-quality edits and shows a good understanding of the content and feedback, I would be open to establishi...

...Verification: Ensure that users are of legal age to gamble. Responsible Gambling: Implement features like self-exclusion, deposit limits, and resources for people who may have gambling problems. Data Protection: Make sure your site complies with GDPR, CCPA, or other relevant data privacy laws. 2. Platform Development Technology Stack: Choose the right technologies for the front-end, back-end, and database. Common technologies used in betting sites are: Front-end: HTML, CSS, JavaScript (React, Angular) Back-end: Node.js, Python, Ruby on Rails Database: MySQL, PostgreSQL, or NoSQL solutions (MongoDB) Betting Engine: You'll need to develop a custom or licensed betting engine to handle odds, betting options, and live updates. Real-Time Data: Use APIs ...

Hi! I’m a Romance author looking to establish a long-term working relationship with a writer who can bring a fresh spin to the steamy bits in my books. I write a lot, and I need someone who’s comfortable diving into the spicy dynamics of monster romance and reverse harem. Project Details: Scene Length: 1,500 words. Genre: Monster romance with reverse harem elements. Tone: High heat, Requirements: Comfortable with niche dynamics: You must have experience or familiarity with monster and reverse harem tropes. Samples: Please provide examples of your work that showcase your ability to write high-heat romance or similar dynamics. Plus if you have sample of Monster or reverse harem Professionalism: I value deadlines, clear communication, and a colla...

...start with a plan, developing a strategy tailored to your objectives and audience. Together, we decide what to post, when, and how, to maximize impact. **Content Creation:** We take care of everything: photos, graphics, videos, and engaging texts for posts and stories. Everything will be designed to showcase the best of your brand and capture your audience's attention. **Planning and Publishing:** You don’t have to worry about a thing: we schedule and publish all content according to the agreed calendar. You can focus solely on your business. **Interactive Management:** We respond to comments and private messages, maintaining an active and authentic dialogue with your audience. This way, you build trust and strengthen ...

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...promotion of events. The system must handle a large amount of data while effectively managing event overlaps. NO AI GENERATED SAMPLES ACCEPTED Key Functional Requirements 1. List View Objective: Provide a quick overview of events. Features: Chronological listing of events. Filters to refine events by location, date, type, and target audience. Highlighted events using visual cues (e.g., colors or icons). Paginated list to manage large data sets efficiently. 2. Filtering and Search Objective: Allow users to quickly find relevant events. Features: Filter by location (national, regional, city-level). Filter by date range (e.g., this week, next month). Filter by event type (conference, workshop, training, etc.). Keyword-based search field. 3. Calendar View Objective...

I'm looking for a skilled web developer to create a one-product Shopify store focused on a pet tracker, with a minimalist style. The primary goal of this store is to generate sales. Key Features: - Customer Reviews: I want to build trust with potential buyers. - Mobile Optimisation: The store must be fully responsive and functional on all devices. - Upselling Offers: Implement strategies to increase average order value. - Email Marketing: Set up for abandoned carts and other necessary campaigns. Compensation: The developer will receive a 10% commission on every sale, regardless of the quantity. Ideal Skills: - Extensive experience with Shopify. - Proficient in creating minimalist, user-friendly designs. - Knowledgeable in SEO and effective e-co...

...can finish it in next 4 hours I need a data analyst with expertise in SPSS 27 to help me perform a series of statistical tests on my dataset. The main focus will be examining relationships between variables. Specific tasks include: - Examining descriptive statistics in relation to PSQI. - Assessing descriptive statistics related to Cognitive Impairment. - Comparing Sleep Quality against MMSE using T-tests or Mann-Whitney tests. - Analyzing the relationship between PSQI and MMSE with Chi-square tests. - Running Chi-square tests for each variable against PSQI and MMSE separately. - Performing regression analysis as appropriate. Please note, I have not yet decided on a method for handling missing data. I am open to discussing this with the freelancer...

...experienced animator to create a 30-second animated video featuring our characters, Louie Lambo (a green gecko) and his partner, a cool panda. This animated video is for a memecoin project, and it will be action-packed, humorous, and showcase the two characters effortlessly dispatching a group of animals representing other memecoins in the market. Key Details for the Animation: Length: 30 seconds Style: 2D animation (modern, fun, and lively) Characters: Louie Lambo: A confident green gecko wearing a sharp suit, sunglasses, and a glowing XRP championship belt. Panda: Louie’s cool, calm, and collected sidekick. Antagonists (other memecoins): A group of animals surrounding Louie and Panda, representing rival memecoins. Photos of these animals will be provided. Scenes to...

Yes I'm happy Comprehensive Digital Marketing Services: SEO, Social Media Marketing, PPC, Email Campaigns, and Content Marketing।

...have a Dotnet source code for a program which needs to be completed if there are any missing pieces. 2. You'll be responsible for programming the database, which will be SQL Server. 3. Finally, the completed program will need to be uploaded on a server, where you will also run it. The code might need improvement in the following aspects: - Functionality/features - User interface - Error handling and debugging Part II: Apps Developer I need skilled apps developers to create Android and iPhone apps based on the aforementioned program. Ideal skills and experience for the job includes: - Proficiency in Dotnet programming - Extensive experience with database SQL and MySQL Servers - Strong skills in Android and iPhone app development - Able to...

...a religious/devotional audience (although I would like to use it as a template for future apps with other themes/audiences, so would be great to start up a relationship with you for future projects that re-uses the app as a template). I am just an individual not a company so budget is very small. Required - prepare and optimize the app for integration into Google Play as a subscription-based app - prepare backend for subscription API logistics and integrate into the app (7 days free use, $ thereafter per month) - pull the LLM API out of the app and have the app securely access it remotely for security using Google services - prep the owner on use of the updated app and Google Play billing, how to update the app if needed, how to update the hidden LL...

Osaka Mall is a sophisticated online shopping platform that brings the world of luxury right to your fingertips. Designed for those with discerning taste, Osaka Mall offers an unparalleled shopping experience, showcasing a curated selection of high-end brands across fashion, beauty, electronics, and lifestyle categories. #### **Key Features**: 1. **Luxury Brands**: Discover an extensive collection of globally renowned luxury brands, including apparel, accessories, jewelry, and more. From timeless classics to contemporary trends, Osaka Mall caters to every style preference. 2. **Seamless Experience**: With an intuitive interface and secure checkout system, Osaka Mall ensures a hassle-free shopping journey. Easily browse through categories, explore detailed produc...

I'm seeking a skilled web developer to enhance user interactions on my webpage through an interactive browser window feature. This will involve the implementation of interactive animations with dynamic effects, ensuring an engaging and stimulating user experience. Key Project Requirements: - Develop an interactive browser window to be accessed from a designated page. - Incorporate interactive animations such as moving elements, changing shapes, and other engaging visuals. - Utilize dynamic effects for the animations, creating an energetic and captivating experience.

I'm an individual start-up seeking a dedicated team for ongoing maintenance and updates for my Flutte...experience require the most attention. - The code can be complex, so I'm looking for someone flexible, patient, and capable of adjusting, fixing errors, and debugging as necessary. - As a start-up, budget is crucial. Ideal candidates would have extensive experience with Flutter, Firebase, and Google Maps API, with a knack for UI/UX improvement. I value a friendly and cooperative working relationship, with a team who understands the needs of a start-up. Please note that I have not yet determined a specific method for tracking bugs and errors, so flexibility and initiative in this regard would also be appreciated. Thank you. Please view the app on stores before biddin...

I am seeking a professional to help me develop a compelling "Buy One Get One Free" offer for my optic shop. The promotion will cover eyeglasses and sunglasses, with the aim of increasing foot traffic and sales. Key Tasks: - Create an appealing and effective promotional strategy - Develop clear and enticing messaging for the offer Ideal Skills and Experience: - Proven experience in retail promotions, specifically in the eyewear industry - Strong marketing and copywriting skills - Ability to understand and cater to target market needs

We need to set up a progress plan and resource plan in google sheet. This is quite similar to MS project or Smartsheet, and many other tools. But we need this in google sheet, where we also need to be able to easily see where the resources are, shown as both a timeline / gantt, and in calendar view. This means that we must be able to choose between the project list and the resource list in terms of display, and here we can choose between seeing it as a timeline and a calendar. Need it done asap. See attached screenshots.

I'm seeking an experienced assistant to help me prepare for an interview for an AWS Cloud PostgreSQL DBA role. The training will specifically focus on Postgres-centric DBA tasks, with an emphasis on database performance tuning. Key Areas of Focus: - Database Performance Tuning: This is a critical aspect of the training. I need to understand how to fine-tune the database for optimal performance. - Query Optimization: I would like to delve into the intricacies of making queries run as efficiently as possible. - Index Management: Understanding how to manage indexes effectively will be a key part of our sessions. - Monitoring and Diagnostics: I need to learn how to monitor the database and diagnose any potential issues. Ideal Candi...

We already have a MySQL cursor with a loop set up to fetch values and perform certain calculations. We need an experienced MySQL developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsh...

I'm seeking a PostgreSQL DBA expert to help me become professional in database tuning and optimization. Focus Areas: - Query Performance Analysis: Understanding how to assess and improve query efficiency. - Index Management: Learning how to create, modify and delete indexes for optimum performance. - Configuration Settings Adjustments: Gaining skills in fine-tuning database settings for peak performance. The ideal candidate would be one who can deliver personalized one-on-one training sessions tailored to my learning pace and style. Please include your relevant experience and approach to teaching in your proposal.

To answer your query, here are the details for each point: 1. Ideas for projects for recruiters: Projects could include developing a structured interview process, creating a candidate persona template, automating follow-up emails, or implementing an Employee Referral Program. These focus on improving hiring efficiency, candidate experience, and the overall recruitment process. 2. Technical tools or systems to assist with recruitment: This could involve researching and implementing Applicant Tracking Systems (ATS), AI-driven resume screening tools, or data visualization dashboards to analyze hiring metrics like time-to-hire or quality of hire. 3. Examples of completed projects by recruiters: Examples might include successfully reducing time-to-...

I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.

...thesis writing, specifically for chapter 2 (Literature Review) and chapter 3 (Methodology). - Chapter 2 should cover various aspects of e-wallet usage and its impact on millennials in Selangor, Malaysia. Here are some potential research objectives for studying identify the relationship e- wallet use and continuous intention among millennial’s : The specific objectives are: 1) To identify perceived usefulness and perceived ease of us of e-wallets among millennials. 2) To identify the role of use trust. 3) What is the relationship between perceived usefulness, perceived ease of us and continuous intention. - Chapter 3 should be written with a focus on a Quantitative research methodology. Of survey by 399 participant from 1 million millenials **** Must...

...thesis writing, specifically for chapter 2 (Literature Review) and chapter 3 (Methodology). - Chapter 2 should cover various aspects of e-wallet usage and its impact on millennials in Selangor, Malaysia. Here are some potential research objectives for studying identify the relationship e- wallet use and continuous intention among millennial’s : The specific objectives are: 1) To identify perceived usefulness and perceived ease of us of e-wallets among millennials. 2) To identify the role of use trust. 3) What is the relationship between perceived usefulness, perceived ease of us and continuous intention. - Chapter 3 should be written with a focus on a Quantitative research methodology. Of survey by 399 participant from 1 million millenials **** Must...

We are seeking an experienced AWS backend developer to help us design, implement, and finalize a robust data pipeline that meets both functional and operational requirements. This pipeline will enable scheduled ingestion, transformation, and analysis of API data and provide a RESTful API to dynamically serve data to our website. Objective To create a cost-effective, highly available, and secure AWS-based backend architecture that ensures seamless data ingestion, transformation, and real-time interaction with our website. Key Responsibilities Data Ingestion Schedule Python scripts using AWS Lambda to fetch data from APIs. Handle API rate limits, errors, and retry mechanisms. Store raw data temporarily in Amazon S3. Data Parsing Clean and structure raw ...

We are a small healthcare start-up based in the UK. We have an iOS and Android App built using -React native. -Firebase The App has been live for 2 years with many thousands of users. We use Firebase as a backend database. We are looking for a long-term development partner. The app is currently live on Android and iOS. 1. The Android app needs an API update. 2. The Android app also needs a Billing library update. 3. Update iOS app firmware too. 4. Successfully upload to iOS and Android stores 5. Fix some minor bugs 6. Improve user interface This will be the first stage, I am looking for more updates later on.

I've got a relationship counselling website that just needs to be made mobile and tablet friendly. The website is basically done, I just need a professional to ensure that it works seamlessly across all devices. Key requirements include: - Mobile and Tablet optimization: The entire website needs to be fully responsive and user-friendly on mobile and tablet screens. - Special attention to Navigation Menus: These need to be particularly well optimised, as they are crucial for the user experience on smaller screens. Ideal skills for the job include experience with mobile website optimization and a keen eye for ensuring a smooth navigational experience.