SQL Jobs

I am seeking a database expert who can successfully migrate mixed structured and unstructured product data from Oracle to SQL. This project requires a comprehensive understanding of database architecture, data migration best practices, and extensive knowledge of Oracle and SQL. Key Tasks: - Analyze and understand the structure of existing Oracle database - Prepare a thorough plan for data migration ensuring minimal downtime - Coherently migrate mixed structured and unstructured product data to SQL Ideal Skills and Experience: - Previous experience with Oracle to SQL data migration - Understanding of both structured and unstructured data - Deep knowledge of database architecture and design - Ability to troubleshoot any issues that arise during migration - Excellent attention to detail a...

I'm experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you've dealt with this before, you're the right fit.

I'm currently seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple of other related codes that can help

I'm using Microsoft Access 2013 and I'm looking for a skilled freelancer to help me integrate a Dymo printer into my system. Here's a breakdown of the project: - **Integration**: I need the Dymo printer to work seamlessly with my Access 2013 database. The goal is to automatically print stock labels based on query results. This means you'll need to set up the system to take the query output and send it to the printer for label creation. - **Printing Specifics**: The labels I need printed are stock labels. The process should be automated, so the labels are generated and printed without manual intervention. The labels will be printed based on the results of a query in Access and some limited entry from the operator with such things as qty of labels and which of 2 labels ...

Our manufacturing company is seeking a proficient app developer who can take our existing work orders onto a tablet platform. The application will function as a means for our employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Familiarity with SQL for direct server connection. - ...

I'm looking for someone who can assist me with a combination of SQL and Python tasks. - SQL: I need help with SQL in three specific areas: 1. **SQL Syntax:** Assistance with basic SQL commands, especially in working with subqueries. 2. **SQL Queries Optimization:** You should be able to optimize SQL queries for data retrieval accuracy. Your goal should be to ensure that the data collected is as accurate as possible. 3. **SQL Database Design:** You should be able to assist with database design, ensuring proper schema design and normalization. - Python: While the primary focus is SQL, some tasks may require basic Python knowledge. If you are proficient in both SQL and Python, even better. **Ideal Skills:** - Strong understanding of SQL, especially subqueries - Proven experience...

I am in need of a professional with experience in SQL Server, ODBC and Quickbase pipeline to assist me with data integration. Job Duties: - Connect my SQL server via ODBC - Utilize Quickbase Pipeline and on-prem gateway for seamless integration Preferable Skills and Experience: - Strong understanding of SQL Server and ODBC - Experience with Quickbase pipeline and on-prem gateway - A history of successful data integration projects, particularly with transaction data Credentials: -I have all the necessary access rights and credentials to my SQL server. I require your expertise to navigate the technical process. Your responsibility would be solely the technical integration. No data management or further SQL Server maintenance would be required. I am only looking for professionals who h...

As an experienced PL/SQL user, I am looking to collaborate with a seasoned developer to help further scale my project. The role primarily involves: - Building novel PL/SQL procedures - Innovative database architecture and design You would be perfect for this job if you can demonstrate: - Extensive background in PL/SQL - Expertise in database architecture - Experience in crafting innovative procedures The tasks will encompass: - Data manipulation - inserting, updating, and deleting data - Data retrieval using the 'select' function - Implementation of integrated business logic I am excited to see how we could improve database structure and efficiency together.

Having an integral project already in place, I'm in need of a skilled SQL Developer to contribute towards its further development. Specifically, the tasks I require assistance with include: - Query Optimization: Tailoring and enhancing the performance of our current queries is a significant aspect of this role. - Database Maintenance: Maintaining the overall health and efficiency of our SQL Server is also a necessity. Ideal candidate must have a comprehensive understanding of SQL Server, as well as notable expertise in query optimization and database maintenance. I prefer someone with a proven track record of successfully managing and enhancing existing projects. I look forward to seeing your bids.

I'm seeking an individual with a decent understanding of investment accounts to guide me in setting up an investment account on an online platform. Key Requirements: - I need assistance with setting up an investment account with Dana Epep, with an initial deposit of 100K. - It is essential that the freelancer understands the investment environment, but I only require a beginner level of expertise. - We'll mainly be communicating through instant messaging, so the freelancer should be comfortable with this mode of communication. Ideal Freelancer: - A beginner or someone with a basic understanding of investment accounts. - Someone who has experience with Dana Epep or other similar investment platforms. - A good communicator, as we'll be mainly using instant messaging for ...

I'm in need of a proficient full-stack developer well versed in .NetCore C#, aiming to perform critical bug fixing and maintenance services on my existing software. The preferred candidate is expected to have: - Extensive knowledge and expertise in .NetCore C# - Proven experience in troubleshooting and resolving issues in a timely manner - Ability to effectively maintain and improve the existing software system - Strong comprehension of full-stack development processes - Commitment to delivering high-quality, efficient, and clean coding solutions If you're a driven, resourceful, and .NetCore C# professional, you're just who I'm seeking. I look forward to productive and beneficial collaborations.

I’m in need of an advanced-level professional who can skillfully put together content regarding SQL and Data Science libraries, specifically pandas, numpy, scikit-learn, and matplotlib. Key Topics: - Thorough insight into SQL commands and functions - Comprehensive knowledge on data cleaning with pandas - Expertise in Machine learning with scikit-learn Purpose of The Content: - Strive to educate, serving as a tutorial guide - Adequate for usage in documentation Ideal skills: - Advanced expertise in SQL and Data Science libraries - Exceptional writing skills with the ability to communicate complex ideas simply - Proven experience in creating educational, tutorial, and documentation content. Please ensure your bid reflects your understanding of these requirements and your past e...

I have a recent backup from 4/1/24 on a hard drive attached to my new computer. My previous computer died, the motherboard went out and somehow my SQL Server data was not saved on the original hard drive. I need to pull the data from a ".DATA" file, or find the missing SQL Server backup files and copy them into my existing program for use. Can anyone help?

I need expert assistance with optimizing marketing reports in Looker Studio. The primary focus will be on improving grasp on lead status data. - Correct Looker Studio formulas -Trouble with Case When or Countif Statements to count rows with a certain status. - Ideal candidate will have proven Looker Studio expertise, strong understanding of marketing reports development and data analytics skills. Knowledge of customer behavior data is a plus.

I need an adept Teams Administrator to set up and manage Powerbi report access and Share OneDrive accounts for the upper echelons of my company. The desired individual should ideally have experience handling Teams Administration for medium-sized groups (10-50). Details: • Allocate Powerbi report access: The task involves granting read-only access to Powerbi Reports for the Executive and Management teams in my organization. • Share OneDrive accounts: You will also need to set up Share OneDrive accounts specifically for these segments. Ideal Candidate: • The ideal candidate will have proven experience in Teams Administration. • Proficiency in managing and configuring Powerbi and OneDrive • Experience working with medium-sized teams of 10-50 peop...

I'm in need of an experienced SQL professional to assist me with data warehouse. The ideal candidate is someone who has: - Proven experience in designing data warehouses - Advanced SQL skills - Excellent understanding of data volumes and the implications for data warehousing If you are interested in this project, please provide details of your experience in similar projects. Thank you.

I need support in applying the Jdime merge tool to resolve merge conflicts in my Java code. The ideal freelancer would have: - Proficiency in Java programming language - Hands-on experience with Jdime - Ability to quickly resolve merge conflicts in Java code I am looking for a smooth and automated merging process, which ultimately eradicates coding discrepancies. Proper communication and coding knowledge are necessary in order to effectively address and solve these types of conflicts. Note: I have written Java code. This code uses (the Jdime tool) to merge two versions and then report the results. If Jaime successfully combines these two versions, however When we executed the code, it showed that all the conflicts that we provided are not margable by Jdime, I am not confident in th...

In need of a proficient Power BI specialist for creating succinct, compelling reports and dashboards. The project requirements are: * Connecting to various online data sources including SAP and M-Assist. * Implementing a predetermined design for the reports and dashboards. * Incorporating bar charts, geographic maps, and drill-through capabilities. The ideal freelancer for this job should have: * Extensive experience with Power BI. * Proficiency in connecting Power BI to various online data sources. * Sound knowledge in creating and implementing report designs. * Expertise in producing bar charts, geographic maps and drill-through capabilities. Prior experience working with SAP and M-Assist will be highly beneficial. If you are accustomed with converting data into insightful visuals in...

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I'm in immediate need of an Oracle developer. My requirements are specific: Skills and Experience: * Proficient in Database Management * Expert in SQL programming * Experienced in PL/SQL development Project Scope: * Design and implement a new database * Optimize and tune an existing database * Capable of writing complex SQL queries Please note the project must be completed as soon as possible. So, only apply if you're ready to take on the task immediately.

I’m experiencing a persistent issue with lagging or delayed replication in my SQL Server database. The primary problem revolves around the replication process not effectively happening in a timely fashion. Ideal Skills-needed: - Solid skills in SQL Server management - Proficient understanding of database replication processes - Excellent problem-solving and diagnostic abilities in the context of database administration The ideal freelancer for this project will be able to not only identify the source of this issue but will provide a solution to improve the replication time. It's crucial that you have managed SQL Server databases before, ideally in a high-transaction environment, and have a deep understanding of data replication.

I am seeking an expert in SQL Server replication. The project involves replicating our business data to facilitate efficient data distribution. The replication has been set up. The snapshot working but Data not delivering to the subscriber. Log reader fails after 10 mins - Key Expertise Required: - Proficient with SQL Server - Extensive experience with data replication - Profound understanding of business data - Knowledge in data distribution strategies

I'm in need of an Access database that can primarily handle generating reports and analytics. The main goal is to keep track of internal data for further analysis and reporting. Key Features and Functions: - **Reports & Analytics:** The database should have the capacity to generate comprehensive and insightful reports from the data gathered. It's crucial that these reports are insightful and easy to understand. - **Data Tracking:** The database will be used for tracking internal data. This needs to be done with precision and the ability to link data for comprehensive tracking. - **Data Input & Updates:** The system should allow for easy input of data and updating when needed. This will facilitate the generation of accurate and updated reports. Ideal Skills: - Profici...

I'm looking for a proficient web developer to create a cutting-edge web app tailored for educational institutions. The main features of the app should revolve around seamless video communication between users. Key Features: - One-to-One Video Calling: Implementing a robust video calling functionality that can support both one-to-one sessions. - Live Chat: A real-time chat room integrated within the app for additional interaction. - Screen Sharing: Facilitating screen sharing among the participants. Customization Level: - The primary focus of this project is on basic video call functionality. No need for advanced features such as filters, effects, or custom backgrounds. The emphasis is on providing a stable, user-friendly video calling experience. Ideal Skills: - Proficiency in M...

As a website owner operating 20 sites predominantly run on PHP Wordpress and ASP, I am experiencing a major issue. I require a freelancer with strong Dbeaver knowledge to equip me with the necessary credentials and permissions to attach an SQL file to IIS Win 10. As a user who needs help with troubleshooting the "Unable to connect" issue in IIS, the assistance in this matter is crucial. Ideal Skills and Experience: - Extensive experience with Dbeaver and SQL-IIS connections - Previous experiences with WordPress and ASP - Good understanding of PHP 8.3.6 - Ability to troubleshoot and resolve “Unable to Connect” issues in IIS - Ability to provide guidance for verifying and establishing necessary credentials and permissions. Bonus if you happen to have experience in u...

I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS

I'm looking for a skilled developer to create an API Salesboard. We have had one in our business before, but unfortunately that company no longer exists. Fortunately - we have some imaging and data to provide that can help point you in the right direction. This tool will essentially serve as a centralized hub for tracking sales data, generating custom reports, and integrating with our existing CRM and PayRoll management software. The main features I need include real-time sales data updates during business hours, customizable executive reports, and seamless integration with our CRM system. We have an open API so that you can investigate what data is available. Key requirements: - Developing an API Salesboard tool with a user-friendly interface and robust functionalities. - Ens...

I've been experiencing some difficulties with my MS Access database. Error messages appear indicating missing or broken files namely, ‘’ version 7.0 and ‘’ version 1.0. Some occur as soon as I try to open the application. No recent changes have been made to my computer's operating system or the MS Access software. Ideal applicants for this task should be proficient in MS Access, troubleshooting, and database management. You'll need in-depth knowledge of system files and how they might impact the functionality of the application. A knack for solving complex technical problems is also important. In turn, you should be capable of providing a lasting solution to prevent the recurrence of these errors. Cheers!

Necesito ayuda para llevar mi trabajo con una mejor gestión. Cuento con PowerBi desktop y necesito que de manera local me pueda estar actualizando mis KPIs

I am actively seeking an API development expert, specifically for SSO and SAML integration. Let's dive into what I am specifically envisioning for this project: - Proficiency: I will need someone who is familiar with SSO, SAML, React, Node.js and SQL. Your past experience in similar projects will be highly valuable. - Functionality: A primary objective for this task is to develop an API that has Single Sign-On (SSO) and Security Assertion Markup Language (SAML) functionality. - Purpose: The purpose of the API development is to integrate SSO and SAML for user authentication in my system. Maintaining security, ease of use, and adaptability is crucial. In conclusion, your task primarily revolves around strengthening authentication methods via respective API development.

I have a small FileMaker Pro 12 database that requires a conversion to an SQL-based database. The structure is to largely remain the same, but there are some minor issues that need rectification. Details: - The conversion task requires no major changes to the original data structure. - However, some calculation errors need fixing. Therefore, you'll need a keen eye for identifying and rectifying them. Skills & Experience Required: - Experience with FileMaker Pro 12 and SQL databases. - Understanding of database structures and functionalities. - Ability to identify and correct calculation errors. - Great attention to detail. Please ensure that during the conversion process, no data is lost, and the end product works seamlessly. The bid proposal should reflect your understandi...

I need a Python developer who can handle automation tasks related to ETL pipeline, data extraction from Snowflake, and a dbt environment. Key Requirements: - You should be proficient in Python programming. - Be familiar with the Window Task Scheduler. - Have experience with ETL pipeline development. - Know how to extract data from Snowflake and a dbt environment. The Purpose: - The ETL pipeline is crucial for handling data analysis, reporting, and data integration tasks. - The data size to be processed in the ETL pipeline is medium, up to 10 GB. Ideal Candidate: - You should have prior experience in handling similar tasks. - A strong understanding of data handling and automation through Python and ETL tools. - Proven expertise in data extraction from cloud-based warehouses, especially...

Jsme rychle rostoucí startup v oblasti průmyslových technologií, který na strojírenský trh přináší unikátní AI službu, navrženou tak, aby vyhovovala největším výrobním společnostem na trhu jako Siemens, Bosch, Wanzl, Ammann atd. Jsi zkušený expert na backendový vývoj a softwarovou architekturu a hledáš příležitost k dalšímu rozvoji ve významném technologickém prostředí? Chceš vést vývojový tým a podílet se na návrhu a implementaci sofistikovaných softwarových řešení? Pokud máš rozsáhlé zku&sca...

I need a custom add-in that can automatically save both my sent and received emails. Key Features: - The add-in must be compatible with Outlook and automated as much as possible. - It should have the capability to save both sent and received - The add-in should be efficient, ensuring that no emails are missed in the process - A simple yet effective interface that is easy to navigate and use is crucial The add in will: - query a SQL database and find clients linked to the sender/recipient and prompt the user to select the relevant client - Save a copy of that email to the relevant folder for the selected client - again based on a SQL query. The SQL query information can be provided to facilitate this. Ideal Skills and Experience: - Proven experience in developing Outlook a...

I'm seeking a freelancer with experience in ASP.NET Core. The job involves moving two unspecified files from one ASP.NET Core project to another. Please include your relevant experiences in your ability to troubleshoot and problem solve efficiently will be highly valued.

I am looking for a freelancer with experience in Qlikview or Qlik Sense implementation to assist with a dashboard creation project. The ideal candidate should have prior experience in implementing Qlikview or Qlik Sense and be able to create visually appealing and user-friendly dashboards. The project is expected to take between 4-6 months to complete.

I am currently looking for an MS SQL trainer to help with physical training in chennai. - Expertise: While the selected trainer needs to have intermediate level skills in MS SQL, having advanced skills could be a bonus. However, the ability to explain complicated topics in a simplified manner is paramount. - Topics: Though a choice was not specifically provided, your comfort with a range of MS SQL subjects will be beneficial. From database administration, querying data to data integration, any and all skills are welcome. - Time frame: This is an immediate requirement. Hence, applicants who are available to start at the earliest will be preferred. Ideal candidates should have considerable experience in training others, a strong grasp of MS SQL, and the flexibility to start ASAP. Your abil...

DotNet developers required for Improvement work in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Improvement work which need to be done is explained in below link-

I'm in need of a skilled database designer and manager who' is confident in English. The project involves creating and maintaining a relational database. Key Requirements: - Advanced knowledge of Relational Databases - Proven experience in database design and management - Must be be fluent in English Experience with: - Customer data management or transaction records (preferred but not mandatory) I'm looking for someone who can work on this project with no strict time limit.

I'm seeking a skilled VB.NET/MSSQL developer who have ever done simillar work in Tax and statutory compliance projects like Kenya - KRA, TIMS,UAE - FTA,India - GSTN, Angola - SAF-T, etc to integrate the Electronic Fiscal Receipting and Invoicing System (EFRIS) API into my VB.Net POS Project. The successful freelancer will have extensive experience in creating similar systems and should possess a keen eye for detail. Key Features: - E-Invoicing:

This project is to develop a simple system that will help me manage following for my store, Inventory Sales Administration Inventory Inventory management and verification are the main reasons for developing this system. Each piece of inventory will be tagged with an asset barcode, so that I can track where each piece is and when it was sold at what price. Also need to be able to generate a barcode in a query and report. See Each week, inventory will be scanned, and a report generated to figure out variations between physical stock and what the system says. Inventory dashboard and reports like aging, velocity etc. Sales Should be able to create a customer from the sales order screen. Sales order will be created using customer master and product master. When order is saved, Reduce...

As someone launching a project on the Solana platform, I am in need of an expert who is fully knowledgeable about smart contracts and the functionalities that can be implemented on Solana. Unfortunately, I do not have a fixed prerequisite for the smart contract's functionality at this time. Ideal skills and experiences for this job include: • Definitive knowledge and working experience on Solana and Ethereum platform • Extensive understanding and hands-on experience with smart contracts • Ability to provide guidance and insights on a variety of smart contract functionalities; including but not limited to token creation and distribution, Defi lending and borrowing, and NFT marketplace. • Superior problem-solving skills and ability to deliver under tight schedules....

I'm in urgent need of a skilled C# developer to integrate a database into my application. The project needs to be completed as soon as possible. Key Requirements: - Database Integration: The most critical aspect of this project is the seamless integration of a database into the application. All data should be accurately stored and retrieved from the database. - Timely Delivery: The urgency of this project requires a developer who can deliver high-quality work quickly. Ideal Skills and Experience: - Proficient in C#: A solid understanding of C# programming language is essential for this task. - Database Management: Experience in integrating databases into C# applications is a must. - Quick Turnaround: Previous experience in delivering urgent projects on time will be highly regarded....

I'm looking for a highly experienced ChiroTouch biller who can help me manage my chiropractic practice billing. I currently have ChiroTouch billing software installed and running. However, I need someone who can take on multiple billing tasks including data entry and claims processing, payment posting and account reconciliation, custom report generation, and overseeing all billing to ensure it's done efficiently and effectively. The ideal freelancer should have: - More than 3 years of experience working with ChiroTouch billing software - Strong attention to detail - Ability to verify coding and fine-tune to maximize payments - Good communication skills to keep me updated on billing progress Your role will be crucial in ensuring that the billing process in my practice runs smo...

I'm searching for a SAP ABAP Developer specializing in the SD (Sales and Distribution) module. Your main role will be in the development of reports. Task will be divided in phases. Your tasks include: - Creation of two module pool programs, one for SO and another for STO. - Use of BAPI to fetch all details and based on data some calculations needs to be peformed and displayed in output. - Dymanic data to be called based on user input. The perfect candidate should possess the following skills: - Extensive knowledge and experience in SAP SD module - Proficiency in reports development and potentially in Module Pool programming - Strong understanding and technical skills in SAP ABAP development environment Expect a medium level of complexity in this role, so only apply if you'...

I'm in need of a freelancer to work on my website. The main objective of this project is to enhance the user experience. Key Tasks: - Improving existing features: I need the freelancer to enhance the current features of the site. This includes making the website more intuitive and user-friendly, potentially by modifying navigation, adding features or improving the site's responsiveness. - Complete Redesign: I also require a complete redesign of the website, with a focus on improving the user experience. This might involve changes in layout, color scheme, typography, and overall design. Ideal Skills and Experience: - Proficiency in Website UX Design: The freelancer should have a proven track record in Website User Experience Design. Experience in working on similar projects is...

I'm currently working on a project that involves fetching data from an API and loading it into SQL Server using SSIS. I've made significant progress, and I'm facing challenges that require immediate attention. Key Details: - I'm encountering error messages during the data loading process. - I require assistance writing the SSIS package to ensure efficient and error-free data transfer. - The data source is an API, so experience handling API data is essential. Skills/Experience Required: - Proficiency in SQL Server Integration Services (SSIS). -Must know SQL server - Ability to troubleshoot and resolve data loading errors effectively. - Familiarity with API keys for authentication.

I'm seeking a highly skilled professional to develop an Android app focused on warehouse stock tracking. Here’s the overview of the core functionality the app should have: - **Stock Level Updates**: The app should encompass a real-time updated inventory that reflects the current stock levels. I'm interested in exploring the possibility of updates via manual input and barcode scanning. Ideal candidate should have: - Strong experience in Android app development - Knowledge in inventory management or similar apps - Familiarity with using barcode scanning for inventory tracking(Barcode scanning could be a future option, not interested to have it in the early version, could be integrated at later stages off the app) A successful collaboration could lead to more work in the f...

I'm looking for a skilled C# developer who can help with database integration, specifically using SQL Server. Key Requirements: - Database Integration: You will be expected to integrate SQL Server into our existing C# application. This will involve working with database tables, writing queries, and ensuring data is accurately and securely stored and retrieved. - Experience: I'm looking for someone with a strong background in C# development and a proven track record of successful database integration projects. Ideal Skills: - Strong C# Development skills - Proficient in SQL Server - Experience in database integration - Ability to write efficient and secure queries - Good communication skills This is a great opportunity for a talented C# developer to put their database integrat...

I am often facing lot os issues while importing data into MS SQL server, there are different type of errors and issues that I cannot keep track of. I need someone to help me geet rid of all these issues once and for all... I should be able to import all types of data using XLS, XLSX, CSV and all others..