Write sql statementdela

- 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.

I need you to write some content for a website. Sem vrhunski pisec vsebin. Ker imam zelo siroko znanje iz razlicnih podrocij, lahko pisem zelo hitro in vsebinsko mocne tekste.

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will have experience in the US time zone and be available for full-...time zone and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify - Familiarity with app development for Shopify - Store setup and configuration Industry experience is not a requirement for this project, any industry experience is acceptable. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to work in the US time zone and have X hours left available TODAY!" - where "X" is the amount of hours you have available ...

...pre-teens to brainstorm a theme inspired by the exhibits and then work together to create a collaborative piece of art. This activity strengthens communication skills, builds trust, and teaches the value of diverse perspectives in a final product. Cultivating Critical Thinkers: Fact or Fiction?: Museums often contain historical accounts or scientific information. Present pre-teens with a statement or scenario and challenge them to research the exhibits to determine its validity. This hones critical thinking skills, source evaluation, and the ability to differentiate between fact and opinion. Become a Detective: Many museums feature mysteries or historical whodunits. Encourage pre-teens to analyze clues displayed in the exhibits, interview museum staff (if possible) and pi...

...frame. #Requirements: - Extensive experience as a Data Engineer, Database Architect, or similar role with a strong focus on rapid project execution. - Expertise in handling tight deadlines and delivering complex projects quickly. - Strong understanding of API integrations and experience with RESTful services. - Proficient in relational database design and development, preferably with experience in SQL and NoSQL databases. - Experience with ETL tools and processes under strict time constraints. - Familiarity with CRM and MAP platforms like Salesforce and HubSpot. - Capable of creating detailed entity-relationship diagrams and data flow diagrams quickly. - Excellent problem-solving skills and ability to work independently in a fast-paced environment. - Fluent in English with outst...

I'm in need of a graphic designer who can create a corporate-style brochure for my business. The main project will be to design a professional, clean and sleek corporate-style brochure. I'll provide the necessary information about the company's services, vision, and mission statement to be included. Ideal Skills: - Proficiency in graphic design software like Adobe Illustrator, InDesign, or Photoshop. - Experience in corporate branding and brochure design. - Excellent communication skills to ensure the design aligns with the company's objectives. - Ability to work efficiently and meet deadlines.

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need a detail-oriented professional to help with my bookkeeping and prepare financial statements using Excel. Key Responsibilities: - Regularly update my Excel spreadsheets with day-to-day transactions - Prepare monthly financial statements for my business Ideal Skills & Experience: - Strong Excel skills, including advanced functions and formulas - Experience in bookkeeping and financial statement preparation - Attention to detail and a good understanding of accounting principles Please note: - The role is likely to require around 10 hours of work per month - I may consider transitioning to a more robust accounting software in the future, so experience with QuickBooks or Xero would be a plus.

...objective of this presentation is threefold: introducing our company culture and values, providing an overview of our internal policies and procedures, as well as showcasing employee benefits and perks. The presentation should fit within a 10-15 minute span, offering a succinct yet comprehensive outlook of the following aspects: - Company Culture and Values: This should include our mission statement and core beliefs. Visual artwork that suits our corporate identity must be incorporated to bring these elements to life. - Procedural Overview: Aim to depict company policies and the way work is achieved in our organization. - Employee Perks: Highlight the benefits and advantages that employees can expect from their association with us. The presentation is basically writt...

I'm searching urgently for an experienced PHP architect who can const...items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for payment method integration at the moment, the ability to seamlessly add these in the future is essential. My project requires immediate attention and the chosen freelancer needs to be able to commit and delive...

Assist in writing answers for 3 questionnaires for Grant application criteria for an Allied Health Company demonstrating the company's setup All answers for the criteria's are to be written within 750 word limits each. Assessment Criterion 1: Service delivery [750 word limit] Describe how your organisation will deliver the services in the identified ACPRs in the application. Assessment Criterion 2: Stakeholder Engagement [750 word limit] Describe how your organisation will cultivate or expand links with other service organisations, infrastructure and resources, including the Regional Assessment Services (RAS) and other relevant specialist services e.g. dementia supports. Assessment Criterion 3: Efficient and Effective Use of Grant Funds [750 word limit]

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. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above 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

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 have half of a research paper on Social Media Usage and Happiness, but I need someone to improve it and add citations. The paper should be 6 pages long. ### Focus Areas - **Introduction and Thesis Statement** - **Analysis of Research Findings** - **Conclusion and Recommendations** ### Requirements - You should have a strong grasp of sentence structure and clarity to enhance the existing content. - I expect you to bring your own research skills to improve the paper and add relevant citations. - Please ensure the essay is 6 pages long. - Previous experience in social science or psychology research writing is a plus. Please provide a timeline for completion with your bid. I'm looking for someone who can turn around quality work in a timely manner.

• 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...

I'm in need of a highly skilled writer to create an urgent ethical paper on justifying war in specific situations. Your task would be to: - Write a detailed, philosophical argument that justifies war in certain, defined circumstances. - Provide sufficient, logical reasoning and ethical principles behind the justification. I require a unique, thought-provoking and high-quality paper that showcases critical thinking and application of ethical theories. Ideally, the freelancer should possess a background in philosophy or a related field and have experience in writing about ethics, particularly just war theory. The paper should be completed as soon as possible. here is the email my professor sent about the paper- The paper is to be written in some standard word processor form...

...growth - Category growth plan - Data-driven analysis, recommendation, and plan The ideal designer for this project would have experience in business planning and strategy, as well as a clear understanding of the quick commerce industry. Strong visual design skills are a must, as this deck must be engaging and comprehensive. Find the details of the project below and I will share the problem statement later: Deliverables Please share a slide deck with max 8-10 slides covering the below: 1. Selection - how will we identify the right assortment for each store? - What data sources can we use to identify the selection gap? What data analysis techniques will you use to generate insights that will improve our selection? How will you hyperlocalise the assortment for each store? - How ...

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...

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.

Must understand I require an expert in financial statement analysis and forecasting. The project involves predicting financial trends over a three-year period. I only have cash flow statements available for analysis purposes. Key Responsibilities: - Analyzing cash flow statements - Preparing a three-year financial forecast based on the analysis - Highlight expected trends and give insights Ideal Skills: - Proven experience in financial statement analysis - Proficiency in financial forecasting - Expert ability to analyze and interpret cash flow statements - Keen attention to detail and accuracy - Excellent analytical, computational, and mathematical abilities.

...Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communication between Power BI and the SQL databases, Online APIs. - Implementing a user-friendly interface with basic filtering and sorting options. If you are confident in your Power BI and AI skills, and have the technical expertise to deliver such a project, I would love...

I urgently need a p...specifically in relation to mergers and acquisitions. The main deliverable I expect is: - A detailed case study analysis addressing the topic Research topic: In the midst of increasing global crises, the World Bank is undertaking an “evolution” to deliver development impact more effectively and efficiently for people and the planet. In this context, do you agree or disagree with the following statement? “The World Bank should prioritize support for global public goods and addressing cross-border challenges that affect many countries, as opposed to individual member country-specific challenges and development priorities.” Discuss the potential legal and policy considerations with reference to the World Bank’s Articles of Agreement,...

As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.

...bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and advance functionalities. Database Management Monitoring and Performance Optimization and much more If you're up for the challenge and want to be part of something special, let&#...

...JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML, JSON, Junit, and JavaScript. - Experienced with Eclipse/Intellij, PL-SQL...

I need a dependable, detail-oriented accountant with an intermediate level of experience specializing in bookkeeping and financial statement preparation. Key responsibilities: - Reliable bookkeeping. - Comprehensive preparation of financial statements. Ideal candidate should have: - Proficiency in QuickBooks accounting software. - Demonstrated ability to handle bookkeeping and state financial statements efficiently.

I am looking for an experienced writer with a sound understanding of TikTok and marketing tactics to pen a comprehensive book. The book will serve as a guide for individuals aiming to utilize TikTok for their marketing endeavors. The ideal candidate will: - Have an in-depth knowledge of TikTok and its features. - Be familiar with the best practices for content creation on TikTok. - Understand effective TikTok advertising strategies. - Be proficient in interpreting and utilizing TikTok analytics and measurements for optimum results. - Produce an engaging and easy-to-follow guide suitable for a versatile audience from small business owners to social media influencers. No specific writing samples have been requested for this project; however, showcasing your understanding of TikTok'...

...month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. ...

I need a proficient researcher and writer to handle a job of writing my PhD Confirmation of Enrolment document. The document has already been written but need to make it up to 6000 words or more. The field of study of my PhD is Translation. The research investigates the translation of specific transcriptions translated from Arabic into English and will be doing a parallel corpus study to do that. Key task: - Finish writing my PhD Enrollment Confirmation document while maintaining the academic integrity and tone of the document. - adjusting the title of thesis Ideal skills: - Experience in academic writing and research is highly preferred. - Fluent in English and Arabic. - Knowledge in academic regulations and terms would be an advantage. Only experienced professional researchers and ac...

I am currently ...currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completion. I need this...

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

...for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies...

I am in need of a competent data engineer for a small-scale data analysis task. - The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience wi...The project primarily revolves around performing data analysis. - The ideal candidate should be proficient in data analysis techniques. - Previous experience with data engineering will be a significant advantage. Your role will mainly involve performing data analysis tasks, so a deep understanding of data engineering and analysis is essential for this project. A strong background in Python, R, or SQL is highly preferred, though not mandatory. Please note that the project timeline is quite flexible, so you will have ample time to complete ...

...the following areas: - Internal Controls Review: The freelancer will be responsible for evaluating and testing our internal controls to ensure they are effective and in compliance with industry standards. Experience with COSO framework would be highly beneficial. - Financial Statement Audit: The selected professional will be tasked with auditing our financial statements to provide an independent and objective assessment of our financial health. An in-depth knowledge of GAAP and experience with financial statement audits is a must. - SOX Compliance Review: The freelancer will need to review our processes and procedures to ensure compliance with the Sarbanes-Oxley Act. A thorough understanding of SOX requirements and experience with compliance reviews is essential. The...

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project requires strong c...

We need a highly skilled individual with extensive experience in document and presentation design. You will be tasked with: - Modernizing our statement of work, proposals, contracts, and PowerPoint presentations. - Updating layout and formatting. Bring outdated formats into the modern age with a refreshing touch that reflects our brand. - Revising content and language. Our output needs to resonate with the audience, so a quality copywriting ability is crucial. - Adding visual elements and graphics. You'd pepper appropriate visuals throughout our documents and slides, enhancing understanding and engagement with our messages. The style we envision for this task is clean, modern, and professional. If you have an understanding and feel for our described style, we want to work wit...

write reflective report as a Risk manager for project management 1k-1.5k words in 24 hours Send me the details

Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience i...

...Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their progress. Ideal skills and experience for the job would be expertise in web development, specifically in creating ticketing systems. Familiarity with user management, role assignment, and priority matrix are essential. Fluent in programming languages like PHP, JavaScript, and proficiency in SQL for a robust database system is a must. Creativity in UX/UI design for an engaging and user-friendly interface should be apparent. It is also required to handle incoming and outgoing E-Mails. I don't want to have further frameworks involved. Core PHP is required and JS like Bootstrap 5, JQuery are ok.I have my own authentication system in place. Based on the role different in...

I am in need of a skilled PHP programmer to address an "undefined variable" error within my user authentication system. The system primarily relies on email and password authentication. Key Requirements: - The error lies within the user authentication system - The primary method of user authentication in the system is email and password Ideal Skills and Experience: - Proficiency in PHP, SQL - Experience with user authentication systems - Familiarity with handling undefined variable errors - Understanding of secure email and password authentication Your task is to identify the root cause of this error and implement a solution to rectify it. Please provide specific examples of similar work you have done in the past.

...efficient manner. Key Responsibilities: Design and implement API integrations using CloudQuery. Be able to write DBT transformations. Extract and manipulate data from various data sources (SQL, NoSQL, APIs, etc.). Ensure the integrations are scalable, efficient, and maintain high performance. Collaborate with our team to understand requirements and provide technical solutions. Write clean, maintainable, and well-documented code. Troubleshoot and optimize existing integration solutions. Desired Skills and Qualifications: Strong NodeJs skills Ability to read Python & Go code Abiltiy to write DBT transformations Strong experience with CloudQuery and its features. Proficient in SQL and database management systems. Solid understanding of API integra...

...month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. ...

I'm looking for a skilled .NET developer with experience in JSON, MS SQL, AJAX, and HTML to help me migrate my existing website to a new template. The specific features that need to be migrated are the design layout and content pages. To give some context, the primary objective of this migration project is to enhance the functionality of the website. An ideal candidate should be well-versed in enhancing user experience and updating design aesthetics. Your role will be pivotal in ensuring that the new template not only preserves the existing features but also improves the functionality. The key difference I'm aiming for in the new site is faster loading times. This means that you should be able to optimize the site's performance and ensure that the migration process ...

...rental system e) Online car rental system The final submission should include: 1) Report describing the project that includes: a. Introduction b. Web site design c. Web site development: the main files created: articles, categories, modules, and database. d. Screenshots of the website e. Conclusion f. References 2) One folder that holds all the subfolders of categories, articles, menus, modules, SQL 1 files, videos, banners, and images....

I am in need of a skilled accountant who can prepare a Profit and Loss statement, Balance Sheet, and Trial Balance. As a retail business owner, understanding our financial position is essential. Key responsibilities include: - Creating P&L statements - Drafting balance sheets - Concocting trial balances The ideal candidate would have experience in retail accounting, giving them the ability to understand the specific needs of my business quickly. Please note the frequency of this task is undetermined at this time, to be discussed after engagment. Your flexibility and willingness to adapt to change is important. I look forward to a productive partnership.

I am in immediate need of a Python expert who can extract data from external website and store in an MS SQL database. freelancer with extensive experience in data extraction from varied sources would be highly desirable. The skills and experience required for this job includes: - Extensive knowledge on Python-based data extraction methods - Proven experience with managing and manipulating MS SQL databases - Ability to adapt to multiple and potentially unexpected data sources - willing to work via anydesk for final installation of the project Given the urgent nature of this project, only those who can demonstrate a commitment to quick turnaround times need apply.