Sql server 2005 stored proceduresงาน

อยากได้เว็บหรือบอท Discord ที่ทำงานแค่ทำหน้าที่เช็ครายชื่อคนที่ออนไลน์อยู่ใน Server ณ เวลาปัจจุบัน

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

ติดตั้ง VOIP SERVER เพื่อใช้โทรศัพท์สายในและสายนอกบน Linux

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Serve...

...candidates who don't speak Japanese are still considered ■Prohibition - Copying or rewriting of any existing content or article already submitted - Submitting products that copied from any result from automatic translation tools or software - Reprinting or leaking of any contents to a third party Plagiarism is crime, and please be aware that there is a case of termination of the contract and legal procedures when such act including "copy and paste" would be discovered....

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

ทำการเรียกข้อมูลไปยังหน้าเว็บโดยใช้ Stored Procedure ที่ทางเรากำหมดให้ โดยใช้ Component ของ DevExpress

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

PBX System SIP Server on Cloud สำหรับธุรกิจขนาดกลางและเล็ก โดยไม่ต้องลงทุนอุปกรณ์ Server PABX PBX ต่างๆ ไม่ต้องเตรียม infra ให้ยุ่งอยาก เคลื่อนย้าย ไปตาม Site สะดวก โทรหา site to site ฟรี บริการค่าโทรแบบเหมา แบบรายนาที ทั่วโลก

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

...tanker truck. I'm going to use the truck to transport used cooking oil. Fill out the Excel sheet attached, with one row per vehicle and fill out all of the columns. You will need to call to ask about the info for some of the columns. Requirements - Don't include vehicles that don't meet these requirements: 1. Tank capcity - Must carry between 3k-6k gallons 2. Location - Must be in the US 3. Year 2005 or newer 4. <300k miles 5. Fuel type - must be diesel 6. Issues - The truck must have no known issues other than aesthetic issues (e.g. if it needs paint that's fine, but if there's a mechanical issue that's not fine) Please ask if you have any questions about the requirements or expectations of this project. If it goes well, there is opportunity f...

I need assistance with importing our sales leads from an Excel file into our CRM system, Recman. Key Requirements: - The Excel file is stored on Drive and needs to be accessed, processed and imported. - The specific data fields to be imported include: Contact information, Lead source, and Sales history. - No specific data transformation or mapping is required, the data can be imported as is. Ideal Skills: - Proficient in handling Excel files, particularly in a Drive environment. - Familiarity with Recman CRM is a plus. - Good attention to detail to ensure all relevant data fields are correctly imported.

...Invoice Data: Invoice number, date, amount, client, supplier, details, etc. Users: Name, email, password (encrypted), roles (admin/user), and assigned root folder. Metadata: Additional information such as upload date, validation status, etc. 3. Front End (User Interface) Create a web interface using Django (preferred) or a similar framework. Required functionalities: View invoices extracted and stored in the database. Edit invoice data through the front end. Upload new invoices directly through the web interface, process them, and store the data in the database. Filter, search, and sort invoices by various criteria (e.g., date, client, amount). 4. User Management Implement an authentication system: Registration, login, and password recovery. Roles: Administrator: Can manage use...

I need a professional to set up a SQL Server failover cluster for 10 applications, all running on Windows Server. This will be for a UAT environment and will involve a quick proof of concept on 2 nodes. Key Requirements: - Setup of SQL Server failover cluster - Testing of the setup as a proof of concept - Evaluation of the SQL Server version used by each of the 10 applications The ultimate goal is to achieve an 'always on availability group' level of high availability. Ideal Skills: - Extensive experience with SQL Server - Familiarity with Windows Server - Knowledge of high availability configurations - Ability to conduct a proof of concept Successful completion of this initial setup and testing will lead...

...application development, deployment, and operations •Monitoring security: Monitoring system health and performance, security alerts, and events •Responding to incidents: Responding to incidents promptly and performing root cause analysis •Ensuring compliance: Ensuring compliance with industry standards and regulations •Maintaining security policies: Maintaining and improving security policies, procedures, and documentation •Responsible for integrating security tools and processes into the DevOps pipeline •In the event of a security incident or breach, assist in the response and recovery process; work closely with incident response teams to mitigate the impact of a breach •Overseeing and improving operational processes •Analyze data, trouble...

I'm looking for a MySQL expert who can help me create a stored procedure that calculates the following financial metrics from my internal database: - Exponential Moving Average (EMA) - Simple Moving Average (SMA) - Average Directional Index (ADX) The calculations will need to be based on daily data. Ideal skills for this job include: - Extensive experience with MySQL - Strong understanding of financial metrics - Ability to create efficient stored procedures Please note, the metrics need to be calculated using data from my internal database, not an external source.

...functional, with a solid user base, but requires ongoing updates, bug fixes, and potential feature enhancements. Technology Stack: Frontend: The website uses React with for server-side rendering, which helps in optimizing load times and SEO. Experience with JavaScript, TypeScript, and modern CSS frameworks like Tailwind CSS or styled-components is essential. Backend: While primarily frontend-focused, some backend knowledge would be beneficial. Although specifics aren't provided, familiarity with RESTful APIs or GraphQL could be useful for data fetching or integration with external services. Database: Knowledge of SQL or NoSQL databases would be advantageous for handling any database operations if required for new features or data management. Deployment: The site is ...

Requerimos una persona con experiencia en gestion de usuarios de red para implementarlos en un servidor con Windows Server de forma de que cada usuario tenga su cuenta de red con permisos específicos de acceso a carpetas del servidor.

...in an urgent situation as my server has been compromised. It's an old Debian 7.11 system running apache2, with several Virtual Web Domains, Postfix, PHP & MySQL. A malicious hacker seems to have infiltrated through a security loophole and is now using my server to send out spam, severely damaging my mail server's reputation. Your primary tasks will be to: - Analyze net and apache logs to identify the backdoor and trace the malicious code. - Fix the security hole in the system. - Remove any remaining malicious code from the server. I am able to provide you with root access for thorough analysis. The log files that should be prioritized for the analysis include: - Apache access and error logs I have a specific list of virtual web domains hosted on th...

...Analyze and resolve data duplication issues in inventory and client-stored wine records. Generate and review reports to identify discrepancies in purchase orders (POs) and sales orders (SOs). Collaborate with internal teams to reconcile discrepancies between Xero and Wine Owners. Propose and implement solutions, including script-based corrections, to rectify the migration dataset. Provide guidance and recommendations to prevent future data migration errors. Work closely with our ERP partner, Wine Owners, to ensure all adjustments align with system requirements. Requirements: Proven experience in ERP data migration and troubleshooting, preferably with platforms like Wine Owners or similar inventory management systems. Expertise in SQL, Python, or other relevant programmin...

I'm looking for an experienced professional to upgrade my ASPVS250 from Server 2012 to Server 2025. Key Requirements: - Upgrade the server, which primarily functions as a Remote Desktop. - Migrate totally critical applications from the existing server to the new one. - Ensure a smooth transition with minimal downtime. Ideal Skills: - Extensive experience with Server 2012 and Server 2025. - Strong knowledge of Remote Desktop Services, particularly the Enterprise version. - Proven track record in critical application migration. Please get in touch with your relevant experience and proposals.

I am dealing with slow queries, particularly when querying a very large number of records from multi...that are consistently slow, I need an expert who can deeply analyze the situation, identify the root cause of the problem, and implement effective solutions to improve overall database performance. Ideal candidates should have: - Extensive experience as an MS SQL Database Administrator - Proven track record of diagnosing and resolving database performance issues - Ability to optimize query performance and improve system efficiency - Strong skills in performance tuning and database optimization techniques - Familiarity with MS SQL Server Management Studio and other relevant tools. - You need to have knowledge in .NET EF Core A proper candidate needs to have at least...

I am seeking a seasoned SQL Server Administrator to assist with database maintenance tasks, specifically focusing on backup and restoration. Your primary responsibilities will include: - Performing a one-time backup and restore of the database. Ideal candidates should have extensive experience in SQL Server management and database maintenance. Excellent problem-solving skills and attention to detail are essential.

I need professional help with filing appeal documents for a civil case in my local court. Ideal skills and experience for the job: - Prior experience with court appeal document preparation and filing. - Familiarity with local court procedures and regulations. - Background in civil law would be beneficial. - Excellent attention to detail and organizational skills. - Ability to meet tight deadlines.

...CMS - Preferred: WordPress or another user-friendly CMS that allows IO’s internal team to update content easily. We are open to recommendations based on your expertise. - Survey / Form Functionality The homepage survey should be a multi-step form with conditional logic, if possible. Captured data should be stored securely, ideally integrated with a CRM or at least easily exportable. - Speed & Performance Optimize for fast load times. Follow best practices for images, code, and server configurations. - SEO-Friendly Use SEO best practices (meta titles, descriptions, proper heading structure, image alt tags, etc.). We aim to rank for relevant keywords in accounting, HR, and advisory services. - Security & Compliance SSL certificate for secure data transmis...

I need somebody with server management skills to help me troubleshoot my app running on a VPS with Plesk. The app is built on Rails 8 and is currently displaying an nginx 403 error. I've checked the server logs and haven't found anything unusual, so it's likely a configuration issue or permissions error that's causing the 403 error page to display. Key Responsibilities: - Diagnose the cause of the nginx 403 error - Configure server settings as needed for Rails 8 app - Optimize server settings for performance and security - Provide a brief report on the issue and the resolution Ideal Skills and Experience: - Strong knowledge of server environments, particularly VPS and Plesk - Experience troubleshooting nginx errors - Some experience ...

We are ...of OIC components. * Good hand-on experience of Lookup configuration. Knowledge of Library configuration and certificate & Key management is a plus, but not mandate. * Understanding of large file manipulation with segment read is a plus, but not mandate. * Understanding of Encryption and decryption in FTP connection and stage file activity is a plus, but not mandate. * Good hands-on experience of SQL and basic of PLSQL. * Knowledge of BIP report is a plus, but not mandate. * Excellent analytical and problem-solving skills * Strong communication and interpersonal skills for effective collaboration with cross-functional teams * Experience in Kafka and OCI Streaming is good to have skill Preferred Qualifications: * Oracle Cloud Platform Application Integration certifica...

...evaluate my .NET and SQL based ERP software. The testing should cover: - Functionality: Ensure all features are working as intended. - Performance: Assess the speed and efficiency under various conditions. - Security: Identify any potential vulnerabilities. I need the testing to be conducted from the perspective of: - Admin: Tests should simulate actions and interactions of a system administrator. - Manager: Tests should reflect the experience and tasks of a managerial user. Additionally, the testing should encompass various database operations, including: - CRUD operations: Verify Create, Read, Update, Delete functionalities. - Code: Testing should extend to the software's code base for any potential issues. The ideal candidate will have extensive experience with .NET...

...would like to automate: ### The process should be as follows: 1. The user submits their question to a chatbot (Telegram): they can send a written text, a voice message, or even a photo or a document. 2. The incoming message is sorted and analyzed: - If there are documents, they are stored in a G-Drive folder, and a Google Sheet is updated with columns for "timestamp," "interpretation" (summarizing the content of the document), and "link" (the "link" column contains the link to the document stored in G-Drive). This Google Sheet would simplify my manual processing. // If you have a better suggestion for this step, I’m open to it. 3. A response is then provided. Here are the two possible scenarios: - **If the us...

...for real-time tracking of sales, inventory, and customer metrics. Power BI: Designed interactive dashboards to visualize KPIs like revenue growth, cart abandonment rates, and customer acquisition. Connected multiple data sources to create unified reports, providing actionable insights for stakeholders. Implemented DAX functions for advanced calculations and custom metrics. MySQL: Wrote complex SQL queries to retrieve, aggregate, and analyze transactional data from the eCommerce database. Performed data normalization and optimized queries for faster processing. Created schema diagrams to map out relationships between products, customers, and orders for better data understanding. Tableau: Built visually appealing dashboards for trend analysis on customer behavior, product perfor...

...experience in online advertising, click data, or anti-fraud systems is preferred. - Familiarity with popular automation testing frameworks and tools (e.g., PyTest, Selenium, etc.). - Ability to set up and maintain testing environments, simulate user behavior, and design tests for boundary cases and abnormal scenarios. - **Data Analysis & Problem-Solving Skills** - Proficiency in using tools like SQL and Excel for data extraction and analysis. - Strong logical thinking and analytical skills to quickly identify and report issues discovered during testing. - **Communication & Teamwork** - Excellent communication skills with the ability to collaborate effectively with development, product, and security teams. - Highly self-motivated and responsible, able to perf...

...mobile-friendly (or has a dedicated app) would enhance usability. Simple Timer Interface: A straightforward and easy-to-use interface for instructors to start/stop timers during each training task. Progress Tracking: Both instructors and students should easily see which modules have been completed and how much time each task took. 7. Security and Data Privacy: Ensure that all student data is securely stored, especially if you are tracking personal performance metrics. Comply with any local regulations (like GDPR, HIPAA, etc.) for privacy of student data....

I'm in need of a survey form designed for market research purposes. The survey will primarily consist of multiple choice and rating scale questions. Key Requirements: - Design a survey form that can be easily shared via a Watsapp link. - Ensure the survey is user-friendly and engaging to encourage participation. - Survey data to be stored with client (on their servers/ accounts) and partial information with us. Ideal Skills: - Experience in survey design, particularly for market research. - Proficiency with creating shareable survey forms.

I'm experiencing logical errors in the business logic of my SQL Server stored procedure. These errors occur during specific queries. I need an expert to diagnose and fix the issue.

I'm seeking a professional with a strong HSEQ background to modernize my PowerPoint traini...Health and Safety Act 2020 - Refresh visuals and photos - Ensure consistency in formatting and style The training materials are specifically designed for employees in high-risk environments. Therefore, a comprehensive understanding of relevant health and safety protocols is essential. You'll also need to highlight specific elements of the Health and Safety Act 2020, including: - Risk assessment procedures - Emergency response protocols - Worker rights and responsibilities The ideal freelancer for this project will have a solid understanding of health and safety standards, exceptional PowerPoint skills, and an eye for detail. Please provide examples of similar projects you'...

I'm seeking a skilled cybersecurity professional for a thorough penetration test on my website and app. The testing will be conducted from a White Box perspective, meaning you will have complete knowledge of the systems and networks involved. Key focus areas: - Identifying vulnerabilities such as SQL injection, Cross-site scripting (XSS), and Authentication flaws. - Testing critical areas of the application, including User authentication, Payment gateway, and Database security. Your expertise in these areas will be crucial in ensuring the security of my application and protecting it from potential threats. Please provide examples of similar projects you've completed successfully in your bid.

...chat or discussion forums for course interaction. Use WebSockets or similar technology for live class sessions. Deployment: Deploy the backend to a cloud platform like Heroku or AWS. Deploy the frontend to a platform like Netlify or Vercel. Ensure the portal is optimized for performance and scalability. Security & Optimization: Ensure the application is secure from common vulnerabilities (e.g., SQL Injection, XSS). Optimize for fast load times and a smooth user experience. Testing & Maintenance: Provide thorough testing (unit, integration, end-to-end). Offer post-launch support and maintenance for a specified period. Deliverables: A fully functional online learning portal. Source code with documentation. Deployment and setup instructions. Post-launch support for a mutu...

I require 2 WordPress sites migrated to a new hosting account. S...required after migration as seperate projects. Key Requirements: - Create new full backups of WordPress sites before migration. - Ensure a direct migration without any changes or updates to the sites. The new hosting account is already set up and accessible. The ideal candidate for this project should be skilled in WordPress site management and migration, with a solid understanding of data backup procedures. Experience with SEO configuration essential. Experience with Beaver builder and other WP Page Builder plugins essential. Experience with WordPress and website migration is essential, as is a keen attention to detail to ensure a smooth, error-free transfer. Sites require testing post migration. Possible SEO up...

...experience in online advertising, click data, or anti-fraud systems is preferred. - Familiarity with popular automation testing frameworks and tools (e.g., PyTest, Selenium, etc.). - Ability to set up and maintain testing environments, simulate user behavior, and design tests for boundary cases and abnormal scenarios. - **Data Analysis & Problem-Solving Skills** - Proficiency in using tools like SQL and Excel for data extraction and analysis. - Strong logical thinking and analytical skills to quickly identify and report issues discovered during testing. - **Communication & Teamwork** - Excellent communication skills with the ability to collaborate effectively with development, product, and security teams. - Highly self-motivated and responsible, able to perf...

โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด

...ASP.NET Core MVC Web application (version 8.x or higher) The application can be created completely in this technology, or can only be used for back-end, eg in the form of web API. Even so, the project must meet the conditions of use of MVC, multilayer architecture, object programming. Also, the SQL code line must not appear in the web project to separate the web page and database code (the exception is the call of SQL procedures - but make sure you know what "SQL procedure" and "call SQL procedures"! Creating a multilayer application, ie. At least the layers of presentation, Application, Infrastructure and Domain must be included. All functionality must be created and used using services (Services). In the presentation layer...