Sql get date jobs

...of CRM and the lead us to the CRM number CRMxxx We have many Tasks by numbers: T1 …….. To T35 For each task we can set up date, hour and the way to be done, in main page and by email we will receive alert for task that need to be done with number of task, number of CRM (client number) and the way that need to be done (W, Emai, SMS, Tel, Phone call, …). When we set up the task we can see it as the task is SET UP Some of the task must be done by email by SMS by WhatsApp by telegram by Viber and the phone call, when we do it for example by email with tick it, and it's recorded with a date and hour, when we receive receipt of email, we tick it and it's recorded with the date and hour that we receive receipt of email, the same way by What...

I'm urgently in need of a qualified developer to create a pipeline utilizing DBT and SQLLITE. T...appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fixing capabilities Deliverables: ● A DBT project containing models for company_analytics and skills_analytics tables. ● SQL scripts or DBT models to process JSON files and populate the analytics tables. ● Instructions for running the DBT command to process the data and execute data quality checks. ● Documentation on adapting the pipeline for continuous file deliveries and suggested additional data quality me...

I am looking for an experienced developer or team who can create a social networking app for both iOS and Android platforms. This app is specifically targeted towards idol chasers - fans who enjoy interacting an... - Direct Messaging: Instant communication between users will keep the community alive, whether users want to plan events or simply chat. You should be proficient in developing secure messaging systems. - Blog: Allowing fans to blog about their idols can help to spark active discussions and attract new users. Ideal candidates should have proven experience in creating similar apps, and be up-to-date with the features that create an engaging and safe space in social media. A sense of enthusiasm and understanding for the community of 'fan or idol chasers' is desire...

I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Loc...-Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow column in Ex...

I need a social media expert with profound knowledge in stock market who could distribute information daily on Reddit, Facebook, and Twitter. Key tasks: - Distribute stock news, analysis, and recommendations on a daily basis on aforementioned platforms - Must be up-to-date with what’s happening in stock market and accordingly distribute relevant information - Promptly answer any comments or queries to maintain engagement Ideal freelancer: - Experience with social media management - Basic understanding of stock market terms - Excellent communication skills - Proactive, punctual, and reliable

I am looking for a skilled developer to create a Windows-based application that can interact with a remote database. The application should primarily focus on retrieving and generating website sitemaps based on different criteria. The ideal candidate should have: - Proficiency in Windows application development - Strong experience in working with databases, particula...in working with databases, particularly remote databases - Knowledge in data retrieval and data update functionalities - Ability to understand and incorporate additional requirements as the project progresses Please note that the selected freelancer may need to provide examples of past work and project proposals. Note: Application should be able to connect different type of databases such as MS SQL Server, MySQL, O...

I'm experiencing some problems with my current Shopify 3.0 setup. The functionality of the custom app in question centers around the deprecated API feature. In particular, the issues have been cropping up around the 'Analytics' API endpoint which has been deprecated. I am in need of a developer skilled in Shopify app development who understands the importance of staying up-to-date with API changes, and can resolve this issue swiftly. Ideal Skills and Experience: - Proficiency in Shopify API - Familiarity with Shopify 3.0 - Strong understanding of deprecated API challenges - Experience in custom app development - Knowledge in 'Analytics' API endpoint

I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...

Dynamic Field Integration: Addition of customizable fields such as text inputs, date pickers, radio buttons, checkboxes, and select dropdowns within the admin panel. User Registration Form Customization: These dynamic fields will be incorporated into the user registration form, allowing for a more tailored data collection process. Admin Panel Search Functionality: Enhancements to the admin panel to include search functionality that utilizes the newly integrated fields. This will enable admins to search user data effectively based on the customized fields.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I'm currently looking for an experienced Android developer to help bring a new project to life. As the project parameters are still undefined, I'm seeking someone adept at working with client input to identify, design, a...likewise undefined, but may lean into areas of e-commerce, social networking or entertainment. Key qualifications for this role include: -Strong portfolio of previous work -Experience with client-guided workflows -Excellent communication skills, with a willingness and ability to recommend options and solutions in key areas. Timeline is currently flexible, with the possibility of an ASAP start date or ongoing work. Please bid with this ambiguity in mind. You will be kept well informed as more information becomes available. Thank you for your understan...

As a business user, I need assistance with the configuration of SSRS Reporting Service on a staging environment. I have configured the WebPortal...reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs ...

... we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate with a dedicate...

I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. For the view/UI React/It's front-end Library Setting up server, Use , which we'll use it for serve our front-end to talk with our DB Which is MongoDB, the DataBase. To deploy MERN stack app for free, first build your React frontend. Choose Netlify or Vercel for frontend hosting. Connect your GitHub repository and deploy the React app. For the server, select Heroku. Prepare your backend, set environment variables, and follow Heroku's deployment guide. For the database, use MongoDB Atlas, their free tier suffices. Connect your backend to MongoDB Atlas using its URI. ...

Hello, I have a WordPress website with dokan and I want sellers to be able to obtain a donation, currently the site does it with a plugin but I want to keep a commission from those donations. It is acceptable to install another plugin. Currently it does this with a PayPal donation plugin and gravity forms. Write ragnar to know that you read the work, Knowledge of WordPress, Dokan and PayPal donations is essential.

I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Locat...Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column in Ex...

I am looking for a professional Matterport photographer in Gocek, Turkey who can capture the key areas of my yacht and produce a high quality virtual walk through tour, as well as a set of less than ...Experience in capturing property - if possible in the boating industry - Ability to create a detailed virtual walk through tour - Good eye for capturing high quality images Please note that the interactive features part of the project is optional. If you have experience in adding interactive features to Matterport tours, please let me know in your proposal. I will meet you at the boat (at a time and date to be agreed) and be there in case you are unsure what is required. The only skills required are that you should be experienced in property photography and production of Matterport...

Please bid based on the actual price you believe it will cost, not just to get in our inbox. We are a hosting company looking to automate our services through our WordPress site. This project involves two main tasks: creating a custom WordPress hosting management plugin and integrating Snipepay as a payment gateway in WooCommerce. Our hosting company currently sets up client accounts manually through a control panel that supports API integration. The successful development of this project requires extensive knowledge of this API to enable full automation of the account setup, hosting package ordering, and management processes directly from our WordPress site. The developer will need to ensure seamless communication between our WordPress interface and the control panel's API, e...

Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )

Currently, our website faces two main obstacles—outdated design and poor user experience. - Outdated Design: Our website needs a modern, sleek makeover. Anyone who is up-to-date with the latest industry trends to give our website a well-deserved refreshing look, is encouraged to apply. - User Experience Upgrade: We're seeking a professional who can improve the layout and navigation of our website. A revamp that would turn website interaction into an engaging and hassle-free experience. We do not have specifics relating to any user experience issues except for a need for an improved layout and navigation. So, a broad understanding of potential UX pitfalls and user-friendly design savvy is crucial. The perfect candidate will have a background in the latest design tren...

We are looking for women to model our products. Experience is NOT required but is a perk if you have some! Don’t worry about a specific date for the photoshoot. If we choose you, we will pick out a date together! You will be able to keep all of the products that you model and photos will be sent to you incase you want to post them on your personal social media pages! All sizes and races are welcome, we are looking for diversity!

This job will be on a per project basis where you will have 2-4 projects per month. You will only be asked to edit specific scenes where we need VFX/ motion graphics (Not entire videos). We will agree on time and date for deliverables and you can work on your own schedule. Must have experience and should share 1 2 videos

...Pages and a Blog * Homepage: Main landing page * Job Board (leverages WP Job Openings plugin) * 4 subpages: 1 for each of our services 1. Employers seeking permanent placement candidates 2. Companies seeking consultants 3. Executive Search 4. Job Seekers * Blog page * Standard blog functionality * Acts as an index * Can add blog posts via Wordpress * Searchable by date, keyword, category, etc. The menu will include links for the homepage, “Our Services,” Job Board page and blog page. The 4 subpages will be linked in a submenu under the “Our Services” heading. The blog menu entry can be removed from the menu so as not to be accessed until I choose to turn it on. Homepage should highlight our 4 services and include royalty f...

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.

...alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains th...

I am seeking an experienced Dynamics CRM 365 developer with Virtual Entity expirence. I have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if...

As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.

...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...

Hello, I need to add a function to this free add-on, the add-on allows to add a start and end date, but I need that start date to be set automatically when I buy it and the end date as well. I need to create 3 options for 3 types of products. - Monthly option (30 days from product purchase). - Quarterly option (90 days from product purchase). - Yearly option (365 days from product purchase). It is quite simple, just add a checkbox to enable these options and the start and end date is calculated automatically when the product is purchased. Plugin for check the code: Thanks a lot. Best Regards.

I'm seeking an entry-level candidate for a full-time customer service, data entry, and sales & marketing role. Key Responsibilities: - Providing top-notch customer service, handling inquiries and resolving any issues that may arise - Accurately entering data, ensuring the maintenance of up-to-date and correct records - Assisting in sales and marketing efforts to drive business growth Ideal Candidate: - Entry-level professional eager to learn and grow in the industry - Strong communication and problem-solving skills - Proficient in data entry and customer service systems - Basic understanding of sales and marketing principles This role offers a competitive salary range of Rp1.500.000- Rp3.500.000 per month and the opportunity to work full-time. If you're a dedicated ...

We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...

I require a professional data scraper, ideally with experience in handling image retrieval. The task will involve sourcing and scraping image data from various undisclosed sources. The type of images to be scraped has not been spec...handling image retrieval. The task will involve sourcing and scraping image data from various undisclosed sources. The type of images to be scraped has not been specified, providing an open spectrum for data collection. However, previous experience dealing with diverse image types is highly beneficial. The deadline for this project has not been outlined, indicating flexibility on the completion date. Ideal Skills: - Expertise in data scraping - Strong experience handling image data - Ability to source from various platforms - Flexibility with time m...

I need someone skilled in search engine optimization, particularly for Google, to enhance the visibility of my study abroad website. I'm targeting a diverse spectrum of users, from high-school students to college students, to professionals who may be interested in international education opportunities. Here's what the project involves: - Developing and implem...in attracting more visitors but also in making sure those visitors take the action we want them to - in this case, engaging with our study abroad opportunities. The successful candidate should have a successful portfolio of similar SEO projects. Any experience within the educational field or knowledge about international studies will be a plus. Solid understanding of Google algorithms and up-to-date SEO pract...

...principles, and security best practices. - Effective communication skills and a collaborative approach to project management, including regular updates, feedback sessions, and milestone reviews. - Demonstrated ability to deliver high-quality projects on time and within budget, with a commitment to customer satisfaction and continuous improvement. **Project Timeline:** - Start Date: [Today] - Expected Completion Date: [end of the week ] **How to Apply:** Please submit your proposal outlining your experience, relevant skills, and approach to building the Crypto Host platform for Bitcoin transactions. Include examples of previous work or portfolios that demonstrate your expertise in cryptocurrency development, particularly with a focus on Bitcoin (BTC). Additionally, provid...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

...need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in ...

I'm looking to upgrade my current system, perhaps keeping the current Opencart (V1.52) system and working with it where possible... unless its deemed a rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart v...  4. Any other 3rd party systems (including internally) that the website communicates with (sending data either way) and any data grabs.    NO 5. Confirmation of payment gateways used. Realex (redirect to payment interface), PayPal   6. How the databases (products, customers, orders) are stored and if the data can be exported. Standard OC table structure… yes it can be exported as SQL data dump and all the products to stock link via the export featur...

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in creating dynamic das...

...Client must provide written notice to Developer specifying the reason for withholding payment. 7. Termination This Agreement may be terminated by either party upon 30 days written notice to the other party. In the event of termination by Client due to Developer's failure to fulfill their obligations under this Agreement, Client shall only be responsible for payment of services rendered up to the date of termination. 8. Confidentiality Both parties agree to keep all confidential information obtained during the course of this Agreement confidential. 9. Entire Agreement This Agreement constitutes the entire agreement between the parties with respect to the subject matter hereof and supersedes all prior or contemporaneous communications, representations, or agreements, whe...

...Client must provide written notice to Developer specifying the reason for withholding payment. 7. Termination This Agreement may be terminated by either party upon 30 days written notice to the other party. In the event of termination by Client due to Developer's failure to fulfill their obligations under this Agreement, Client shall only be responsible for payment of services rendered up to the date of termination. 8. Confidentiality Both parties agree to keep all confidential information obtained during the course of this Agreement confidential. 9. Entire Agreement This Agreement constitutes the entire agreement between the parties with respect to the subject matter hereof and supersedes all prior or contemporaneous communications, representations, or agreements, whe...

...Create a forum section where users can discuss various topics related to auto parts, repairs, and vehicle maintenance. - Implement user registration, post creation, and commenting functionalities. 5. **Local Car Rental Search**: - Integrate a local car rental search feature allowing users to find nearby car rental services. - Utilize APIs or databases to provide accurate and up-to-date rental options. 6. **Classified Page**: - Develop a classified page where users can post advertisements for buying or selling vehicles, parts, or related services. - Include features such as image uploads, description fields, and contact information. 7. **Responsive Design**: - Ensure the website is mobile-friendly and responsive across various devices and screen si...

As a private family office, I need an advanced household budget and expense tracker. The system should possess the following capabilities: - Expense Categorization: Feature to categorize my expenses effectively. (Invoices and cash expense) Suppliers names vertical line and date and all other horizontal. - Budget Forecasting: Capability to forecast budget accurately, helping in forward planning. - Monthly Tracking: Preferably, the system should facilitate monthly tracking of budget and expenses. - Single User Access: The tool will be used by me, so it should support only single-user access. The ideal freelancer for this project should have a strong background in finance technology, as well as experience developing budgeting and expense tracking tools. Particularly, experience with...

Please Sign Up or Login to see details.

Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.

I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.

I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.

I'm seeking a professional lead generation service sp...technology industry. This position requires a clear understanding of effective lead generation tactics, specifically in the B2B tech space. Lead except ads & seo. Key Responsibilities: - Generate high-quality B2B leads in the technology sector - Ensure the leads are of high quality and promising - Utilize various channels to source and qualify leads - Maintain a consistent flow of leads - Keep up-to-date with market trends Ideal Skills: - Proven experience in B2B lead generation, preferably in the tech industry - Excellent understanding of what constitutes a high-quality lead - Familiarity with different lead generation tools and techniques - Strong communication and negotiation skills - Ability to work autonomously ...

I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.