Query mssql jobs

I'm in need of an experienced .Net developer, with solid skills in MSSQL and C#, who can effectively handle front-end development tasks in my POS terminal project. Your primary tasks will be: - Implement business logic based on defined user stories. - Develop the user interface of the POS terminal using C# and associated .NET technologies. - Integrate the POS terminal with MSSQL database for data storage and management Ideal skills and experience: - Proficiency in .Net, MSSQL, and C#. - Previous experience in front-end development. This role requires both technical expertise and keen attention to detail. I am looking forward to your innovative solutions to meet our project requirements.

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

...Development needed to accommodate the expected volume of registrations Development to prevent IP bans Detailed feature description: Member Login Sign-up Permission assignment Individual inquiry Immediate rank crawling Tracking target management Individual input Bulk Excel upload & download Keyword-based crawling On/Off Deletion Background crawling of tracking targets Naver Place keyword (1 daily query) Rank change history Generate a shareable URL (reset every week) Display in a popup from step 3...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

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

I'm in need of comprehensive and detailed Australian databases. Specifically: - Medical databases, with a key focus on medical specialties. Medical databases should preferably contain reliable and...reliable and relevant information about the different branches of medical specialties across Australia. - Business databases, encompassing detailed company profiles inclusive of industry category, phone, fax, email, physical address, etc. I'd appreciate getting more data, as in-depth as possible. The databases should be pre-existing or scraped and must be provided in Excel format, or .BAK for MSSQL server. Professionals equipped in big data collection, scrapping, and data analysis would be the most suited for this project. Knowledge about Australian medical and business sect...

...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 (it's the DYMO LabelWriter 450 Turbo) with slightly different fie...

I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70

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 in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

...including the ability to automatically hide and unhide tabs based on the selections made on the "Master Sheet. As well as pull in all needed information from the "Master Sheet" and any "Data Entry Sheet". Ideal Skills and Experience: Successful candidate should possess: - Deep understanding of advanced Excel formulas and functions. - Previous experience in designing visualization charts and custom query builders. - Strong analytical and data organizing skills. - Experience in converting independent Excel worksheets into a master file. - Knowledge in NDT industry would be beneficial but not paramount. The goal is to provide an automated and streamlined approach to handle inspection reports, making analysis and generation of summary statistics a bree...

.net .net core API Clean architecture Mssql Azure services SignalR Console application, cron job, background service Project is completed just need improving

Postgres data query system Docker across multiple servers

We are seeking a talented full stack developer to create a mobile application for a medical start up. The application will serve as a platform for patients to perform home based outdoors exercise, receive general information about their condition and communicate wit...and compatible with various devices and platforms - Conduct thorough testing and debugging to ensure high-quality and bug-free code Requirements: - Proven experience as a full stack developer - Familiarity with mobile application development, particularly in the medical industry - Strong programming skills in JavaScript, HTML, CSS, and relevant frameworks - Proficiency in database management and query optimization - Knowledge of RESTful APIs and best practices for integration - Excellent problem-solving and communicat...

Need a backend developer to implement bel...client's existing code base. 1. Feign clients 2. Request and the response interceptors 3. For opt in, only mobile number to be passed as param to the feign client's method - ("919999784665"); 3. For sending sms, only mobile number and msg to be passed as param to the feign client's method - ("919999784665", "Hey there I am using whatsapp"); 4. All other query params to be inserted via request interceptor 5. userid and password to be picked from yml file, they will be different for different environments. 6. For both the APIs we'll have response interceptors which will check if the 'id' given in 'response' corresponds to one of the error codes. If they do, then we...

I'm in need of a LibreOffice Base specialist for form and report generation. Specifically, I require the creation of: - Input forms - Query forms - Output reports More specifically, I need a data entry form with a focus on a form view format. The successful candidate should demonstrate an excellent understanding of LibreOffice Base and form creation in various formats. Ideal Skills: - In-depth LibreOffice Base knowledge and experience - Expertise in form and report creation - Familiarity with form view format structures.

i am looking for a developer to help generate 1d barcode for my existing web system in vb.net and database is mssql

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

There will be additional $50 for any who completes this project fully. The aim of this project is to compare three types of databases(Any relational database, mongoBD and Neo4J) in terms design approach, implementation, query composition, and performance. The data is about texas hold em poker game The stages of the project are 1. Look at the details of the data 2. Come up with an ER diagram and a relational schema for the data 3. Create a database in any relational db and tables 4. Create a python script to read the txt files and populate the db 5. Test the queries 6. Populate the other(mongodb and neo4j) databases and test the queries Then test the queries below on the databases QUERIES 1. Separate players by their style of play/Group players with a similar style of play togethe...

Need a Windows program that logs into an account, allows the user to enter a 2FA code in a browser window, enters queries into a search from an input XLS file, and on output saves the search status for that query.

Se inicia un proceso sin fin que consume todos los recursos del servidor. Adjunto captura de la información que me brindaron desde el servidor. Mi objetivo es que mi web deje de caerse por excesivo consumo de recursos. A continuación, copio la query que genera el problema (ver captura para más información): SELECT SQL_CALC_FOUND_ROWS from vsnucam_posts left join vsnucam_term_relationships on ( = Vsnucam_term_relationships.object_id) left join vsnucam_term_relationships as tt1 on ( = tt1.object_id) left join vsnucam_term_relationships as tt2 on ( = tt2.object_id) left join vsnucam_term_relationships as tt3 on ( = tt3.object_id) left join vsnucam_term_relationships as tt4 on ( = tt4.object_id) where

...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 add-ins. - Knowledge of Microsoft Outlook's functionality. - Strong attention to detail to ensure proper email categorizati...

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:

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

script for auto replying mail with attached files

I'm looking for an expert in MS SQL databases to help me with a specific task. I’m using an MSSQL database and need to create a Param scalar. This is to store specific customer information in a structured manner. The ideal freelancer should be experienced with: - SQL, specifically MSSQL - Parameter creation within databases - Experience working with customer information In your proposal, please provide an example of a similar task you've completed in the past.

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

I am currently looking to engage an experienced Machine Learning professional for my project. I require analysis to be conducted on text data as well ...as well as numerical data. A strong understanding of Machine Learning concepts and analytical skills are vital. While I have not specified a particular focus area of Machine Learning, I am open to recommendations from the chosen freelancer based on the data provided. Key requirements include: - Proven track record in Machine Learning - Proven track record in Google Gemini and Google big Query ML - Proficient in data analysis and interpretation - Experience working with both text and numerical data Critical thinking and problem-solving skills with attention to detail will be necessary for the successful completion of thi...

MS1: Solana Data INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No) - Optional but great to have: Mint authority status (Permanently revoked, time-limited etc). 5. Liquidity info. - Must have: Percentage of the liquidity locked (%) - Must have: Liquidity burned? (Yes/No) - Optional but great to have: Liquidity lock autho...

...performance of our aggregation pipeline. The focus is on improving the response time and enhancing our capability to handle large volumes of data proficiently. The goal is to reduce response time to under 100 milliseconds without compromising data accuracy or integrity. WE WILL PROVIDE A PYTHON SCRIPT THAT CONTAINS MongoDB AGGREGATION PIPELINE Key Responsibilities: - Review and enhance the query performance - Optimize our large volume data handling - Analyze and understand the existing aggregation pipeline. - Identify potential bottlenecks and areas for optimization. - Implement efficient algorithms and techniques to enhance pipeline performance. - Ensure that the script returns data in less than 100 milliseconds. - Test and validate optimizations to ensure accuracy...

...functionality of the application. Key Responsibilities: - Identify the root cause of the pagination issue - Resolve the bug to ensure the pagination system functions correctly - Test the application thoroughly to verify that the issue has been fixed Ideal Skills and Experience: - Proficiency in PHP and Laravel framework - Prior experience with Laravel's built-in pagination - Strong knowledge of Query Builder - Ability to troubleshoot and debug complex issues - Excellent problem-solving and communication skills It's crucial that the freelancer I work with has a keen eye for detail and a track record of successfully resolving similar issues. The individual should also be comfortable with working in a fast-paced, deadline-driven environment. Here is a video that expla...

I need an SQL query to extract specific information from the Moodle database. The query should pull the name of the user, a list of activities they have completed, and the time they have spent on SCORM packages if they have interacted with any. Key requirements include: - Extracting user's name and completed activities. - Differentiating SCORM packages and calculating time spent on them. - Handling users with no completed activities by including them in the results with zero activity count. If you are familiar with PostgreSQL and Moodle database structure, and have experience writing efficient SQL queries, this project is for you. Your query should be optimized for general use, without specific version constraints. The ideal candidate for this task should under...

...Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and informative, and the necessary feedback will be given to the user during the payment and return processes. In addition, a simple test application ...

...the page should not lock up permanently or be flagged permanently with frequent use or fast refreshing of the page. INPUT: Solana contract address OUTPUT: (These may change in time. We are looking for only the snapshot at the time of the inquiry). 1. List of wallet addresses that have a non-zero balance of the input contract token AND no buy transaction for that token, at the time of the query. (This check intends to find out wallets with pre-mined tokens). Please have this list collapsed to item 2 below when the page first launches). 2. Percentage of the total supply that these wallets under item 1 above hold collectively (%) 3. Percentage of the total supply under AMM (%) (Only Raydium is fine). 4. Mint authority info. - Must have: Mint authority revoked? (Yes / No...

I am experiencing issues...database after moving the database file. After reconnecting the queries to the database, all but one tab of file updated okay. One tab is returning errors. The database is accessed through a desktop application. Key Requirements: - Resolve query errors in the database - Ensure the database functions properly within the desktop application - Investigate and fix any potential issues caused by moving the root file The ideal freelancer for this project should have: - Strong expertise in Microsoft Access - Proficiency in database management and query optimization - Experience in troubleshooting database errors - Ability to work with desktop applications Please include in your bid any relevant experience and your approach to troubleshooting and reso...

I'm seeking a proficient AI expert with the unique skill set in Generative AI and MongoDB. My goal is to automate the query generation process in my mongodb database radiating from chat inputs. WHAT TO DO: * Develop a Generative AI that will use chat inputs to automatically generate complex queries. * While we may have a gamut of queries, for now, we need all-encompassing technology that'll serve a broader purpose. I'm operating on a tight deadline, I need this project completed ASAP. If you're versed in AI and comfortable working with MongoDB, let's get in touch. I'm open to discussing any questions you might have about the project.

I am in need of a skilled developer who can create a real-time monitoring dashboard using MySQL. The dashboard will primarily be used for real-time monitoring. Key requirements: - Strong experience with MySQL: You should be proficient with MySQL and able to efficiently manage and query a large amount of data. - Dashboard development: You should have prior experience developing real-time monitoring dashboards. - Custom Date Range Report Generation: The dashboard should include the ability to generate custom date range reports. - Data visualization and real-time monitoring: Although the primary purpose of the dashboard is real-time monitoring, a good understanding of data visualization would be beneficial too. If you have prior experience with similar projects and are confident in y...

...visualization techniques Ideal candidates for this role should have: - Experience with MS Fabric, specifically working with Lakehouses, Warehouse, SQL Endpoint, Data Flows, and Notebook - Proficiency with SQL Server, VBA, and SAS - Previous work with AI/ML algorithms - Exceptional knowledge of AWS services, including S3, Athena, and Glue - Familiarity with GCP storage and Big Query - Competence in using Power Query for data manipulation and transformation Your skills and experiences will play a crucial role in ensuring the successful delivery of this project, so please be sure to highlight your previous work history in similar projects and please send me you CVs and also please clearly state your price expectation and duration of work and also mention your availability f...

...system to scrape data from the App Store. The system must collect information about apps based on specified search criteria, such as categories and keywords. References: 2. Main Functional Requirements 2.1 Scraping Features Category or Keyword Selection: Users should be able to choose a category or enter keywords to search for apps. Concurrent Query Execution: The system must support the simultaneous execution of multiple queries. Data Storage: Data on scraped apps must be stored for further access and analysis. 2.2 Data Management Viewing Scraped Data: Users can view a list of apps and detailed information about each app. Data Export: Capability to export data into a CSV file, including: App name App link Release date and last update Support

I need a refined and comprehensive database of the customers who submit a query on Car Dekho. My primary purpose is to conduct market research and analysis. Requirements: - The details I need are their full name and contact number. Please omit any other personal or private details. - This data should be provided in a CSV file format, which will be easy to import for various kinds of analysis. Ideal Candidate: - Expertise in data mining and extraction - Proven track record in collecting accurate, high-quality data - Familiarity with the automotive industry is a plus - Strict adherence to data privacy laws - Extensive experience with CSV files and data formatting.

I am struggling with a range of issues in my SQL database that are affecting my business operations. The primary challe...size of my database is substantial, significantly above 10GB, implying the need for a professional who can manage and improve large-capacity systems. The target areas for amelioration in the SQL database include: - Efficiency of the queries. - Table partitioning strategy. The ideal candidate should evidence expert skills and a successful track record in managing large SQL databases, improving query efficiency, and implementing effective table partitioning strategies. In-depth knowledge of comprehensive database performance tuning and optimization techniques, coupled with the ability to solve complex technical challenges like timeouts and deadlocks, is highly ...

I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This role requires a profe...

Hi, We are looking for a developer to do the following tasks: 1. Index resumes in pinecone using langchain 2. Convert query from user into structured response in langchain. 3. Get responses from langchain and pinecone 4. Tank the resumes based on score 5. Test postman APIs for each of the above tasks. There will be two queries - one to fetch the relevant CVs and the other to rank a group of CVs. Ideally the score will be to use both one after the other and get ranked and relevant CVs. This can be written in Nodejs or python; we are okay with either. I will provide sample datasets and test with you. We are on a low budget for this - max - 1500-5000 inr. we want to work with individuals who are keen to learn and do this for the learning and not much for commercial gain. This woul...

I'm seeking an experienced WordPress developer with a specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, while significan...

I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.

...can help me integrate a new functionality into my existing PHP application. Key Requirements: - The task involves enhancing a synchronization system with an external API. Ideal Skills: - Proficient in PHP programming - Experience with API integration - Familiarity with data synchronization techniques We designed a custom WordPress plugin to integrate with our supplier API to automatically query products in our WooCommerce database and update pricing for those items (as well as some other tasks). We need the following changes/enhancements made to the program: 1. The program was originally set to use the test API. We need to switch this to use the production API instead 2. Currently, the program iterates through all products and updates them. We would like to option to ente...

I'm looking for a WordPress developer to create 2 custom pages First one will display a comparison table of school listings, more than 2k listings Key Details: - The page will require coding for a custom comparison form that displays a table for each query. - The comparison table should include listing details - the comparison table will include filters Second one is a statistic page that will show graphs based on filters choose by user, and will be based on listings Ideal Skills and Experience: - Proficient in WordPress development, with experience creating custom pages and forms. - Strong understanding of PHP, HTML, CSS and JavaScript for the coding of the comparison form. - Familiarity with mylisting theme Please bid with your final price. No placeholders. Please make ...

Assistance required to generate the Teams Call Queue reports into PowerBI. Sync between Teams Call Queues and PowerBI. Daily Usage reports required. Refresh and query data on the reporting side. If required, a test Call Queue will be made available for this exercise. Please only reply if you have worked on similar tasks. No time wasters please.

I am looking for a developer with strong knowledge in Node.js Express, PostgreSQL, and...existing project to ES6 modules in order to improve code readability and maintainability. Specific tasks include: - Updating the routing and middleware for cleaner, clearer understanding. - Refining error handling and logging process to ensure consistence and easy debugging. Having a keen eye for detail and a thorough understanding of modern JavaScript features is fundamental for this role. This query requires a trustworthy and skilled professional to maintain the code’s performance and scalability. A deep understanding of Node.js Express and ES6 modules is essential for this enhancement task to also readability, simplicity, durability, and functional completeness. I need it done in the ...

I'm working with an older PHP project and need help with displaying data in a tabular format. Key Requirements: - Utilize PHP to print data in a tabular form on the presentation layer - No template system in place, so direct PHP manipulation needed - Experience with displaying database query results is a must This project involves integrating the existing PHP system with a tabular presentation layer. Knowledge of older PHP frameworks is an advantage, as well as familiarity with handling database query results. A pragmatic and efficient approach is key to ensure a smooth integration.