Write query sql number orders shipped jobs
I'm in need of a skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - *Resolve the current error*: To continue our operations without disruptions. - *Enable new data analysis capabilities*: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers.
...interactions. I am looking for someone who can not only implement the required functionalities but also suggest improvements based on their experience. The right freelancer for this job will have a track record of successful CRM and communication platform integrations, with specific examples related to WhatsApp. **Project Goals:** - Enhance team collaboration and efficiency in managing customer orders. - Ensure all customer interactions are tracked and easily accessible within the CRM. - Improve response times and customer satisfaction through timely and relevant communications. If you have the skills and experience outlined above and are passionate about creating seamless communication solutions, I encourage you to bid on this project....
I'm in the market for a highly skilled translator capable of handling various legal documents with efficiency and accuracy. My requirements are as follows: - **Languages Needed**: Fluent in English, Spanish, Russian, and French. Additional languages are a plus. - **Document Length**: Most documents will range from 1 to 5 pages. - **Document Types**: - Legal Contracts - Court Orders - Patent Documents - Birth Certificates - Marriage Certificates - Death Certificates **Ideal Skills and Experience**: - Proven experience in legal translation is a must. - Excellent command of the English language and one or more of the following: Spanish, Russian, French. - Ability to work under pressure and deliver rush projects with tight deadlines. - Attention to detail and accuracy...
...modules/pages/scripts will need to be MODIFIED/UPDATED in the BOOTSTRAP ADMIN. Current Setup and Future Development Plan: - I will remain MASTER ADMIN where i can manage ALL STORES as i currently do, however i need some modules and pages enhanced with filters so i can filter by store etc. - Each CLIENT will have their own login where they can MANAGE THEIR STORE ONLY. - Each CLIENT can check thins like ORDERS, INVOICES etc and much more STATS and GRAPHS etc but these will be for THEIR store only. Any existing features and modules will be available to ALL clients, and will show data for their STORE ID only. A join might fix this.... - New Features will need to be added which each CLIENT will then take instant benefit from, example i might want to add Statistics pages where clie...
We are looking to add a Senior Digital Analytics Consultant to our team! The work location is in Atlanta, GA and we are looking for candidates who are local to Atlanta or someone who can relocate...who can relocate. Skill Set: • Strong Digital Analytics / Marketing Analytics skills. • Expert level experience in Adobe Analytics is mandatory. • Strong Ecommerce/Travel and Digital Marketing background. • Experience with Analytics Reporting and Deeper Dive Analysis. • B2C direct channel Measurement and Optimization. • Ecommerce product development experience a plus. • Advanced Analytics Skills (SQL / Python) a nice to have. • Experience with Adobe Target a plus. • Experience working with senior management teams. • Experience developing ...
My current business is with SpreadSheet and some Wordpress Payment Site User would seek Japanese external EC site and find the items and ask us to purchase & deliver to Taiwan. We would do that in place of them with some commission ( quite a simple business model) [Exsisting work flow] 1 . purchase site ( very simple web form) 2. items & orders managing spread sheet 3 . payment wordpress [New work flow] Rails site (one site) at 3) , we have website using WooCommerce and Wordpress for only the payment part. We have received API specifications for Aftee, the payment service that is often used in Taiwan, but currently
...article edit = $5 50 articles editing = $250. You need to do the following task: 1. After generating the article add a few more images. You can use , etc. 2. Remove a few AI-like words such as “When it comes to”, Additionally, moreover, however, in conclusion, in this article. I will provide you with a full list of these types of words and phrases AI frequently uses. 3. Re-write the title and make it more eye-catching so that visitors are engaged with it....
...modules/pages/scripts will need to be MODIFIED/UPDATED in the BOOTSTRAP ADMIN. Current Setup and Future Development Plan: - I will remain MASTER ADMIN where i can manage ALL STORES as i currently do, however i need some modules and pages enhanced with filters so i can filter by store etc. - Each CLIENT will have their own login where they can MANAGE THEIR STORE ONLY. - Each CLIENT can check thins like ORDERS, INVOICES etc and much more STATS and GRAPHS etc but these will be for THEIR store only. Any existing features and modules will be available to ALL clients, and will show data for their STORE ID only. A join might fix this.... - New Features will need to be added which each CLIENT will then take instant benefit from, example i might want to add Statistics pages where clie...
...operational management expertise. For the accounting part, I require: * Accounts receivable and payable management - someone who can expertly handle the invoicing process aligned with the organization's principles As part of procurement, I’ll need you to: * Collect quotations from various suppliers – your critical thinking would be key in getting us the best deals possible * Perform purchase orders management – your organizational skills will be put to use here, keeping everything systematic and well-documented With regard to operations management, you will be responsible for: * Overseeing bookings and managing our CRM - Demonstrating your excellent project management skills, ensuring our operations run smoothly and effectively Ideal applicants should ...
...skilled programmer proficient in Google BigQuery, specifically its Standard SQL version. Recently, I encountered an error while working with a partitioned table, stating: "The query cannot be executed because the table involuted-alpha-377603:cargoaim_main_db.agent_basic requires partition filter and contains unapplied upsert data that is stale based on the max_staleness setting." Here's what I'm aiming for: - **Resolve the current error**: To continue our operations without disruptions. - **Enable new data analysis capabilities**: After fixing the error, I want to explore and utilize more advanced data analysis features that BigQuery offers. **Required Skills and Experience**: - Proficiency in Google BigQuery (Standard SQL) - Experience with pa...
I am seeking a skilled Oracle and SQL database specialist who can efficiently assist me with database management tasks. This will include database design, data modeling, and query optimization. Ideal skills and experience you should bring include: - Expertise in Oracle and SQL database - Knowledge in data modeling and database design - Troubleshooting and performance optimization skills - Proven ability to deliver high-quality work under deadlines The main purpose of the project is to enhance database proficiency that encompasses data storage and management, application development, and optimization of performance. The end goal will be to achieve a streamlined, fully-optimized, user-friendly database system. Deadline: 2 days Fix budget mode
Looking for a proficient SQL expert to contribute to our ongoing project. The successful freelancer will be experienced in database programming and will exhibit a deep understanding of SQL-based platforms. - Ideal Skills: Extensive SQL knowledge. - Experience: Oracle Database 2 days deadline
I'm in need of a database expect with a particular expertise in Oracle. The main purpose of this project involves SQL and oracel. The professional should be ready for a flexible project scope that may require various Oracle-based data analytical techniques. Ideally, the hired specialist will have experience in a range of data analysis strategies. Deadline: 2 days I would like to make it fix price
We are looking for a skilled SAP S/4HANA Developer with expertise in creating Core Data Services (CDS) views for analytics consumption in Power BI. The role involves developing and optimizing CDS views to facilitate effective data extraction and visualization, sup...Provide expert guidance on CDS view development and Power BI integration. Keep abreast of the latest trends in SAP S/4HANA and Power BI to enhance our offerings. Qualifications: Bachelor’s/Master’s in Computer Science, IT, or related field. Proven experience in SAP S/4HANA, particularly in CDS view development. Strong experience with Power BI or similar BI tools. Deep understanding of data modeling, SQL, and database technologies. Excellent problem-solving and analytical abilities. Effective communication an...
I'm looking for a skilled developer to integrate Bluedart with my Shopify store to streamline our order fulfillment process. This integration aims to enhance efficiency by automating key shipping tasks a...with respect to domestic shipping. - Prior experience with automating shipping and tracking processes in an e-commerce environment. **Additional Requirements:** - The solution must be tailored for domestic shipping only, as our operation currently does not support international orders. - A portfolio showcasing similar projects would be highly advantageous. Through this integration, I aim to achieve a seamless bridge between my Shopify store and Bluedart's services, ensuring our domestic customers receive their orders promptly and accurately, with minimal manual ...
I'm currently looking for an experienced database administrator or a SQL expert who can convert my raw SQL files, originally from MariaDB 10.6, into a standard .SQL format. The primary reason for this conversion is to facilitate a smooth migration to MySQL. As this project forms a crucial part of my migration strategy, it's imperative that we adhere to a stringent timeline. **Why the Conversion?** - The conversion is essential for migrating my database from MariaDB 10.6 to MySQL. It's critical for ensuring compatibility and efficiency in the new environment. **Expected Deliverables:** - Convert raw SQL files from MariaDB 10.6 format to .SQL files - Ensure that the conversion process does not introduce any data integrity issues - Verify co...
...and start work immediately 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Details of our current project STACK can be seen here -> Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Administer Ubuntu environment where we run our project 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term development and
...analysis and report generation. **Data Sources:** - The dashboard will need to assimilate data from diverse sources: - Excel spreadsheets for historical data. - SQL databases for real-time data analysis. - Integration with various cloud services to ensure a broad data spectrum. **Visualization Requirements:** - Special emphasis on creating detailed pie charts. These charts should not only be visually appealing but also convey information in a digestible format for all stakeholders. **Ideal Skills and Experience:** - Proficiency in Power BI, especially in dashboard creation. - Experience in connecting Power BI with Excel, SQL databases, and cloud services. - Expertise in creating engaging and informative pie charts. - Ability to work with data from diverse sources ...
...and start work immediately 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Details of our current project STACK can be seen here -> Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Administer Ubuntu environment where we run our project 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term development and
[woocommerce_cart] [woocommerce_checkout] using this kind of Woocommerce snippet i want to design this attached image front page how possible it is ? and can you code with in the budget
...and start work immediatly 3) Have 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 03:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Details of our current project STACK can be seen here -> Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales Key Responsibilities: 1) Administer Ubuntu environment where we run our project 2) Front end work migrating our current webapp from angular to , create new pages and functionalities in 3) Developers with experience in .NET API C# are an added plus as is knowledge of WordPress plugins. This is for ongoing long term development and
I have an issue with my enfold theme is creating a query tag behind the videos hence the vidoes are not getting cached as i would like to be. I need someone who knows exactly what this issue is and fix it. I dont want a generic expert. I am looking for specifically this issue only when u bid, write "yes i know how to fix query issue in video enfold theme" so i know u know
I'm seeking an experienced blockchain developer with a strong background in developing on the Binance Smart Chain (BSC). The primary focus of this project is to maximize profits through fr...front run Sell's on the blockchain - Sell immediately in the next block right after at the buy transaction on the front-ran block is completed. - Send BNB profit from trades to my address after every X successful trades. - A simple UI for the application where I can manage parameters such as : minimum amount of the trade, slippage tolerance, range or amount to put into trades for buy and sell orders, connection to the wallet, the token contract address (one or multiple contracts at the same time), gas price parameters. - A dashboard with all the trades done and where other feature...
I'm in need of an individual skilled in file conversion and data management to convert a SAS report to an SQL report, specifically for Tableau. The final output should be able to be utilized efficiently in Tableau. Your bids should reflect: - Your expertise in SAS, SQL, and particularly, Tableau. - Proven experience managing data conversions effectively. - Detail-oriented approach to ensure accurate conversion. - Ability to work within a timeline. Your primary task will involve: - Converting my SAS report to SQL. - Ensuring the SQL report is compatible with Tableau. - Troubleshoot any issues during the conversion. Speed and accuracy are essential for this task, and evidence of previous similar work will be advantageous.
...patterns, trends, and insights. - **Web Scraping**: Developing scripts to extract data from specified websites efficiently and accurately. **Ideal Skills and Experience**: - Proficiency in Python and Javascript. - Proven experience with web scraping tools and libraries (e.g., Beautiful Soup, Scrapy for Python). - Strong background in data analysis. - Familiarity with databases and data storage (SQL, NoSQL). - Ability to clean, organize, and interpret large datasets. - Knowledge of data extraction techniques and best practices to avoid IP bans or blocks. - Experience with handling dynamic and static websites. - Strong problem-solving skills and attention to detail. The end goal of this project is to harness web-scraped data for comprehensive data extraction tasks. Candidates sho...
I'm looking for a professional who can help me reshape my SQL database into Excel report form, enabling me to manage and run these reports independently in the future. The ideal freelancer should: - Be proficient in SQL and Excel - Have a firm grasp of database reporting and transformations - Understand how to tease out meaningful metrics and data details for presentation The resultant report should include: Access our Autotask backend database using Data Warehouse. (Link Below) I want to be able to take that database and convert it into a nice report that I can send to our customers on tickets. Whats the common issues and similar. I have a Simliar report currently through Bright Guage but Im looking
SQL Query Optimization Expert Needed ASAP Skills: - Strong knowledge and expertise in SQL - Proficient in query optimization techniques - Advanced understanding of SQL database complexity Project Requirements: - Immediate assistance required for query optimization - Deadline: Within 24 hours Please only apply if you have the necessary skills and can deliver within the specified timeframe. This is an urgent project that requires an expert in SQL optimization.
I have an e-commerce site created with Shopify , I am facing issue with the Shopify Private app , and orders are not getting sync on Shiprocket,
I'm looking for a seasoned developer or team capable of creating an extensive e-commerce management system. Features in this project should include: - User Management: Focusing on user authentication, role management, and activity tracking. You should have a deep understanding of user management systems to apply in this project. - Orders and Shipments: This system needs comprehensive order tracking, history, and shipment tracking capabilities. Your experience in e-commerce or logistics systems will be critical here. - Shipping and Delivery: The project requires seamless integration with shipping carriers. It should also have real-time tracking and delivery notification functions. Expertise in integrating third party APIs for real-time tracking is highly desirable. Additio...
i have a php script with some mysql queries and joins by DEFAULT there is no filter or condition on the STORE ID as when the script is loaded the first time no store id is selected so ALL data will be loaded for all stores now to filter the data for a specific store i added a WHERE clause to my query where o.orders_stores_id = '" . (int)$_GET['store_id_dd'] . "' '" . (int)$_GET['store_id_dd'] . "' is determined once i select a store from the dropdown filter. then it registers once i press submit however this only works if i add that WHERE clause the issue with that WHERE CLAUSE is that the DEFAULT or NULL case will not work and nothing will be returned as the code is treating it as NOTHING i.e its expecting a store id...
I have an e-commerce site created with Shopify , I am facing issue with the Shopify Private app , and orders are not getting sync on Shiprocket,
...interface for users to access their accounts, manage orders, and track invoices with the utmost security. Key Requirements: - Development of a clean, intuitive, and responsive design that supports all devices. - Implementation of account login functionality, ensuring ease of access for users. - Integration of two-factor authentication to add an extra layer of security to user accounts, protecting their sensitive information effectively. Ideal Skills and Experience: - Proven experience in developing customer portals or similar web applications. - Strong expertise in web security, specifically in implementing two-factor authentication. - Proficiency in front-end and back-end development technologies, such as HTML, CSS, JavaScript, PHP, and SQL. - Experience with user inte...
Im looking to interface and sync data from a software that has sql database to sap b1 using an automatic replicator that uploads to sap b1 every 3 minutes. only 2 documents type will be sent 1. Delivery Note 2. Sales Order The source database will have sql views mapped with the exact name and nomenclature needed by sap Sap b1 will only receive information from other database, it wont send info to other database
have a text format which need to pivoted and converted to columns and rows
I'm seeking an expert with vast experience in .net core applications to integrate the Google signup feature and fetch data from the Google Contact List. & integ...integrate into existing running projects. The developed application will need to perform the following tasks: Google Signup: - Implement user authentication - Integrate OAuth - Enable email verification Google Contact List: - Fetch all contact details such as name, email, and phone numbers SQL: - To store the fetched data, I need an SQL database set-up wherein the contacts' names, email addresses, and phone numbers will be stored Only developers with profound knowledge in .net core, OAuth integration, and SQL are encouraged to bid on this project. This will ensure a seamless flow of comm...
...ensuring low latency for realistic conversations. - Connect the AI model to a local database for accurate, real-time business information retrieval. Deliverables: - A working MVP that showcases the AI call center's capabilities. - Documentation detailing the development process, integration points, and instructions for use and future development. Required experience in: Python JavaScript SQL/NoSQL Web Development Frameworks (React, Angular, Vue.js) Node.js, Django AI and Machine Learning Libraries (TensorFlow, PyTorch, Hugging Face's Transformers) Cloud Platforms (AWS, Google Cloud, Azure) API Development Docker, Kubernetes CI/CD Tools (Jenkins, GitLab CI/CD, GitHub Actions) Web and Data Security Practices Problem-Solving Skills Communication Skills Project Manag...
More details: What specific changes do you need to make to the document? Text updates, Page number updates What is the current format of the document? PDF How urgent is the project? Within 24 hours
HEllo, I'm looking for anybody that provide me the SQL query that inserts the answers to the questions about the products from this module: The reply should be some thing like "INSERT ..."
I need a Freelancer to help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software (https://w...help my research team convert a DMP file with administrative data into a CSV file. Unfortunately, we have limited information on how the DMP was created. We can provide temporary access to our machines using a remote desktop to speed up the process. We tried to use ORADUMP to CSV software () but failed. So, we suspect that the origin of the file is not ORACLE SQL. I am happy to provide additional information to help you bid properly.
I'm looking for an experienced developer to create a seamless script for API connection between Paxful and Binance, two leading cryptocurrency P2P platforms. This project aims to automate the orders, account balances, deposits, and withdrawals in real-time in paxful via Binance, providing me with an efficient way to automate the trade Key Project Requirements: - Establish a secure API integration between Paxful and Binance. - Synchronize account balance information accurately. - Enable real-time tracking of deposits and withdrawals. - Ensure the solution adheres to the security protocols of both platforms. Ideal Skills and Experience: - Proficiency in API development and integration, particularly with cryptocurrency platforms. - Familiarity with both the Paxful and Binance e...
Requirement is very clear I need DB Architect: Start Date – Immediate Work Mode – Remote Work Hours : 11.30 AM to 8.30 PM ( May stretch depending on deliverables) Exp: 12 YRS (Minimum) ü Proven expert at writing SQL code with at least 10 years of experience. ü Must have 5+ years of experience working with large data with transactions in the order of 5 – 10M records. ü Expert at performance tuning, Transactions, Dead Lock management, Triggers etc. ü Proven expert in Modeling enterprise-grade databases and architecture. Very strong at Entity Relationship. ü 5+ years of experience modeling loosely coupled relational databases that can store tera or petabytes of data. ü 3+ years of proven expert in working with large Data Warehouse. ...
The backend pulls streams from the cameras of network devices (Hikvision, Dahua) through RTSP streams and performs algorithm discovering an alarm, push it to the front end of the platform. The algorithm to be written includes： someone smashing an ATM machine falling to the ground inside the ATM machine room are fireworks inside the ATM machine room To apply for intellectual property rights, not only does it require model files, but also the training process Duration:2 months
We are seeking a skilled freelancer to develop a simple PHP script focused on data visualization, specifically catering to planetary hours. While the script's core functionality ...starts;Warning Message No3 Additional Features: Dynamic color changes in columns to distinguish between good and bad hours (e.g., light green for good, red for bad). Implementation of warning messages for inauspicious days, triggered if the date coincides with specific Hijri calendar days (3, 5, 13, 16, 21, 24, 25). Technical Specifications: The script can be developed using PHP, Java, JavaScript, or SQL. This is not a project for earn money it is just for a local information project. So Important thing is budget is very low not looking high class developer. I prefer freelancer who needs good r...
The backend pulls streams from the cameras of network devices (Hikvision, Dahua) through RTSP streams and performs algorithm discovering an alarm, push it to the front end of the platform. The algorithm to be written includes： someone smashing an ATM machine falling to the ground inside the ATM machine room are fireworks inside the ATM machine room To apply for intellectual property rights, not only does it require model files, but also the training process Duration:2 months
...to request a three-day turnaround time from the time we ask you to work on a video, We will discuss the details of the deadline with you on a case-by-case basis. For those who are enthusiastic about submitting their work before the deadline, We are willing to increase the remuneration for those who are enthusiastic about submitting their work before the deadline, and we will proactively place orders with them! [Remarks] ・You must not disclose any information we provide, including manuals, etc. that we share with you. ・After delivery of the video, the copyright of all productions will be transferred to us. ・If a worker fails to notify us in advance of a delay in delivery, we will terminate the contract with. ・If the above precautions are not followed, we may take measures to ca...
I am seeking professionals to fill four diverse positions: - Order Rechecking - Order Placing - Customer Service - Nutrition Department _ docomets kyc **Order Rechecking:** The successful candidate will be responsible for verifying the accuracy of orders and checking for discrepancies. Attention to detail is a must, alongside familiarity with order management systems for efficiency and accuracy. **Order Placing:** In this role, you'll have to demonstrate precision and acute understanding of our products and services for successful order placement. **Customer Service:** Keen listening and communication skills are paramount as you address client needs and foster customer satisfaction. **Nutrition Department:** We're looking for informed and experienced personnel who c...
The backend pulls streams from the cameras of network devices (Hikvision, Dahua) through RTSP streams and performs algorithm discovering an alarm, push it to the front end of the platform. The algorithm to be written includes： someone smashing an ATM machine falling to the ground inside the ATM machine room are fireworks inside the ATM machine room To apply for intellectual property rights, not only does it require model files, but also the training process Duration:2 months
...eye color) to quickly find suitable candidates for projects. - **Data Security:** Ensure high standards of data protection and privacy compliance, with secure login mechanisms for staff. **Ideal Skills and Experience:** - Experience in developing custom online databases or CRM systems - Proficiency in web development languages (e.g., HTML, CSS, JavaScript) and database management systems (e.g., SQL) - Knowledge of data protection laws and best practices - Ability to create intuitive user interfaces - Excellent problem-solving skills and attention to detail This project requires a mix of development expertise and an understanding of the unique needs within the talent management industry. I'm looking for a freelancer who can deliver a solution that is both functional and ea...
