Small sql queryJobb

I'll provide you a dwg file of floor plan.i just need plumbing, electrical, hvac plan for area which i highlight in rectangle.

I'm seeking an expert to build a PowerBI solution, primarily for financial planning and analysis (FP&A). Key project requirements: - Robust Integration with our SQL database to pull the necessary data. - Proficiency in creating illustrative Charts and Tables in PowerBI, enhancing data interpretation. - The dashboard should effectively track and analyze the key metrics such as Revenue, Profit Margin, and Sales growth. Ideal freelancers applying for this project should have: - Demonstrable experience in PowerBI and SQL database integration. - Solid background in creating visually engaging dashboards, specifically using Charts and Tables. - A solid understanding of FP&A metrics. - Proven track record in delivering similar projects. Please submit your bid with...

I'm in need of an experienced accountant who can take charge of my monthly payroll processing. Key Responsibilities: - Perform monthly payroll processing for my small business - Execute pay stub generation accurately - Ensure the entire process is conducted in QuickBooks either desktop or online Ideal Skills & Experience: - Proven experience in payroll processing - Proficiency in QuickBooks (desktop or online) - Attention to detail to ensure accurate pay stubs - Excellent understanding of tax filing requirements Please note that this project is specifically focused on monthly payroll processing for a small team (1-10 employees).

I have a quick photo retouching job that involves removing small shadows from two photos. This is a minor task that shouldn't take long for a skilled photo editor. Key Requirements: - The shadows to be removed are of a small size. - The retouched photos should have a natural look. Ideal Skills & Experience: - Proficiency in photo editing software. - Prior experience in shadow removal. - Ability to maintain a natural look post-retouching. MUST be sent back in very HI-RES.

...scheduler on my website. Your mission will be to set up API calls to request data specifically for certain resources. Key Skills/Knowledge required: - Familiarity with API integration - Experience working with DevExtreme scheduler - Strong understanding of data request and retrieval The job requirements are as follows: - To be able to query the api for scheduler data and present it. The API is already available and I can modify it at any time. I simply need to query it and present the 3 consts (tasks, appointments and assignees). Kindly note, the type of data to be retrieved and the presentation style for this data in the scheduler are yet to be defined. Your input and suggestions during this phase would be highly appreciated. Please place your bid and let's di...

Firma szuka wsparcia zespołu zajmującego się rozbudową i utrzymaniem własnego serwisu web na DNN. Doświadczenie w C#, ASP.NET, T-SQL. Zapraszam do współpracy.

I'm looking for a Full-Stack Python programmer with solid SQL and .NET experience. The primary focus of the project is web development. Key Requirements: - Proficiency in Python is a must. You will be working on both the front-end and back-end of a web application. - Strong understanding of SQL and .NET. You'll be handling databases and working on the server-side functions. - A solid background in full-stack development. The project will require a comprehensive approach to both front-end (user interface design) and back-end (server-side functions) development. Your responsibilities will include, but not limited to: - Developing user interactions on web pages, implementing server-side logic, and maintaining the system. - Building the overall structure of the web a...

Hi, I have a list of providers that I want to export the users from into a database file that can be used by Gathid (), exacting governance and instant, actionable insights that transcend traditional IAM limitations. I need a script that run and doe...script that runs as a different process or you can build a Mono-Repo that can handle all of those providers under one process and can be easily scale to add more applications. Below is the list of Providers: Airflow AWS On-Prem AD Azure AD Control Money Data Lake Data Warehouse GitHub Jenkins Kyriba Loyalty Admin Loyalty API Mode MongoDB NetSuite Octopus Deploy OKTA Pricing Engine Reconart SQL Server SSRS Tableau TeamCity Workday Best of luck, I think it's better to have a Milestone for each one of those providers

Create a small door hanger for my pool business, I want to include a pristine clean pool, my logo my contact information: Gibran Cobos (469)831-7431 gcobos@ and the following *Weekly maintenance *Equipment repairs *Filter cleaning *Free water testing ONE FREE WEEK OF MAINTENANCE FOR ALL NEW CUSTOMERS!

I am urgently looking for an experienced Salesforce developer to fix two unspecified issues within my system as soon as possible. Two things to be done, for those who knows Salesforce shouldn't take more than 5 mins. Opportunity field manadatory. contact field mandatory a new button

I am seeking a creative landscaper with expertise in modern landscape design to transform my small outdoor space. The project includes: - A stylish water element such as a pond or fountain. - The integration of a flower bed into the design. Artistry, attention to detail and a good understanding of space utilization are important. Experience with small spaces and water features will be beneficial.

...data, which can then be analyzed and displayed on the charts. - API integration - Database (Supabase) Integration Ideal Skills and Experience: - Django backend and React JS frontend - Web development experience, particularly in creating data visualization platforms. - Proficiency in real-time data integration. - Database integration - API integration - Search Engine Optimization - Query Optimization - Postgre Notes: - We have a website template that includes code for both the backend and frontend. You would just need to customize it. This is what the template looks like: - Although the template at the link looks like html, we have paid for and downloaded the django code - We have provided two screenshots

...innovación y mejora continua en los procesos y productos de la Start-Up. Requisitos: - Fuerte experiencia en programación con Python, demostrable a través de un portafolio de proyectos sólidos y eficaces. - Conocimientos avanzados en frameworks de Python como Django o Flask, especialmente en desarrollos de aplicaciones web. - Habilidad para trabajar con distintos tipos de bases de datos, tanto SQL como NoSQL. - Experiencia en la integración de APIs y en el desarrollo de servicios web. - Capacidad de análisis y solución de problemas, orientado a resultados concretos. - Fluidez en español, con habilidades de comunicación efectivas para trabajar en equipo. - Preferencia, aunque no exclusiva, por candidatos ubicados en A...

I need an EXPERIENCED Javascript developer to write me a custom React fetching mechanism. Use the Tanstack library to write me a custom hook that can fetch data and cache it too. These features should be implemented: - Assume API call always returns an array of data. - I can pass a modifiedFrom query param which is just a string ISO date. 1. Fetch the data using the cached lastFetched date for that key/api call 2. Mutate the result in the stored cache and updated the lastFetched date in cache 3. Allow data to be cleared from cache after an x time

I'm currently using Oracle and MySQL database management systems and I'm in urgent need of a dedicated database administrator who can expertl...robust backup and recovery strategies, thus to ensure database availability and consistency at all times. - Security Management: Protection of data is paramount, and as such, I require a comprehensive security configuration to guard against unauthorized access or data breaches. - Database Optimization: I'm looking to increase the efficiency of my current database setup. It involves improving query performance and optimizing database storage with a focus on increasing system scalability. It would be best if the candidate is proficient in Oracle and MySQL and has hands-on experience dealing with performance issues, backups, s...

I'm looking for a skilled web developer to help me modify my existing website. The project primarily involves making minor changes to the website and integrating links to various social media platforms. Key Tasks: - Add social media links: I'm looking to integrate links to Facebook, Instagram, and an email address. These links should be seamlessly integrated into the existing design. - Utilize existing images: I have several images already uploaded on the website. Your task will be to access and incorporate these images where needed. - Re-order images: I require the re-ordering of images on the website to suit a new layout. I'm seeking a professional with: - Proficiency in web development: You should have a strong grasp of coding languages and web development techniques. -...

I'm experiencing performance issues with 5 stored procedures in my SQL Server. These procedures are significantly slower than expected due to complex JOIN queries involving multiple tables. The project entails: - Diagnosing the cause of the slow performance. - Improving the efficiency and speed of these 5 stored procedures, aiming to achieve at least a 50% increase in speed. - Decreasing high memory usage of a sql server instance Ideal skills and qualifications: - Proficiency in SQL Server and complex JOIN operations. - Proven experience in SQL query optimization and performance improvement. - Understanding of advanced aspects of SQL Server performance tuning. - Excellent debugging and diagnostic skills. - Familiarity with procedures hand...

I'm in need of a 3D design for a small toy with simple lettering on the design, to be 3d printed. The model doesn't require any animations. Designer must know .obj .stl .mtl .jpg Key Requirements: - 3D Modeling design: The model needs to be created with moderate detailing. - lettering: Applying lettering on the design. - Animation: No animations are required. The focus is on creating a static 3D model/design to be printed. The toy is a small spinning toy. The toy must spin! Ideal Skills and Experience: - Proficient in 3D modeling design and texturing. Experience with toys or small objects is a plus. - Able to create high-quality, detailed models with lettering. - Familiarity with the tools and software necessary for this project. Please provide sample...

I'm in need of a website for my small hotel that serves as an online platform for ordering food. The main features I require are: - **Menu Customization Options**: This feature is paramount to the success of the project. Customers should be able to select and customize their menu items according to their preferences. - **Order Sharing**: To make the ordering process smoother and more efficient, I'd like customers to be able to share their selected items, along with the quantity and delivery address directly on the website. The ideal freelancer for this project would have experience in developing e-commerce websites, particularly in the food industry. They should be skilled in web development and design, and must be able to incorporate these specific features. A good u...

I'm looking for a seasoned PHP and MySQL programmer to establish the architecture of a ranking system for my multiplayer gaming site. Tasks will include but are not limited to: - Database design - Data modeling - Query optimization The ranking system will make use of user ratings, vote counts, and engagement metrics. The ideal freelancer for this project should have ample experience with ranking systems and must exhibit prowess in PHP and MySQL, with a keen understanding of database design, data modeling, and query optimization. Familiarity with gaming sites is a plus. Let’s build a competitive gaming environment together.

I am in search of a highly-skilled MS Excel expert who can help me organize my small business through meticulous data entry and intelligent formulas. The ideal candidate will be skilled in: - Invoice creation - Payment receipt tracking - Maintaining project-wise details The work will involve managing an Excel sheet with less than 100 columns and rows. When creating invoices and payment receipts, you'll need to manage data fields such as: - Customer Name - Service/Product - Amount - Invoice Number - Date - Tax - Customer Address - Payment Method - Invoice Due Date Expertise in Excel's calculation and analysis functions will be especially valuable for this job. This opportunity is perfect for those with a knack for data organization and attention to detail.

J'ai besoin d'un expert pour configurer l'outil de Google Workspace avant une campagne de Cold emailing.

I need someone to make a calculator (in Google Sheets) and some really nice charts to easily visualize the data as well. Token A = Variable market price from 0 to 10 USD max (or infinite) Token B = Always 1 USD Token A generates Token B automatically by staking it in a web3 contract. --- Calculator: Input 1: Amount of Token A Input 2: Token A Price Input 3. APY Output 1: Amount of Token B Generated Output 2: APY (Annual Percentage Yield) --- Chart 1: Line chart modeling Token B Generation based on Token A Price and APY Chart 2: Line chart modeling APY based on Token A Price Chart 3: Anything else that could be modeled --- +Any other fancy charts you can come up with. The above might not be accurate, but you should be able to figure out what I need. I will let the bidding run...

Developer needed for small app related task

I am seeking an ASP .NET and Angular developer to create a comprehensive web application for an electricity billing system that will enable seamless customer and administrative experiences. Key Features: - Enable customers to create accounts, sign in and out of their account and recover forgotten passwords. - Create the ability for customers to check their billing...password system. Reports can be filtered and sorted by date range, customer profile, or invoice status. Ideal skills: - Proficiency in ASP .NET - Proficiency in Angular - Experience in backend user authentication procedures - Excellent UI / UX design - Prior experience in creating functional dashboard systems - Experience in handling databases and data filtering. for database connectivity use ssms(sql server manageme...

Looking for a skilled web developer to create a sleek and responsive standalone web app th...functionalities for equipment tracking, calibration scheduling, and reporting Ideal candidate should possess strong experience in web-based app development, UX design, and database management. Capability to create an intuitive user interface is critical, and understanding of equipment calibration fields is a huge plus. Preferred technologies include but not limited to JavaScript, HTML/CSS, Python, SQL, or Ruby/Rails. However, I am open to your expertise on the tech stack that will best serve this project's requirements. Please include in your proposal an estimate of timelines and previous examples of similar work. Let's work together to create a tool to simplify equipmen...

I'm looking for an experienced web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a profile solely...web developer to build a functional social networking website. Key Functionalities: - User Profile Creation: Users should be able to create a profile solely with their email and appropriate user input parameters. - Blog Postings: Users should be able to post blogs and comments on these blogs. Ideal Skills: The ideal freelancer for this project should be proficient in HTML, CSS, JavaScript, and SQL. Experience with creating social networking sites or similar projects would be a plus. They should be able to cleanly write code, create an intuitive user interface, and ensure a secure regist...

...system security and integrity through best practices * Providing information support for the administration team as needed * Participating in team efforts toward efficient and successful project planning including weekly virtual team meetings Job Requirements * 5+ Years Experience in backend or full stack development * Knowledge in ColdFusion (2018 or newer), Python, PHP, CFC, Javascript, SQL, MySSQL, Database Design, Server Management * Experience in front end user interface development,
HTML, and CSS * Knowledgeable in APls, both SOAP and REST * Knowledgeable in Windows server management * Strong problem solving skills * Forward thinking in all development * Strong time management skills * Self-starter * Detail oriented Projects You will Own or Assist in...

I need an experienced Revit expert with knowledge in basic design work. This task is specific for a small project, in which instructions are give. Turn around time is of the essence. Ideal Skills: - Experience in Revit Basic Design I have 4 parts (assignments) for this project. Show interest before I send the instructions.

...visualizations should be incorporated for users' easy and comfortable navigation The ideal candidate for this project should have strong experience and skills in developing with Wix and Wix Apps, SQL and integrating them cohesively. Understanding the importance of data management and the ability to integrate real-time updates into a simple yet functional interface will be critical for this role. Here's the full Scope of Work for integrating your system with Azure SQL and developing the necessary functionalities on your Wix Application: **Azure SQL Integration and Database Setup:** - Integrate the system with Azure SQL. - Create databases for **Customer Information**, **Customer Sizing**, **Certification Information**, **Purchase Information**, *...

...I can fix this for myself so I don't run into this problem again. • If you have a knack for teaching complex concepts in a simplified manner, you are the perfect fit. I wish to understand this aspect deeply, hence it'll be a bonus if you can assist in creating a workflow that I can follow to understand and execute similar tasks in the future on my own. Let's enhance my Fusion 360 skills one query at a time....

Small SEO Work Required........

I'm looking for a skilled full-stack developer to build the backend for my web application. The application should have: - User authentication: The ability for users...various types of data within the application. - API integration: The backend should be able to communicate with external APIs, enhancing the functionality and enriching the user experience. Ideal skills and experiences for this project include: - Proficiency in back-end programming languages such as Node.js, Python, or Ruby on Rails. - Strong understanding of database management and experience with SQL or NoSQL databases. - Previous experience with building secure user authentication systems. - Familiarity with integrating various APIs. - Good communication skills and ability to work collaboratively with a front...

I need a competent professional to smoothly facilitate the migration of my MSSQL 2019 database to a new server. Additionally, the ownership of SQL Management Studio must be changed effectively. Key job responsibilities: - Safe and efficient migration of the MSSQL 2019 database to a new server - Successfully transfer ownership of SQL Management Studio Ideal Skills and Experience: - Proven expertise in MSSQL 2019 and prior versions - Proficient in handling SQL Management Studio - Experience in successful database migration projects - Detail-oriented in project proposals Please note that only freelancers providing detailed project proposals will be considered. Your proposal should demonstrate your understanding of the project requirements as well as how you intend to ...

I require an expert in SAP Integration Suite for a project focused on integrating Salesforce, Slack, and SQL. With proficient experience in Cloud Integration, Open Connectors, and API, you'll be able to skillfully execute my requirements. Your main tasks will be: - Implementing SAP Integration Suite with Salesforce, Slack and SQL. - Ensuring real-time data synchronization between the systems. - Establishing automated data transfer protocols. - Enhancing the overall efficiency of business processes through these integrations. Your expertise in SAP Integration Suite, Cloud Integration, Open Connectors, and API, along with the ability to ensure real-time data sync, automate data transfers, and streamline business processes, will be crucial for this project.

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I need to convert a small 25mb .bak file to csv/xml. This is a backup of MSSQLSERVER2016 (MS SQL Server)

...should include essential features such as online appointment scheduling, patient registration, and detailed information on the hospital and doctors available. The primary users will be patients and hospital staff, so the user interface must be intuitive and user-friendly. Ideal skills: * Proficient in WordPress development * Experience in healthcare sector websites beneficial * Knowledgeable in SQL or other database management systems * Familiarity with responsive and mobile-friendly designs Key Customization Features: * Patient profile creation: Users should be able to create and manage their profiles effortlessly. * Personalized appointment reminders: The platform should send customized reminders to patients about their upcoming appointments to reduce no-shows. Your port...

...website coder to design a SINGLE PAGE static AND responsive website for a very small business owner. This webpage needs to be designed in HTML, JS and CSS. The description of the business (and the business NAME) and the website requirements are clearly laid out in the attached document. ALSO, the actual text that is to appear on the webpage is also provided. Our client would like this site completed as soon as possible. We have been using Freelancer for many years. We award projects based on coders who demonstrate their attention to detail and ability to deliver timely and professional, unrushed results. To demonstrate that you have taken the time to read the attached document carefully, please include the small business NAME in your bid proposal. Failure to do s...

I'm in need of a highly skilled .NET developer for my project. It involves .NET framework (specifically web forms) and a complex SQL database. Ideal Skills and Experience: - Strong expertise in .NET framework, particularly with web forms. - Comprehensive knowledge of SQL, able to navigate and manipulate complex databases. - Previous experience with large-scale projects requiring intricate database structures. Your application should focus on your experience in these areas and similar projects you've completed. Please, make sure to emphasize your accomplishments and results in your past work.

Hi, Please apply only individual. Agency can apply but budget should not be more than mentioned. Role : GCP Engineer (OTP) Exp : 7 + yrs SHIFT: IST Cloud Storage Buckets, BigQuery (SQL, Data Transformations and movement) Airflow (python, DAGs), DBT IAM Policies PyCharm Databricks (pySpark), Azure DevOps Clear and confident communication

...create Rcv1Doc objects. Define a class Rcv1Doc with attributes like docID, terms (a dictionary of terms and their frequencies), and doc_len. Tokenize text, remove stop words, and apply stemming using the Porter2 algorithm. Define methods like getDocId() and get_term_list(). Task 1.2: Define a query parsing function Create a function parse_query(query0, stop_words) to parse a query string. Tokenize the query, remove stop words, and apply stemming. Return a dictionary of terms with their frequencies in the query. Task 1.3: Define a main function Implement a main function to test parse_rcv1v2() and parse_query(). Print document details (docID, term count, doc_len), sorted terms, and save output to a text file. Task 2.1: Calculate document-frequency (df) Cr...

In this project, I'm seeking a Power BI expert's assistance to accomplish the following: - Development of data visualization using Power BI - Creation of intuitive dashboards and comprehensive reports I will provide data from classified sources, particularly Excel spreadsheets and SQL databases. Your task will be to integrate these platforms and generate compelling, easy to understand visualizations. The primary KPIs needed in the dashboard and reports will focus on: - Sales revenue: I'm interested in monthly, quarterly, and annual trends - Customer satisfaction: We'll track this through a set of predefined parameters. Your ability to illustrate complex data in a user-friendly manner will be paramount. Prior experience with interpreting sales data and custo...

I'm keen to find a well-versed ASP.NET MVC core developer to work on building a project from scratch. This task includes: - 4 Web Forms using Razor View and 4 Listing page with Filtering and Search feature. - Code first approach - Wire frames will be shared with shortlisted developer. - Entire code project need to share. - SQL Server DB. Key skills required: - Mastery in ASP.NET MVC core - Proficiency in Entity Framework and Identity Framework - Profound understanding of user authentication protocols - Demonstrable experience with responsive design - Ability in creating professional, corporate designs.

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

I'm looking for a lighting designer who can create an ambiance and highlight specific areas in my small, up to 50 seats, restaurant. The lighting design should follow a modern style. The perfect freelancer for this job should have: - Experience with restaurant lighting design - A strong portfolio reflecting modern designs - Great understanding of how lighting can create mood and direct focus Your proposal should include any relevant work examples, and an initial idea for the lighting layout.

I need someone to make a calculator (in Google Sheets) and some really nice charts to easily visualize the data as well. Token A = Variable market price from 0 to 10 USD max (or infinite) Token B = Always 1 USD Token A generates Token B automatically by staking it in a web3 contract. --- Calculator: Input 1: Amount of Token A Input 2: Token A Price Input 3. APY Output 1: Amount of Token B Generated Output 2: APY (Annual Percentage Yield) --- Chart 1: Line chart modeling Token B Generation based on Token A Price and APY Chart 2: Line chart modeling APY based on Token A Price Chart 3: Anything else that could be modeled --- +Any other fancy charts you can come up with. The above might not be accurate, but you should be able to figure out what I need. I will let the bidding run...

I'm in need of an MS SQL expert who can write complex stored procedures for my project. Key Responsibilities: - Develop and write complex stored procedures tailored to my specific needs Ideal Skills and Experience: - Proficient in MS SQL - Experience in writing complex stored procedures - Strong understanding of database design - Ability to understand and adapt to project requirements This project is vital to my current development, and I'm looking for someone who can deliver quality results. Please share your experience and approach to this task in your bid.

I'm currently seeking a design professional who specializes in small-scale, plastic packaging designs featuring pastel colors. This project will involve the following tasks: - Conceptualize and design packaging for a small product. - Use pastel colors to create a visually appealing design. - Incorporate our brand image into the packaging. The ideal candidate should: - Have extensive prior experience in designing product packaging. - Understand color theory and how to apply it in design. - Have a knack for creating compelling packaging that appeals to customers. - Be able to work with plastic. The chosen freelancer will need to deliver a design idea that is small, created primarily of plastic, and utilizes pastel colors effectively. Your creativity, as we...

I am seeking a freelancer with deep experience in .NET MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • I...MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • Identifying and resolving authentication-related errors I am currently encountering while using SQL Server authentication. The freelancer ideally could view these issues on my laptop setup and advise solutions accordingly. Knowledge of error diagnosis is critical. Understanding of Azure databases, .NET MVC projects and SQL...