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

...indicators and monitoring mechanisms in accordance with our goals. 7. Providing strategic marketing direction in accordance with our budget and business goals. The ideal candidate should have: - Proven experience in marketing strategy and digital marketing tactics. - Strong analytical and problem solving skills. - Ability to work as a flexible project-based consultant. - Knowledge of marketing automation, website analysis and CRO tools. - Excellent communication skills to discuss findings and recommendations. As a young startup, we need a marketing partner who can guide us in building a strong brand presence, attract our niche audience and drive growth through effective strategies. If you have the relevant expertise and are interested in partnering with us, please respond wit...

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

E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago

I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.

...professional to create a chatbot integrated with Mikrowisp The chatbot will serve as a tool for registered companies to interact with their customers. Key Features: - Options menu: The chatbot must provide the options menu, and a limit of queries to exit the chatbot and transfer the advisor. - Invoiced amount query: The chatbot must provide users with a simple way to find out the amount owed and due date. - Consultation of the user profile: The chatbot must respond to the contracted profile. - Spanish Support: The chatbot needs to be capable of interacting with users in spanish - Company Management: The ability to enable, disable, or delete companies from using the chatbot should also be integrated. Ideal

I'm looking to create an application using NoCode developmen...credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get more deta...

? Seeking HubSpot Automation and Integration Expert! ? Please send the proposal for your monthly price, we are wanting to find a full-time person who can join our team . We're on the lookout for a skilled HubSpot Automation and Integration Expert to join our team. Responsibilities - Manage and ensure the cleanliness of databases across various clients. - Handle API integrations and effectively connect various systems to HubSpot using tools like Zapier and Make .com. - Optimize HubSpot objects and automate processes, including form submissions that trigger deal creations and associate contacts. - Develop and manage workflows and lifecycle drip email campaigns tailored to different client needs. - Oversee the creation and analysis of custom reports for diverse clients. -...

I'm keen to collaborate with a developer adept in Chrome extension and AI, in particular, machine learning. The key objective is to establish a Chrome extension capable of executing automated tasks. - Chrome extension work-flow - When I call on Google meet or Zoom, extract the questions of the recruiter or technical manager. - Making the answer (will use ChatGPT or AI) with the questions extracted and show it to popup on current web page. - Skills and Experience needed: - Proficient in Chrome extension development - Solid experience in AI, specifically with Machine Learning - The Task: - The extension must be proficient in automated tasks. When it comes to the type of automated tasks, the focus is on AI capabilities. With your expertise, I'm confident we can crea...

I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...

I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, a...

I need an automation that can set one or more predetermined replies to top tweets within a certain time. In other words, this automation will allow me to choose the following settings: "Every [frequency] hours, search for top tweets with the word [keyword] that were tweeted within the past [time] hour, and reply [predetermined reply] to [number of replies] tweets. Every [functioning hours] hours it will stop for [pause hours] hours." I will not need to have technical knowhow to choose these. You will need to test this to make sure it works and mimicks human behavior so it doesn't get us banned. You will also find a way for it to work on its own, without any need for me to keep my laptop on. If this is something you can do, please give me a description of how it...

I'm in need of a talented DevOps engineer, proficient in AWS and GitHub Actions, to assist with an array of DevOps tasks. Key Tasks: - Deploying web applications - Infrastructure automation - Continuous integration and deployment (CI/CD) The applications are built using Java, requiring deep expertise in this language for effective collaboration. To succeed in this job, a solid understanding of web applications, coupled with extensive experience using AWS and GitHub Actions, is critical. Automation skills are also vital. Join us and help make our Java web application deployment seamless and efficient!

...this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Column Selection: API users should be able to specify which columns to retrieve in the query. Filtering and Sorting: Support comprehensive filtering and sorting capabilities to navigate through data efficiently. Pagination: Implement pagination to handle large datasets effectively. Aggregation and References: Enable aggregation of data from child tables and retrieval of related data from master tables (e.g., retrieving a customer's name when querying...

For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.

I have a four-field form on my website (Name, Email, Website URL, Comments) that I'd like to automatically submit. Preferably, the tool used for this should be able to complete the form and submit it without any manual intervention. Ideal Skills and Experience: - Proficient in web development and automation - Experience with form submission scripts or tools - Knowledge of web forms and their handling - Understanding of data submission and validation in web forms - Familiarity with website structures and data submission methods.

I'm looking for a Jira specialist to help me create a custom automation that will generate a child issue for each paragraph in a parent issue. The child issue should inherit all attributes of the parent issue. Each paragraph in the parent issue will automatically create a separate child issue based on that paragraph. A way for Jira automation to identify a double line break needs to be created. The automation should auto populate all the child issue field with the same attribute as the parent. See attachment for example Key Requirements: - The child issue should be created in Jira Cloud. - The automation should be triggered when a parent issue's description is updated and contains a double line break. - The child issue should mirror all attributes...

...capturing and PCB layout. BOM (Bill of Materials) with sourcing options. Documentation for assembly, testing, and troubleshooting. Qualifications: Proven track record with PCB design for power-intensive and multi-function projects. Proficient with voltage regulation techniques in PCB designs. Familiarity with RP2040 microchip and serial communication protocols. Proficient in electronic design automation (EDA) tools. Strong analytical skills and attention to detail. Proposal Requirements: Portfolio showcasing relevant projects, especially those involving power management and microcontroller integration. Detailed proposal including timeline, milestones, and budget estimation. We are excited to collaborate with a professional who is passionate about bringing advanced electronics p...

I am looking for a highly skilled professional who is proficient in coda.io. The right candidate will assist me with: - Creating 1-5 templates tailored to my business needs - Designing intuitive dashboards to streamline data visualization - Implementing moderate complexity automation processes This role demands a high level of attention to detail and a deep understanding of 's capabilities. Ideally, you will also demonstrate prior experience in template creation, dashboard design, and automation within similar platforms. Proficiency in understanding business requirements and crafting solutions that enhance operational efficiency is vital for this position. Get in touch if you harness these skills and are ready for a moderate level of technical complexity.

I'm looking for a skilled professional to automate the task of entering data from specific Outlook emails into a structured format. The ideal candidate will have experience in: - Automating data entry tasks, and particularly from emails. - Working with Outlook's API or related tools. - Developing scripts or software to extract and categorize email content based on specific criteria. Key requirements include: - Extracting and processing data from emails based on criteria like sender's identity and keywords. - Ensuring the data is accurately transcribed and structured according to a predefined format. - Ensuring the process runs smoothly and efficiently, with the ability to handle a large volume of emails. - Providing a user-friendly solution, which could potentially be adju...

Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server

I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.

I am looking for an experienced developer to create a mini software that will automatically fill out a specific Google form. The software should be developed using and Pupeteer/node js, employing Stealthfox to create cookies and for functio...Pupeteer/node js, employing Stealthfox to create cookies and for functionality. Key Requirements: - Utilize for creating a browser profile and Stealthfox for cookie generation - Capable of interfacing with - Automated form completion for a Google form Ideal Freelancer: - Skilled in Pupeteer and node js for browser automation - Experience with and Stealthfox - Proficient in web form automation In your application, please highlight your experience in similar projects. Thank you.

Being a product designer who primarily focuses on automation, I'm seeking skilled mechanical engineers to help design a new product that will optimize our manufacturing processes. The main goal of this project is to introduce mechanical designs that would improve efficiency, increase durability and reduce costs in our production line. The following task scopes will be involved: - Conceptualization of innovative mechanical designs. - Analysis and evaluation of mechanical systems. - Product development incorporating automation in manufacturing processes. The ideal freelancer for this job will have: - Significant experience in mechanical engineering. - Expertise in automation and manufacturing processes. - Proficiency in CAD software for designing. - A solid unde...

I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.

Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India

I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...

I am seeking a skilled Python developer with expertise in troubleshooting to resolve an issue with an application. The main purpose of the application is data analysis, web scraping and automation. Currently, the application has been crashing or freezing right at the startup. The ideal candidate for this job should have: - Extensive experience in Python programming - A background in data analysis, automation and web scraping domains - Proven track records troubleshooting application start-up crashes or freezing - Good problem-solving skills, ability to diagnose and fix bugs efficiently. Your main task will be to identify and fix the issue causing the application to crash during the startup. This is a critical project, so a timely resolution is vital.

I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...

I'm seeking an expert SharePoint developer to create a comprehensive solution for my company. We aspire to establish an efficient document management system, streamline our workflow automation, enhance collaborative tools, and set up intranet, internal websites. Key Features: - Document Management: The system must offer us precise control over our documents, storing, organising and managing them effectively. - Workflow automation: The SharePoint solution should provide a platform where routine tasks are automated, improving efficiency in our business processes. - Collaboration tools: The system should enhance our team collaboration making work more flexible, organised, and productive. - Intranet & Internal websites: We require a system that allows for effective...

I'm looking for a freelancer who can help me automate my JIRA tasks by creating a subtask for every paragraph within the Description field. Key Requirements: - The automation should trigger whenever there's a double line break in the description. - The subtask should inherit all attributes from the parent task, including Summary and parsed Description. - The parsed paragraph from the parent task should be included in the subtask. Successful freelancers should be able to: - Build JIRA automations - Be familiar with the JIRA system and the programming languages or tools that can be used for creating such automations. This includes JavaScript and any other language that JIRA supports. Your application should demonstrate your expertise and experience in this area. Please s...

I urgently need an expert Laravel developer to collaborate on a web application development project. The specific features and ...an expert Laravel developer to collaborate on a web application development project. The specific features and functionalities of the project are yet to be defined, but a vast knowledge in Laravel is key. Key skills and Experience: - Proficiency in Laravel and PHP - Understanding of MVC design patterns - Knowledge of front-end technologies, such as JavaScript, HTML5, and CSS3 - Familiarity with SQL/NoSQL databases - Excellent problem-solving skills The timeline for this project is ASAP, so the ability to work under pressure is required. If you have experience in web applications, APIs, or both, it will be advantageous. Let's collaborate on this ex...

I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.

I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data sets within the software...

We have a 2D project in Autocad, and we need to model it using Aveva's E3D software. For this need, we need to model the disciplines of: Civil; Mechanics / Piping (we have already modeled the piping and can deliver it via ); Electrical; Automation / Instrumentation. We will send all projects in the 2D version. It is necessary to create the database using Brazilian technical standards for the petochemical area, which we will provide. We need to receive from this project: - Database; - Plants and Sections extracted from E3D; - Lists of Materials. The deadline for delivering the project is 04/22/2024. All projects must be configured and delivered in Brazilian Portuguese. We will attach all projects for preparation and will be available for questions during the preparation. W...

...feature would be an autofill functionality for the following details on the registration panel: - Name - Date of birth - Mobile number - Address - Email address Apart from this, the ability to generate random inputs for these fields is a must to ensure a smooth, streamlined registration process. Appropriate technical skills that would be beneficial for this project are: - Strong understanding of automation software development - Practical experience in random data generation - Knowledge on scripting to autofill forms - Experience with IRCTC's platform or similar would be a clear advantage. In conclusion, I am eagerly looking for a specialist who can swiftly construct a solid, reliable automatic ID creation solution. Apply if you possess the required skills and you're ...

I'm in need of a skilled DevOps expert to assist with some key tasks to improve my personal infrastructure: - Automating Deployments: I'm looking for automation of deployment processes. The ideal candidate should be able to streamline deployment, minimize errors, and save time. - Monitoring and Logging: Monitoring and logging are crucial for ensuring that the infrastructure is performing optimally. The DevOps specialist should be able to set up effective monitoring tools and logging systems. The candidate should have prior experience with: - AWS (Amazon Web Services), Docker, Ansible, Jenkins etc

I'm looking for an expert in Power Apps to enhance my project with additional functionality. As with most Power Apps endeavors, this one aims to automate processes, create a mobile app, and manage data a...this one aims to automate processes, create a mobile app, and manage data and workflows. The project has a broad scope and I need a detail-oriented professional who can ensure everything runs smoothly. Despite skipping a few questions about the specifics, I will provide complete details once we start our discussion. Ideal Skills: - Extensive experience in Power Apps - Strong understanding of automation processes - Excellent communication skills - Attention to detail - Ability to integrate systems - Experience in mobile application development - Proficiency in data managemen...

I need a simple form that will look good on a small screen iPhone and also a big screen iPad. The form will collect NAME EMAIL CITY PHONE NUMBER phone number will be a formatted 10 digit max, and email will need validation for properly formatted. This will t...revert form back to a page that says success, and then auto redirect to the form page. The form page will look neat and clean and also contain a couple lines of text and our logo. You will use the existing config file to connect to our base, instead of creating a new one. This project needs completed today and should only take an hour to complete. This is to be written in php 8.2 and connected to sql dbase. You will be paid $30 when it is complete and verified to be working on our server. Ping me if you can complete ...

I have a database that I need to be cleaned up. The main task is to remove duplicate entries. Key Points: - Main Task: The primary goal of the data cleaning project is to remove duplicate entries in the datab...duplicates should be automatically deleted, not merged or manually reviewed. Ideal Skills & Experience: - Database Management: A strong background in database management is crucial for this task to ensure the data is processed correctly without compromising the database integrity. - Data Cleaning: Experience with data cleaning processes, especially in handling duplicate records, is important. - Automation: The ability to automate the deletion of the duplicates efficiently and accurately is essential. Please bid if you have the necessary skills and experience to handle...

I'm looking for an expert in email and WhatsApp marketing automation, particularly in the Italian language. Key Responsibilities: - Designing and setting up automated email sequences with high open rates - Creating engaging email campaigns tailored for both existing and potential customers - Designing and implementing visually appealing email templates Additional Details: - Target Audience: Both existing and potential customers - Frequency of messages: Weekly Ideal Skills: - Proficiency in Italian language - Proven experience in email and WhatsApp marketing automation - Excellent design skills for email templates - Strong understanding of customer segmentation and targeting - Ability to conceptualize and implement highly effective automated email sequences - Excelle...

...to take part in my ongoing web development projects. The main goal of the project is to enhance an existing application. Requirements: - Proficiency in .NET for backend development - Strong experience with Angular for frontend development - Excellent understanding of SQL Server and MongoDB databases - Previous work with DevExpress is essential Your responsibilities will include: - Developing APIs using .NET for enhancing the application - Integrating Angular for improving the frontend - Ensuring seamless operation with SQL Server and potentially MongoDB Ideal candidates should have a strong understanding of web development and be able to contribute effectively to enhancing the current state of the application. The ability to work with a team, meet deadlines and commu...

I need a Terraform script that can provision a compute instance in Oracle Cloud Infrastructure (OCI), and automatically mount volumes to my desired mount points using user_data. The key requirements for this project are: - Creation of a compute inst...instance on Oracle Cloud Infrastructure - Proper mounting of volumes to specific mount points - The mounting of the volumes should be done using user_data Ideal Skillset: - Proficient in Terraform scripting - Extensive experience working with Oracle Cloud Infrastructure - Strong understanding of volume mounting and user_data configuration - Knowledge of best practices for cloud provisioning and automation Please note that this project is specifically for Oracle Cloud Infrastructure, and bidders should have prior experience with this...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking for an experienced Dev...the CI/CD pipelines - Ensuring the smooth and efficient flow of code from development to production - Addressing any issues that may arise in the deployment process - Suggesting and implementing best practices for CI/CD in Python projects The ideal candidate should have: - Proven experience in implementing CI/CD pipelines for Python projects - Strong understanding of infrastructure as code and automation - Proficiency in tools like Jenkins, GitLab CI, or similar - Good knowledge of containerization technologies like Docker - Familiarity with cloud platforms like AWS or GCP - Ability to troubleshoot and optimize performance issues in the deployment process. Please respond with your relevant experience and successful projects you have handl...

Hi, Job Title: Senior Developer - SQL Server Analysis Services Experience : 5+ Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication s...

I need an expert to help with advanced troubleshooting and optimization for my Oracle database. The ideal candidate should have: - Proven experience in database administration. - Proficiency in Oracle database. - Expertise in database troubleshooting and performance optimization. - Adept in using SQL Developer for managing database tasks. You'll be handling tasks such as: - Identifying and resolving performance issues. - Suggesting and implementing optimizations. - Monitoring database activities to ensure smooth operations. Your role will be crucial in ensuring the efficiency and security of our Oracle database.