Specialise sql query일자리
...Automating tasks related to data processing and workflow Skills and Experience: - Proficiency in Python, especially for task automation - Extensive experience with React for frontend development - Expertise in FastAPI for backend development - Strong understanding of AWS services - Prior experience in the derivatives market is a plus - Proficiency in managing and optimizing databases, including SQL and NoSQL options - Expertise in containerization technologies such as Docker and Kubernetes - Experience in designing and implementing microservices architecture - Understanding of security best practices and experience in implementing them in both frontend and backend environments - Experience with managing API gateways on AWS like AWS API Gateway We also need IP hopping for this p...
Tasks for City Filter Implementation ...Freelancer and Employer profile meta data. Ensure that the selected city and state are saved in the database when profiles are updated. Ensure Compatibility with Future Updates: Use the child theme to override necessary template files from the workreap-core plugin (templates directory). Avoid modifying the core theme or plugin files directly to ensure updates won’t overwrite customizations. Custom Query Modifications: Modify WP_Query or task queries to ensure that tasks and Freelancers are properly filtered by city and state when displayed. Testing and Compatibility: Test the city and state filters for compatibility across browsers and devices. Validate that customizations work seamlessly with the theme's existing functiona...
...in database management, web development, and cloud infrastructure. Below are the detailed requirements for the project: Expertise Required 1. Database Administrator (DBA): • Proficient in designing and managing large-scale databases. • Expertise in implementing indexing, partitioning, and optimization techniques for handling billions of records. • Strong knowledge of SQL and NoSQL databases, performance tuning, and query optimization. • Experience with database security, replication, and backup strategies. 2. Web Developer: • Skilled in full-stack development (frontend and backend). • Experience building dynamic and responsive websites. • Proficient in any modern programming languages/frameworks (e.g., React, Angular, Django, No...
...looking for someone who can understand the intricacies of data processing and can help ease the burden of manual tasks. The goal is to streamline our operations and enhance productivity. -- Basically, we have a data scraping and processing project which is going to be presented into our new website. We need a backend Python Developer whom can process data in our Google sheet then be dumped into SQL, eventually going to be presented into our new website. Therefore, the Python developer needs to be familiar with Google sheet API, Django framework API, and scrapping for our data processing. Data synchronization should occur in real-time. Check our website in www.im-aam.com. Our budget is $3/hour for maintaining the codes and website $5/fix rate for replicating or making a new cod...
...already available on a set frequency basis within our software. The tariff, fuels data, other factors formulas, compensation tables, curves etc. to be used are available and will be shared with short-listed candidates only for a revised fixed price bids. Your software will be integrated as an add-on module to ours. The software should be developed in current version of C# or VB.NET with current MS SQL Server database for latest MS Windows OS. We need SMEs with programming expertise or a team with this expertise, as we are looking for your collaboration to fill this activity. Please supplement your 1st response with the following links, else it will be rejected.
...application, while delivering exceptional user experiences. Key Responsibilities: - Building high-quality, scalable web applications - Creating robust server-side logic - Implementing intuitive user interfaces Your skills should include: - Proficiency in Front-end technologies (HTML, CSS, JavaScript) - Expertise in Back-end frameworks (Node.js, Express, etc. PHP) - Experience in Database management (SQL, NoSQL) - Skill in RESTful API development - Familiarity with Version control (Git) - Understanding of Responsive design principles - Knowledge of AWS/Vercel The APIs you'll be working with will mainly involve: - API integrations Prioritizing aspects of back-end development will focus on: - Scalability - Security - Performance Nice to have: - Experience in the betting i...
...optimization and scalability solutions Industry Solutions Enterprise Resource Planning (ERP) systems Customer Relationship Management (CRM) solutions Business Intelligence and Analytics platforms Workflow automation systems Our Technical Expertise Frontend: React.js, Angular, Vue.js, HTML5/CSS3 Backend: Java, Python, Node.js, .NET Mobile: iOS (Swift), Android (Kotlin), React Native Database: SQL, NoSQL, MongoDB, PostgreSQL Cloud: AWS, Azure, Google Cloud DevOps: Docker, Kubernetes, Jenkins Our Development Approach Agile methodology with iterative development Regular client communication and progress updates Comprehensive testing and quality assurance Post-deployment support and maintenance Documentation and knowledge transfer Why Choose Us Proven track record of successfu...
...developer to create a simple function that does the following: **Fetch Data from SQL: Retrieve the correct row from an SQL database based on a value passed in the URL query (e.g., ?workorder=12345). Extract the corresponding URL from the database. Display PDF: Use the retrieved URL to display a PDF file in a viewer, such as , in the same way as in this demo: **Integrate with Forminator: Pass the retrieved URL into a hidden field in a Forminator form, allowing it to be submitted with the form. **Additional Information: * The website is built with Oxygen Builder. * You will have access to all necessary systems to complete the task. * If you have experience with WordPress, SQL, PDF viewers (e.g., ), and Forminator, this task should be straightforward
I'm looking for a C# plugin for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all meas...for Power BI Desktop that can help me optimize my reports. The plugin should: - Detect unused columns in tables and create M queries to remove them. - Scan all open Power BI reports and list them in a combo box for selection. - Identify all measures in the selected report and provide optimized DAX code for each. A list of these measures should also be in a combo box. My primary data sources are SQL DB and Excel, so experience with these is crucial. The plugin needs to work with both imported data and Dir...
...registration with email activation using PHP Mailer - User login - 'Forgot Password' functionality - Bootstrap 5.3 for responsive design - Server-based validation - User-friendly notifications via session on every action Security is paramount in this project. The application must be robust against various types of attacks, specifically Cross-Site Scripting (XSS), Cross-Site Request Forgery (CSRF), and SQL Injection. Additionally, a configuration file should be created with BASE_PATH and BASE_URL for easy management. Forms must be secure, implemented with CSRF and XSS protection as well as using prepared queries for database interactions. Ideal candidates for this project should have: - Extensive experience with PHP and the MVC framework - Proficiency in implementi...
...understanding of cloud deployments and microservices approach to build the application. - Proficient in planning, designing and implementing SPAs using Angular and developing REST APIs using Node JS. - Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in Indi...
...in 20 minutes). I need someone to accomplish two main goals in this project: 1) Modify the code so that only the bare minimum information is listened to in Alchemy to satisfy the requirements: For a given list of market/outcome IDs, once every 60 seconds fetch the object showing the top 10 holders and their number of shares. (And also NOT fetch any other information that will drive up Alchemy query usage.) 2) Configure the code so that it can be dynamic. I can write TypeScript code that will fetch and update a list of market/outcomes every 60 minutes. I just need you to configure the repo's code so that the connection to Alchemy reads in from a dynamic variable (the current list of markets). When you apply, send me an example of related Web3 work that you've done, o...
...cloud data storage or remote monitoring capabilities. Skills and Experience Required: Proficiency in electronics and hardware setup (experience with sensors like moisture sensors, load cells, and color sensors). Expertise in microcontrollers, particularly Raspberry Pi or Arduino. Strong experience with Python programming, including sensor integration and data handling. Familiarity with databases (SQL) and building basic dashboards/GUI (if required). Ability to troubleshoot hardware and software issues effectively. Previous experience with similar projects (portfolio or examples of past work is a plus). Timeline: Basic Setup (Hardware + Software): ~7–10 days Optional Features (Dashboard, IoT, Database): Additional 5–7 days Budget: Please provide an estimate based on yo...
Sensor data from Arduino to SQL database locally.
I'm looking for an experienced tutor for an intermediate level session focused on Power Query and Power BI. The session will involve using a practice dataset to clean data, transform it, and merge queries in Power Query. Key Areas of Focus: - Data Cleaning - Data Transformation - Merging Queries In Power BI, we will be concentrating on: - Creating Dashboards - Data Visualization - Automating Reports Ideal candidates should have a strong expertise in Power Query and Power BI, with proven experience in teaching and using practice datasets. Your ability to simplify complex concepts and create a fun, engaging learning environment will be key to a successful session. Please provide examples of previous tutoring sessions you've conducted related to these topics...
...Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a large volume of data and multiple simultaneous users. Deliverables: • Custom Web Crawler that scrapes and collects data from ...
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-query basis. Key Areas of Focus: - Usage tracking: I need guidance on how to implement this feature and help troubleshooting any issues that arise. - Parental controls: I require assistance with feature implementation and bug fixing. - App restrictions: I'm looking for an expert to help optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iO...
...strtoupper($eircode); } if(in_array(substr($eircode,0,3),$ir_identifiser)) { //$eircode = $eircode." ".$ll; $eircode = $eircode; $eircode = str_replace(' ', '', $eircode); $eircode = strtoupper($eircode); }else{ $eircode = ''; } $mapsApiKey='AIzaSyB1DsbfwbSiKJmpR5aBmCxtErD54l177K0'; $query = "".urlencode($eircode)."&key=".$mapsApiKey; $data = file_get_contents($query); // if data returned if($data){ // convert into readable format $data = json_decode($data,true); //print_r(json_encode($data)); //exit; $address=$data['predictions'][0]['description']; $addressquery="".urlencode($address)."&am...
I'm a recent high school graduate seeking assistance with data entry into my SQL-based database. Ideal Skills: - Proficient in manual data entry - Experienced with SQL databases (e.g., MySQL, PostgreSQL) - Strong attention to detail and accuracy - Good communication skills - Problem-solving abilities
I'm experiencing issues with the ADX formulas in MySQL. The results I'm getting from the built-in SQL functions are incorrect. Specifically, I'm trying to calculate the directional movement, but the output doesn't align with my expectations. Skills and experience that would be ideal for this job include: - Extensive knowledge of MySQL - Proficiency with SQL's built-in functions - Experience troubleshooting formula-related issues - Understanding of directional movement calculations
...Technical Skills ### Primary Technologies - Flutter (Latest stable version) - Flutter Web - Firebase - Dart (Latest stable version) ### Required Firebase Services Knowledge 1. Firebase Authentication - Email/Password authentication - Phone number verification - Custom claims for role-based access - Security rules implementation 2. Cloud Firestore - Database design and structuring - Query optimization - Indexing - Security rules - Batch operations 3. Firebase Storage - File upload/download - Security rules - Image optimization - Content delivery 4. Firebase Cloud Functions - Background tasks - API endpoints - Scheduled operations - Event triggers ### Required Flutter Expertise 1. State Management - Provider pattern - S...
We look for a professional web developer with SQL, PHP, Zend / Laminas / Wordpress and coding knowledge that can reprogram / uplift a existing and working quotes & jokes website (Mobile compatible) from Zend 1.12.2 to Laminas and from php 7.4 to php 8.3 where all current functionalities are covered (front & backend). We are also open to lift the whole project into wordpress, hence it would help to administrate the site, but this is only a option if all existing functions can be covered. The site has a database with keywords, authors, topics and pictured as well as a ranking system of the quotes. Also a improvement on current site loading speed fot most ranked quotes should be improved. SEO is also covered well now but some improvemtns might help too. We need a clear proper c...
...features an organization chart that currently doesn't fit on a single page and click event to view the number of person on the Job Category showing in the chart. Microsoft Visual Studio Project & SQL Database backup attached, attached the Organization Chart Generated by this application. Key Tasks: - Adjust the layout of the chart to a vertical orientation. - Ensure the chart fits within a single page. -Click Event on Each Job Category Ideal Skills: - Proficiency in ASP.NET and Microsoft .NET Framework. - Expertise in graphical layouts and responsive designs, including jQuery. - Experience with SQL database integration for handling chart data. - Ability to deliver a quick and efficient solution. Most Important: - The chart should be responsive primarily for d...
...Simple, user-friendly interface for searching indexed data. • Fast and relevant search results. • Results should be displayed with the most relevant information at the top (based on keyword match, ranking, etc.). 5. Database Integration: • Purpose: Set up a database to store and manage crawled data and indexes. • Features: • Use a scalable database like MySQL, PostgreSQL, or MongoDB. • Efficient query handling to fetch search results quickly. 6. Scalability & Performance: • Goal: Ensure the entire system is optimized for performance, scalability, and reliability. • Details: The search engine should handle a large volume of data and multiple simultaneous users. Deliverables: • Custom Web Crawler that scrapes and collects data from ...
This project aims to streamline and automate data preparation, analysis, and visualization processes within the tourism sector. By transitioning from manual Excel-based workflows to an automated system using Power BI and Power Query, the project seeks to improve efficiency, accuracy, and decision-making capabilities. Objectives of Dashboards in Power BI Build interactive dashboards to visualize key trends, traveler preferences, and satisfaction levels. Utilize advanced Power BI features such as DAX formulas and custom indicators to provide meaningful insights. Statistical Indicators Generate descriptive statistical measures (e.g., average, median, and standard deviation) directly within Power BI. Use these measures to establish benchmarks and identify trends.
You MUST do the work FIRST, consider this a "CONTEST". 1. You create the WORDPRESS SITE on YOUR SERVER (or on my server if trust me), show me, and BID. 2. I AWARD, PAY Milestone, and then you send Wordpress Template/Theme and SQL database/data. 3. I IMPORT your SQL into my Wordpress mysql and install your Template and TEST. Then I release 2nd Milestone and give you a PERFECT rating if all works well. I'm looking for a skilled WordPress developer who can create a WordPress template that closely replicates the design of my current website. Key Requirements: - Proficiency in WordPress development - Strong understanding of web design principles - Ability to replicate design elements accurately - Creative thinking for potential design improvements Please no...
...logins and profile setups. Personalized Offers: Employ machine learning (e.g., ) to analyze customer behavior and suggest tailored offers. 3.2 Sub-Contractor Data Collection Performance Metrics: Provide a dashboard built with or D3.js for subcontractors to track their performance. 3.3 Transactional Data End-to-End Transaction Tracking: Securely store transaction data using SQL or NoSQL databases. 3.4 Real-Time Monitoring Operational Dashboards: Build dashboards with real-time updates using React or Angular connected via WebSocket. 4. Admin Features (Backend/Management) 4.1 Sub-Contractor Management Profile Approval: Admins can manage subcontractor profiles through an Admin Panel built with React and Redux. 4.2 Customer Support & Dispute Resolution In-App Support Chat:
I am seeking an experienced Microsoft SQL Server developer to create stored procedures that will handle input data validation for my database. The validation needs to cover: - Format validation: Ensuring data is in the correct format before entry. - Range validation: Verifying that data falls within acceptable limits. - Uniqueness validation: Checking that input data is unique where required. Ideal candidates for this project should have a strong background in SQL Server and data validation processes. Previous experience with writing stored procedures is a must. Please provide examples of similar projects you have completed in the past.
We operate a job portal, , built on PHP and SQL. Our goal is to extend our reach by linking job posts with prominent job websites like Indeed and LinkedIn, and possibly others like , Monster Jobs, TimesJobs, etc. Key Requirements: - Real-time synchronization of job postings across platforms - Integration of an Application Tracking System (ATS) We already have accounts set up on both Indeed and LinkedIn. The ideal candidate for this project would be someone with substantial experience in job portal integration, preferably with knowledge of implementing an ATS. Please provide your most competitive quote.
I’m working on an Angular/.NET application with a functional small attachment tab UI and several working APIs. However, I’m facing issues with two APIs: 1. Insert API: Data is not being inserted into the database. 2. Fetch API: Unable to retrieve data properly. Technologies used: - Frontend: Angular - Backend: .NET Core, .net framework - Database: [SQL Server/MySQL, MongoDB.] Deliverables: - Fix the insert and fetch API issues. - Ensure proper testing for functionality.
I'm looking for a LookML professional who can assist me with creating models and explores within Looker. Key Responsibilities: - Develop and implement LookML models specifically focused on Dimensions and Measures. - Help me in joining multiple tables within derived tables. Ideal Skills: - Proficient in LookML and Looker. - Extensive experience working with SQL databases, BigQuery, or Redshift. Please provide examples of your previous work with LookML models.
I'm in need of a Python backend developer, preferably a fresher, with a focus on API development and database management. The project will primarily involve working with SQL databases and leveraging the Django framework. Key Responsibilities: - API Development: Building, testing, and maintaining APIs to support various applications and services. - Database Management: Overseeing the interaction with our SQL databases, ensuring data integrity and optimizing performance. Ideal Skills: - Proficiency in Python, particularly in a backend context. - Familiarity with SQL databases, including basic query writing and database design. - Prior experience or knowledge of the Django framework. - Understanding of API structures and principles. This is a great opportun...
I'm urgently seeking an expert raw PHP developer for a 2-months project. The developer is required to work on upgrades to our existing reporting panel at our Nikaton, Dhaka, Bangladesh office. Freelancer have to work in our physical office . It's not a remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - ...
I'm looking for a skilled SQL developer to create a query for data retrieval from my MySQL database. Ideal candidates for this project should: - Have extensive experience working with MySQL databases - Possess a strong understanding of SQL syntax and functions - Be capable of writing efficient and effective data retrieval queries.
I’m looking for a freelancer to help move data from an MS SQL database to Google BigQuery and automate this process using Python scripts. The goal is to centralize the data for better analysis and set up a structure in BigQuery that is organized and scalable for future use. I will provide access to BigQuery so the freelancer can set up datasets and organize the data directly within the platform. Scope of Work: Data Extraction and Transformation: - Extract data from SQL tables (e.g., inventory, item details, sales history) based on specific fields and filters - Ensure data is cleaned and formatted for smooth loading into BigQuery. BigQuery Setup and Organization: - Access BigQuery to set up and structure datasets (e.g., inventory_data, sales_data, item_details). -Ens...
Tenemos un sistema que tiene archivos .ADE y . ADP, bk de sql server. Como este sistema esta obsoleto, necesitamos migrarlo o adaptarlo a algo mas moderno. Preferiblemente web based o si es mas economico desktop base.
...availability. As a developer, you will contribute to building and maintaining robust, scalable, and high-performing web and desktop applications using the latest .NET technologies. Responsibilities: Back-End Development: Develop and maintain server-side components using C# and ASP.NET Core. Design APIs (RESTful or gRPC) for seamless front-end integration. Work with Entity Framework and databases such as SQL Server or SQLite for efficient data management. Ensure secure and scalable solutions through best practices in cryptography and system architecture. Front-End Development: Create intuitive, responsive, and dynamic user interfaces using React, Angular, or Blazor. Implement modern web standards using HTML5, CSS3, and JavaScript/TypeScript. Optimize front-end performance and en...
as discussed in the chat section
...likes, shares, and comments - **Time-based Rankings**: Generate daily, weekly, and yearly highscores - **Data Storage**: Use a database to store and manage collected data - **User Interface**: Develop a simple interface to view leaderboards and engagement statistics ### Technical Details: - You can use Facebook Graph API or any external tools for data collection - Database choice is flexible (SQL or NoSQL) - Method of data transmission and storage is open to your expertise ### Deliverables: 1. Functional engagement tracking system 2. Database setup for data storage 3. Leaderboard generation system 4. Basic user interface for viewing results 5. Documentation on system usage and maintenance ### Additional Notes: - The specific programming language and technologies used are up...
...Quote Request: Please provide a detailed quote for completing the tasks outlined in this brief. 8. Tech Stack: Frontend: React: Core frontend framework. TypeScript: For type-safe JavaScript development. Vite: Build tool and development server. Tailwind CSS: Styling and responsive design. Shadcn UI: Pre-built UI components for consistent design. React Router: Client-side routing. React Query: Data fetching, caching, and state management. React Hook Form: Form handling and validation. Backend (Supabase): PostgreSQL: Main database. Supabase Auth: Authentication and user management. Supabase Storage: File storage (e.g., contracts). Supabase Edge Functions: Serverless functions (built with Deno). Supabase Realtime: Real-time features and subscriptions. Third-party I...
...Details: Error Message: PHP Notice – yiibaseErrorException: Undefined variable: where Code Snippet:: PHP $connection = Yii::$app->getDb(); $command = $connection->createCommand("SELECT id FROM product $where"); $result = $command->queryAll(); Potential Causes: Missing Variable Definition: The $where variable might not be properly defined or assigned a value before it's used in the SQL query. Configuration Issue: The migration from cPanel to DirectAdmin might have caused configuration changes that affect how variables are handled within the application. Technical Skills Required: Proficiency in PHP 7 development Experience with the framework Understanding of database queries and variable scoping in PHP Project Deliverables: A ful...
We we forced to udpate our server form centos7 to alvaviva that has a more recent version of mysql, now one main pure php file we have are throwing some errors. We need someone to update it. No logic changes needed just syntax and maybe some database access query.
My Elasticsearch setup is currently experiencing critical health issues, particularly with the cluster. I am in need of a seasoned network administrator who can diagnose and rectify these issues, as well as optimize the overall performance of Elasticsearch. Key Requirements: - Expertise in Elasticsearch version 7.x - Proven track record in network administration - Ability to enhance search query speeds - Skills in solving cluster health and indexing problems Your timely intervention can help restore my Elasticsearch to optimal health and performance.
I'm seeking a seasoned SQL Server expert to configure transactional replication on my SQL Server for a production environment. Key Requirements: - Configure Publisher and configure Subscriber in SQL server. - In-depth knowledge and hands-on experience with SQL Server - Proven expertise in setting up and configuring transactional replication. - Familiarity with production environment protocols and best practices. - Strong problem-solving skills and attention to detail.
I'm seeking a seasoned SQL Server expert to configure transactional replication on my SQL Server for a production environment. Key Requirements: - Configure Publisher and configure Subscriber in SQL server. - In-depth knowledge and hands-on experience with SQL Server - Proven expertise in setting up and configuring transactional replication. - Familiarity with production environment protocols and best practices. - Strong problem-solving skills and attention to detail.
I need a query function that handles total event duration data. The function should be able to process numerical data representing event durations. The example sheet contains the data and i want a sum(v) in the query function in the cell A8 error message : Impossible d'analyser la chaîne de requête pour Le paramètre 2 de la fonction QUERY : AVG_SUM_ONLY_NUMERIC
I'm looking for a professional with strong skills in Filemaker and .Net Core. The primary focus of this project is data management, specifically integrating with an SQL Database. Key Responsibilities: - Integrate Filemaker with an SQL Database - Carry out data retrieval tasks Ideal candidates should have: - Proficiency in Filemaker and .Net Core - Experience in SQL Database integration - Strong data management skills
...search workflows that retrieve the most relevant content based on the user's query. You will integrate the search functionality with the AI agent, ensuring that retrieved data is dynamically passed to GPT-4 for natural language generation. The frontend will be developed using , with a focus on dynamic rendering and SEO optimization. Each user query should trigger a unique layout and interactive design that adapts to the type of response generated by the AI agent. The system must support fully dynamic layouts to ensure each search session feels distinct, even for repeat queries. Visualizations will play a significant role in enhancing user experience, and you will implement or D3.js to render query-driven, interactive charts, graphs, and other data visualizati...
Tengo un catalogo de usuarios en sql server 2014 y necesito un formulario sencillo que pueda agregar y corregir datos del mismo. Quiero que se muestren los registros y el boton de alta y corrección. Adjunto un archivo xls donde estan los campos y puse dos imagenes con las pantallas que deberia tener, estas solo son de ejemplo. Los campos son los que estan en la tabla sql server
