Sql merge two tables into one jobs

Project Name: Personalized News Dashboard Overview: This project involves creating a Personalized News Dashboard that aggregates news from various sources and uses machine learning to curate content based on user preferences. The dashboard will feature an AI-driven recommendation system that not only presents news articles but also provides analytical insights into trending topics and sentiment analysis of news content. Objectives: Main Goal: Develop a web application that personalizes news content for users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. U...

...warehousing, ad hoc 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 ...

...Functionality: Dashboard Interface: Display a list of IoT devices. Device Selection: Ability to select a device to load its statistics via API. Graphs and Data Tables: Around 10 different graphs and several data tables with pagination. Time Ranges and Filtering: Options to select time ranges and apply filters from the UI. API Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria...

I have a website. Need one page change dynamic from static. I have an admin panel also need control that page from admin panel. Also need a new user for admin panel with some limits. For example new user should edit only news section. Database is on postgresql.

...English PDF document into a Google Docs document for me. The PDF contains text that needs to be accurately transcribed into a formatted Google Docs file. The PDF does not contain any complex formatting, images, or tables, so it should be a straightforward copy typing job. Ideal Skills: - Excellent English language skills - Proficient in typing and data entry - Familiarity with Google Docs or similar word processing software Your work should be meticulous and error-free, with a focus on maintaining the original document's formatting and structure. If you have previous experience with similar projects, that would be a plus. need a freelancer to copy type an English PDF document into a Google Docs document for me. The PDF contains text that needs to be a...

Seeking an SEP expert using Yoast Premium SEO with a good command over the English language to optimize my WordPress hosted websites. Here are the links to the websites

...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 languages.  Strong understanding of database design principles and data modeling techniques.  Experience with database performance tuning and optimization.  Excellent communication and leadership skills.  Ability to work effectively in a fast-paced environment and manage multiple priorities.  Relevant certifications in Netezza and Oracle te...

Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!

Basically we are dealers in computers and cctv cameras I am looking for a website, only one messaging bar center of website once client sent message from that message, the same I have to receive on my whatsapp message and then we can continue chat in whatsapp only, basiclly I want my clients to forward to whatsapp chat and a nice bakcground image of all computers parts and cctv parts image One logo of my company name with images of computers brand

I have to transfer data and tables from oracle to postgres.

This project involves a series of photo editing tasks, primarily focused on removing a person in the middle of the image and adjusting it to look like a couple. The final product will be used as a gift. Key requirements: - Exceptional photo editing skills to seamlessly remove a person from the middle of a photo - Ability to shift and adjust remaining individuals to make it appear like they're a couple - Enhance photo quality and clarity for a polished final product - Adjust the backdrop to a studio setting, maintaining a professional and neat look. Ideal freelancer would have experience in advanced photo editing techniques, especially in people removal and background adjustments. Keen attention to detail and a creative eye will be incredibly beneficial.

I'm in need of a desktop software that can analyze a specific type of data within a PDF table. The software should: - Read and extract data from a PDF table - Compare this data against another table - Identify and save matching data in the form of an Excel file. The tables in question will contain numerical data only. Ideal Skills and Experience: - Proficiency in developing software for Windows - Experience with data extraction from PDFs - Strong capabilities in data comparison and analysis - Knowledge in Excel formatting - Understanding of numerical data handling.

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

Need to 2 single and separate webpages to display data from tables in MSSQL database

I am in need of a talented artist who can take several family photos and merge them into one impactful, sentimental drawing. Please find the requirements below: - Create a coloured pencil sketch capturing the emotion of the main characters: myself, my wife, our newborn son, and our fathers. - The primary focus should be on us with some background elements included. -Can you please make the background Australian grassed bushland themed. - Depict us with a realistic (ish) style adhering to the real-life characteristics of every individual. - The image will be of my wife and newborn son in the foreground, with our deceased fathers standing over us in the background both wearing cowboy hats, maybe watching us and having a beer. The ideal candidate will have strong pencil...

I have a simple text-based PDF file that I need to be converted into a Word document. The purpose of this conversion is to enable further editing and formatting. Key Requirements: - The PDF is straightforward, with no images or tables, just plain text. - The Word document should follow a standard business format, so no specific styling or custom style guide is needed. Ideal Skills and Experience: - Proficiency in typing and data entry - Familiarity with standard business document formats - Experience in PDF to Word conversion is a plus - Attention to detail to ensure accurate and error-free transcription

I am on the lookout for an adept freelance copywriter who is proficient in both German and English. Our need primarily concerns: - Crafting content for brochures and website edits - Ideally, the copy will mai...from English to German, making bilingual proficiency a must. Our German marketing team largely focuses on our SaaS product (specifically, our learning management system, Spark) and our compliance training services. Ideal skills: - Exceptional bilingual proficiency (German-English) - Track-record in engaging B2B audience - Experience with writing for brochures and websites - Capability to merge technical nuances with general readability in your writing - Previous work in the SaaS industry will be highly beneficial. Learn more about Sponge here:

I'm in need of a talented logo designer who can create a vintage-style logo that...logos prevalent today. The design should evoke a sense of nostalgia and timeless elegance. - The ability to merge text and symbol seamlessly and elegantly is crucial. The text should be easily readable, and the symbol should complement the text, enhancing the overall feel of the logo. - Experience and a portfolio that demonstrates proficiency in vintage-style design is highly desirable. Ideal Skills and Experience: - Proven experience in logo design, preferably with a focus on vintage aesthetics. - Proficiency in creating a cohesive design that works well across various mediums. - Strong communication skills, as I'm looking for a designer who can understand my vision and translate it in...

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a seasoned developer to create a robust messaging gateway that supports multiple platforms and is capable of handling a high volume of messages. Key Requirements: -Building a messaging gateway and communication platform to enable applications and systems to send and receive messages through SMS, Email messages or Mobile Push Notifications with a variety of connection options and integration channels. - A dedicated on-premise messaging gateway that provides better visibility and control on sent messages and notifications - Improved security and control over sent messages with masking and filtering options - Higher availability with offered load balancing, bulk providers switchover and different sending methods - Seamless operation and integration with a dedicated sys...

I am seeking a freelancer with LaTeX expertise to transform a two-page Word document into a LaTeX template. This template should be flexible and able to accommodate the following requirements: - Intermediate level of customization: I expect the final template to have customized headers/footers, specific font choices, and a coherent, professional structure. - Combination of text, figures, and tables: The original document merges text, figures, and tables. The template should maintain this mix while ensuring a consistent, clean layout. The ideal candidate should have a strong proficiency in LaTeX, with prior experience in creating similarly styled templates. Excellent attention to detail is crucial, as the final template should mirror the original document'...

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...

I have a project that requires data entry from various online sources into a document with specific formatting. Key Requirements: - Data Entry: You will need strong typing skills and attention to detail to accurately input the text data provided from online sources. - Data Formatting: The entered data must be organized and formatted appropriately within the document. Ideal Freelancer: - Experience with data entry, preferably with text. - Strong understanding of formatting in documents. - Attention to detail to ensure the accuracy of the entered data. - Good time management skills to meet deadlines.

...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer t...

I have a Microsoft Word document that needs to be converted into a PDF. This is a straightforward task. However, I need the final PDF to have a custom layout design. Key Requirements: - Convert Microsoft Word document to PDF - Implement a custom layout design in the PDF Ideal Skills: - Proficiency in Microsoft Word and PDF conversion software - Experience in graphic design or document formatting - Attention to detail and adherence to the provided layout design Please let me know your experience with similar projects and how you would approach this task.

I need to create an Excel dashboard to visualize our inventory data. It's not a complex task and should take around 20 to 30 minutes. What I need: - Display of inventory data on the dashboard using charts and tables - The table should contain: Ideal skills for this project: - Proficiency in Excel and creating visually appealing dashboards - Understanding of inventory data and its representation in tables

i am looking for all in one rummy aviator game in unity. if you already have made such app

SEO service for one month for 1 website and 15 Keywords

I'm in need of a skilled freelancer to convert a PDF document to a Word file. The primary purpose of this conversion is to enable content editing within the Word document. The PDF in question is straightforward in layout, containing simple text without complex elements like images or tables. Your job will be to ensure this text is accurately transcribed to a Word file while preserving the original formatting.

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

I'm looking for a freelancer to transform my plain PowerPoint into a more engaging and professional presentation with improved design and visuals. This is for a training session aimed at adult participants. The second part of this project is creating an interactive matching game on inclusion. I need this game to be user-friendly and embedded. Ideal skills and experience for this project include: - Proven experience in creating engaging, professional PowerPoint presentations - Experience in designing interactive digital learning games - Understanding of adult learning principles and training methodologies - Strong graphic design skills to make the presentation visually appealing - Insight into inclusion and diversity training would be a plus. This project is perfec...

I'm in need of two illustrations that are to be used on my website. I've provided mockups for these illustrations, so you'll have a clear idea of what I'm looking for. Requirements: - To be used in outgoing email - Work from the mockups provided Ideal Skills: - Proven experience in creating simple and easy to understand illustrations - Ability to work efficiently and meet tight deadlines - Strong communication skills for understanding and implementing feedback - Familiarity with digital illustration tools Please note that these are needed urgently, so only apply if you can start on these right away and finish within the day.

I'm looking for someone to create a one-page admin dashboard using React-Vite-MUI-Redux. The primary purpose of this dashboard is just to have one page for now. That one page that will have a form (use react-hook-forms) with 10 fields. One of them is a date field, another is a time field (just hours no minutes), 3 are drop downs and others are strings. Key Requirements: - Develop a one-page admin dashboard using React-Vite-MUI-Redux - Have a sidebar and a space for branding and logo Please note that the primary purpose of the admin dashboard page is not specified, so I'm looking for someone who can create a comprehensive one-page dashboard with the aforementioned functionalities.

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

Financial presentation on the analysis of two stocks with the help of the financial Discounted cash flow model that has already been prepared. You will need to complete:- 1. Powerpoint presentation slides 2. A 1000-word MS-Word document that will tell the speaker what needs to be spoken for each of the slides. 3. A 200-word reflection

I have less than 50 PDF documents that I need converted into Word. The PDFs are more than just plain text, they contain images and tables. It is important to keep the original formatting as it is in the PDFs. Key requirements include: - Converting less than 50 PDF documents into Word - Handling PDFs that contain both text and images/tables - Keeping the original formatting of the content Ideal freelancer: - Proficient in data entry and familiar with PDF to Word conversion - Able to maintain the original formatting - Detail-oriented to avoid missing any elements of the PDFs. Please bid if you are confident you can deliver the work with high quality and accuracy.

I need an image logo removed from my website permanently and change one sentence into another, both on cover page

As a translation agency, I am looking for talented linguists to take a single-sentence tag line in English and translate it into 14 different languages. The languages are: Indonesian, Japanese, Chinese (traditional and simplified), Korean, Russian, Ukrainian, Belarussian, French, German, Brazilian Portuguese, Spanish, Italian. Key Requirements: - Proficient in both the source language (English) and target languages - Prior experience with creative translation / copywriting - Ability to maintain the essence and creativity of the tagline while ensuring cultural sensitivity and appropriateness Ideal Skills: - Native level proficiency in the target languages - Demonstrated experience in creative or marketing translations - Strong attention to detail and cultural nuances - Proven port...

I need a financial model for my venue, specifically tailored for investment analysis. The powerpoint should focus on taking information from a research report and putting into slides. Ideal candidates for this project should have experience in alternative investments, investment banking, or asset management.

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

...Calculate and interpret Z-scores for normal distribution data. Assess the sensitivity and specificity of lie detector tests based on given data. Required Skills: Proficiency in R and/or Python for statistical computing and graphics. Strong understanding of discrete and continuous probability distributions. Experience with exponential distributions and their applications. Ability to interpret and use Z-tables for normal distribution analysis. Excellent problem-solving skills and attention to detail. Strong mathematical and statistical analysis skills. Effective communication skills for reporting and documentation. Qualifications: A degree in Statistics, Mathematics, Data Science, or a related field. Proven experience in statistical analysis and probability theory. Familiarity with...

One Page For Photo Printing Solution the job is done the files are already shared.

FARMING DATA Data: Download this Excel Workbook including these 3 tables: ● ○ Prices_Crops_Livestock ○ Production_Crops_Livestock. ○ Land_In_Use NOTE: These tables contain agricultural information for 20 countries and a list of various crops and livestock products. The data is sourced from the Food and Agriculture Organization of the United Nations where you can find definitions and standards. Scenario: Imagine you're a data analyst at a global agricultural organization, entrusted with enhancing worldwide agricultural production understanding. American stakeholders seek a comprehensive view of global farming trends as they evaluate diverse food supply chain initiatives. Audience: American stakeholders. Insights: Address several questions to gain insights about your d...

I'm in need of a professional web developer capable of building a simple, yet elegant, subscriber-based website. My vision for the website includes: - Data visualisation: The site will need to effectively display data from a Google Sheets database in an engaging manner. This could be in the form of graphs, tables, etc. - Regular updates: The data on the website should be updated weekly directly from Google Sheets (some data in Google Sheets is "live data", and as such the updated are more frequent, but automatic). Therefore, integration skills are crucial. - Core Pages: Standard pages required include 'About Us', 'Services' and 'Contact Us'. Ideal freelancers should have strong experience and skills in web development and Google She...

I'm looking for an experienced developer to convert my existing React app into Next.js. The main features that need to be incorporated are data fetching from external APIs and server-side rendering (SSR). Key requirements: - Conversion of existing React app into , ensuring all features are intact - Implementation of data fetching from external APIs - Integration of server-side rendering (SSR) to improve performance and SEO I require a freelancer with: - Proven experience in React and - Strong knowledge of data fetching from external APIs - Expertise in implementing server-side rendering - Excellent problem-solving and communication skills If you believe you have the skills and experience necessary to complete this project efficiently, please submit your proposal.

I need a simple one-page website to promote my product or service. This will be a single-page site with a fixed header and footer, so all content will be easily accessible for visitors. Key requirements: - **Promotion**: The main focus of the site is to promote my product or service. The content needs to be engaging, concise, and persuasive. - **Contact Information**: I would like the footer to contain my phone number, email address, and links to my social media profiles. These links should be clearly visible without being too intrusive. The design should be modern, professional, and mobile-responsive. I'm looking for a freelancer with experience in creating effective single-page websites that drive conversions. Good understanding of user experience (UX) design would be a ...

I'm looking for an experienced and knowledgeable SQL Server professional who can help me resolve a connection issue I'm experiencing. - **Connection Method**: I'm currently using Windows Authentication to connect to the SQL Server. - **SQL Server Version**: I'm using SQL Server Management Studio 20. - **Error Message**: When trying to connect, I receive an error message indicating that the connection has failed. Ideal candidates for this project should have: - Extensive experience with SQL Server, particularly with the version I'm using. - Proficiency in troubleshooting connection issues. - Strong communication skills to guide me through the resolution process.

...that the client will provide a two-dimensional floor plan of the space that needs to be designed. A 2D floor plan typically includes measurements and layout details of the room, including walls, doors, windows, and other architectural features. 2. **"THEN YOU NEED TO DESIGN IT"**: After receiving the 2D floor plan, the designer (in this case, you) will be responsible for designing the space. This involves arranging furniture, selecting wall materials, deciding on color schemes, and any other design elements necessary to create a cohesive and functional interior. 3. **"WITH AVAILABLE RESOURCES THAT I HAVE IN MY FURNITURE SHOP"**: The design should incorporate furniture and other items available in my furniture shop. This could include sofas, chairs, t...

As an individual making use of Google Maps for specific personal applications, I am in need of a freelance developer adept at using VB.Net and SQL database to develop a program that will post activities on Google Maps. This software will be particularly handy in marking and recording various personal activities. The Successful Freelancer: - Should provide evidence of experience in VB.Net coding and SQL database management. Showcasing past work that is similar to this project will be beneficial. - They should also understand the implementation of access levels in software development as the map posting feature will be restricted to admin use only. Main Activities: - Create a software application using VB.Net. - Link the application to Google Maps. - Develop a feat...