When to use stored procedures and functions in sql server jobs
Thumbnail for my monetized/commercial/personal use YouTube video
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my speci...
...schematics, PCB and firmware for a compact NFC reader. The suggested RFID controller is PN7160. Microcontroller - STM32 0) Two boards - antenna and the main board. The antenna diameter is 15mm with a hole in the center 4-5mm. The main board is 14mm in width and length is 35mm or less. 1) The reader must read and write password-protected memory blocks in Mifare Classic cards. 2) The reader keeps the password for the RFID cards as a hard-coded constant. 3) The reader has an 4-byte reader ID stored in its EEPROM memory. 4) The RGB LED on the edge of the main board, whose location matches the hole in the antenna. RGB LEDs are connected to the PWM pins of the controller. 5) A waterproof (if possible) speaker must b...
...platforms, including my website, print materials, and social media platforms. While certain designs might be welcomed, I do not have a specific color preference, leaving the artist with creative freedom in that regard. Ideal candidates for this project should have: - Ability to communicate and work efficiently with specific themes regarding floral design and script, custom fonts. - Understanding of branding across multiple platforms More specifically: I am in the process of starting a (super small) floral business, growing all my own flowers from my garden in Loveland, Colorado. I am a one-woman strong operation with a passion for growing beautiful flowers and spreading that joy to others. I would like to create...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I'm seeking an experienced Python freelancer to implement RLlib's PPO for a custom multi-agent environment, where agents act independently. Your tasks will be: - Solving the issue with the learning process. Despite configuring the simplest setting with just one agent, the model fails to find the optimal action. Additionally, the model seems unable to distinguish between the optimal actions for agents with the same action space but different endowments. Ideal skills include proficiency in Python, familiarity with RLlib's PPO algorithm, and previous work dealing with agent-based environments. Experience in crafting efficient reward functions is a plus.
I'm seeking a skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP req...
I'm looking to have a custom aimbot script made for a game that was released in 2004. This game has no anti-cheat, making the development process seemingly straight-forward for someone with experience in coding Gunbound scripts. The aim of this project is to create a basic aimbot script. I'm open to programming language suggestions, as long as it's optimal for the task at hand. I'm not interested in additional features at this stage, just a simple script to enhance aiming in the game. Ideal Skills: - Proficiency in coding custom aimbot scripts - Experience in Gunbound or similar game - Proficient in C++, Python, or AutoHotkey (preferred, but not mandatory) - Strong understanding of game mech...
hello I am currently planning to start a startup. I am currently entering the IT field (fields such as Facebook and Instagram) and need a programmer to join me. The working hours per day will be more than 40 hours, and a small salary may be paid per month. I have very creative ideas and am ready to grow into a global company. If you join me, I will provide you with an additional salary increase and a higher position as the company grows (e.g. Data Manager/Marketing Manager, etc.) Anyone who can do any of the following is welcome. -programmer -translator -lawyer -Server maintenance -Marketing expert -Anyone else who can contribute to the growth of the company Anyone who has a lot of passion and is starting ...
I'm in need of a talented web designer who can help me craft a vibrant and engaging website primed for a general audience. Key Responsibilities: - Crafting a visually impressive and user-friendly site that's appealing to the average web user - Ensuring the site is responsive and functions seamlessly on all devices - Implementing the preferred color scheme of bright and vibrant to create an energetic and positive impression on visitors Ideal Skills: - Proficiency in web design, with a strong portfolio of previous work - A keen eye for design, particularly in creating sites with a vibrant color scheme - Understanding of user experience (UX) principles to ensure a smooth and intuitive site...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 f...
hello We are currently looking for someone to manage the server that will run our website and app. (Please enter “ITO” to confirm) -Work: Anywhere you want -Job description: Manage everything from server hosting to operation In particular, maintenance/repair to ensure that security is very strong. Video conference once a week Submit work details and inspection results as a report every three days -Salary: $100/month ((Budgets may continue to increase as the company grows in size and sales increase))
I am looking for an experienced freelancer to help me automate the saving of PDF email attachments from Outlook. I currently use the Outlook Desktop Application and need to save these attachments without having to open each email individually. I have 4,000+ emails to check Key Requirements: - Expertise in Outlook Desktop Application - Proficiency in creating automated systems - Knowledge of PDF handling and saving - Timely and efficient work delivery - A good communicator to understand requirements and provide regular updates The saved PDFs do not need to be organized in any specific manner; they can all be stored in a designated folder. I'm hoping to streamline thi...
I require a typographic logo and a minimalistic logo ( for favicon and social media ) primarily for identification purposes. Instead of serving marketing or branding functions, the logo needs to simply and clearly represent my company's name. Please ensure the logo design: - Is typographic: The design should be text-based, using font styles, size, and color to create an impactful image. - Contains the company name: My preference is to use the company name, and no other characters or slogans. For this project, successful candidates will have: - Extensive experience in typographic logo design. - A strong understanding of how a logo contributes to a company's identity. - An impressively creative ...
...designer who can create a professional, clinical, and informative infographic about gynaecology. This project has a turnaround time of 24 hours. Key Information: - The infographic should primarily focus on gynaecological examination procedures. This could include common practices, the importance of such procedures, and other relevant information. - I expect a clear, professional layout that effectively communicates the information visually. Requirements: - Proven experience in creating healthcare-related infographics, ideally with a focus on women's health. - Strong understanding of gynaecology and the ability to communicate complex medical information in a visually engaging way. - Excellent design skills with a keen eye f...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example pro...
...with experience on modding Call of Duty Black Ops 2 and bot development on Discord. The project objectives include: CUSTOM IN-GAME COMMANDS AND PERKZ - Creating custom Plutonium server settings for Black Ops 2 Zombies. - For the commands, i want there to be the basic commands that anyone can use, and “vip” commands for the players who have vip role. - Most if not all of the custom perks scripts i want have already been published on the plutonium forum. - Also needs stats tracking DISCORD BOT - Developing a Discord bot capable of linking a player's Discord account to their in-game GUID. - Granting players access to vip in-game commands thru the discord bot - in-game points rewards fo...
...developer to create a simple, yet effective admin dashboard with user authentication. The template for the dashboard is ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication shoul...
...looking for an experienced web developer to create a cross-platform e-commerce website. Key Requirements and Deliverables: - Create a user-friendly e-commerce website that functions seamlessly on both iOS and Android platforms - The website should have a clean and modern design, conducive to a positive shopping experience - Implement essential e-commerce features, such as product listings, shopping cart, secure payment gateways, and customer account management Skills and Experience: - Proven expertise in website development, particularly in e-commerce - Experienced in creating cross-platform websites for both iOS and Android - Strong understanding of user experience and responsive design princi...
...professionals located worldwide Please put "ITO" in your proposal to make sure we read it carefully. Here's what you'll be doing -Number of positions: 5 (subject to change) -Tasks: Preventing hacking / preventing data leakage / monitoring servers in real time / modifying and maintaining websites / adding new website features / developing new web and app features / increasing server security / ensuring compliance with privacy laws .... and most other services required to run apps and websites. -Meetings: All work is done at your location, and once every 7 days, we have a video conference with all developers, and you can send us a report of your daily work and server check...
I'm looking for someone to transform my 35 process flow procedures from Visio to Microsoft Word. The goal is not just to convert these diagrams, but to apply complex formatting including tables, graphics, and appealing textual arrangement. More specifically, - Maintain high levels of detail from the original Visio files, however, please refresh the colored flow diagrams to normal boxes coloured royal blue. - Keep as many graphical elements as possible during the Visio to Word conversion. This task necessitates a good understanding of both Visio and Word. The ideal candidate would be proficient in graphic design and document formatting, with an eye for detail and the ability to interpret ...
I am looking to build a robust, user-friendly marketplace website for an array of services, designed to emulate the seamless experience akin to Uber Eats / Booksy. Services will prominently include restaurant bookings, spa appointments, professional services and home repairs, crating a market place for the SME South African service orientated industry. Key Features and Functions: - The platform should ideally be based on Shopify to ensure a smooth user experience and efficient management. - The marketplace should emphasize on restaurant bookings, spa appointments, and home repair, and professional services. - The site needs to incorporate a calendar-based system for streamlining bookings and appointments....
I'm in need of a mobile application that will help me track the items stored in various boxes. The application must be versatile, enabling me to create and scan QR codes, maintain a detailed list of items per box, and even take photos and add images for better organization and identification. Key Features & Functionality: - Tracking Items in Different Boxes: The primary and most crucial function of the app is to enable the user to keep a comprehensive record of the items stored in various boxes. - QR Code Creation & Scanning: The app should offer the functionality to generate QR codes for items and boxes, and the ability to scan these codes for easy da...
We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.
Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.
I am looking for an experienced CodeIgniter developer to upgrade my existing CodeIgniter 3 project to CodeIgniter 4. The project is currently live and needs to maintain the same database structure and functionality. The key tasks include: Upgrade CodeIgniter Version: Migrate the entire project from CodeIgniter 3 to CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in...
...talented developer to construct a robust DDEX music distribution system. This platform will serve as a key component of my radio station's operations. We're looking for a developer with experience on building a DDEX distribution system where the user can upload the tracks and albums, images to distribute on different dsp sites like Spotify, Beatport, Apple Music, etc and receive music from our industry partners. With functionalities where the user can upload any format of track file like mp3, wav, flac so that it can be encoded into different formats and can be distributed to different dsp sites depending upon required formats. The administrator can upload the royalty files in different formats like xls, csv, txt. provided by d...
...an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the cons...
I have a complex Excel file with more than 10 work...The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across m...
I am looking for a website designer to create a modern, minimalistic website for my cosmetic surgery practice. The website should significantly enhance the generation of potential client leads. Key features for the website include: - An online booking system for appointments, providing an easy and convenient way for potential clients to reach out. - A cutting-edge before and after photo gallery showcasing the results of various cosmetic procedures. - A testimonials section featuring feedback from previous patients to inspire trust and confidence in potential clients. Experience in designing healthcare or professional service websites would be ideal for this project. The design should be sleek, clean, and modern to...
I need a highly functional booking and appointment website specifically designed to fit the needs of my clinic. As an essential feature, it must effectively manage detailed patient records. Key integration encompasses live chat support, a contact form, and both audio/video online consultation features. Ideal skills and experiences: - Proficiency in creating medical/clinic-based websites - Experience in implementing effective booking and appointment features - Experience with patient record management systems - Expertise in integrating communication features such as live chat, contact form, and online consultation tools on a platform - Strong history of data security to ensure patient details are safely stored ...
I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a...
My Python script is intended to scrape specific Telegram groups, but it's not functioning as expected. I need a developer to address these issues, described below. - **Issue Description**: The script is crashing when scraping certain Telegram groups, which is likely due to the fact that it's not respecting selections. The error presented is “ AttributeError: 'MessageMediaWebPage' object has no attribute 'document'” I can provide the script if you want to check how it’s working. I am open to a whole new script being made. So long as it functions in a similar way. If not familiar you can view telethon api - **Expected Behavior**: The scraping script is supposed to collect data...
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm seeking a proficient developer to create a robust system that utilizes CCTV cameras to monitor vehicle speed and license plates. This system will need to take images of overspeeding vehicles, store the data in a public cloud, and send it to clients via email and WhatsApp. Key requirements include: - Compatibility: The system must be compatible with Windows, Mac, and Android. - Speed Detection: The system should use image recognition to determine vehicle speed. - Data Storage: The captured data should be stored in a public cloud. - Alerting: Notifications for speeding vehicles should be sent to clients through email and WhatsApp. Prior experience with CCTV camera integratio...
I'm looking for a mobile app developer to create an Android app that will serve as a platform for users to engage. Key Features: - **User Login and Registration:** The app should allow users to create accounts and log into them. User data should be stored securely. - **Push Notifications:** I want the ability to send push notifications to users through the app. This feature should be robust, allowing for targeted and engaging notifications. I'm eager to see your past work in mobile app development, particularly for the Android platform. Experience with push notification systems and secure user authentication is a plus. If you're confident in your ability to deliver a solid ...
I need to move my ASP.NET 3.5 application from a 2008 server to a dedicated server. Key Requirements: - Migrate ASP.NET 3.5 application: The current application is running on ASP.NET 3.5 and needs to be seamlessly moved to the new dedicated server. - Hosting Environment: The application should be set up on a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - ...
I am in need of a custom-designed desk for my music studio. This desk will serve three primary functions: storing recording equipment, managing cables, and organizing my workspace. It is essential that the desk be of a custom size, tailored to fit my specific needs and studio setup. A traditional style with a wood finish is preferred, bringing an elevated aesthetic to the overall studio environment. Skills and Experience required: • Significant experience in woodworking and custom furniture design. • Awareness of the specific needs and constraints of a music recording studio. • Familiarity with cable management solutions. • Exceptional attention to detail. • Demonstrated ability to...
...skilled and creative ghostwriter to develop engaging and informative content for my executive transportation business website. This content will include product descriptions and About Us pages for three satellite sites, as well as for the main site which also functions as an app. Key Responsibilities: - Write unique and compelling product descriptions for the service offerings on the four sites. - Develop professional and engaging About Us pages that effectively communicate the brand identity and values of the business. - Ensure all content is SEO optimized and aligns with industry best practices. - Adapting to the specific tone and style of each website, from the more corporate main site to the m...
Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving avera...
I'm in need of a skilled electronic circuit and hardware engineer to help me with the design and selection of components for a project. The project involves the creation of a power supply, an analog digital converter, and a relay. Key Responsibilities: - Circuit design: I need help with creating the circuit for the mentioned components. This includes ensuring the circuit is efficient and functions as intended. - Component selection: I'll require assistance in selecting the right components for the circuit. It's crucial to choose components that are of high quality and fit the project's requirements. The ideal candidate for this job should have a solid background in electronic engineering, pa...
I'm in need of a skilled web programmer proficient in HTML/CSS, JavaScript, and PHP to create a comprehensive work tracking portal. I have a very rough semi functional example site attached. This will be hosted on a private server with vpn access from each user so security is not a extreame concern. key functions basic login system allow users to enter daily work time with some notes ; I would like them to be able to edit them after allow users to see a list of all open jobs and be able to click on them to open them and edit as needed client management - need to be able to search existing clients or add new ones as well as view any jobs open or closed for the cli...
I'm in need of a Flutter Developer to assist with updating our existing Art Prizes app for both iOS and Android. We've made additions to the underlying .NET solution and now require integration of new pages and features. It's crucial that you have a solid understanding of Flutter as well as knowledge on integrating APIs. Previous experience in updating existing apps and implementing push notifications is highly desired. If you don't have a rating of 4.9 or higher I won't be contacting you. You will have a formal process for versioning the iterations and you will have inhouse testing available. If you deliver an initial solution that is full of bugs we won't continue working with you. First deli...
I'm looking for a modern and minimalist logo that combines both text and icon elements. The primary use of this logo will be for my online presence, such as my website and social media platforms. Key Requirements: - Combination of text and icon. - Modern and minimalist style. - Suitable for online usage. Ideal Skills and Experience: - Previous experience in creating combination logos. - Ability to design in a modern, minimalist style. - Understanding of best practices for online logo design. - Strong portfolio that showcases relevant work. - Excellent communication skills to understand and deliver on my vision for the logo.
I'm seeking a specialist to locate a VPS/VRoot server that can provide minimized latency to a website origin hidden behind a Cloudflare proxy. The task encompasses: - Identifying the server with the lowest possible ping based in Europe. - The server should run on a Windows operating system. - The ultimate objective is to improve user experience by minimizing latency. Ideal freelancers for this job will have a robust understanding of server locations, operating systems and how they interplay with website latency. Experience with Cloudflare proxies, Windows-based servers, and in-depth knowledge on achieving optimal latency is distinctly beneficial. The website would be and I require the lowest ping ...
...Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculation...
I need a talented developer to build me a cloud-based SaaS ERP system with specific features and integrations. - The system should include essential functions like Inventory Management, Financial Management, and Customer Relationship Management. - It should be customizable at a basic level to allow for changes such as colors and the addition of a logo. - In terms of integrations, I require the system to connect seamlessly with CRM, E-commerce platforms, and Payment Gateways. Ideal candidates should have a strong background in developing SaaS ERP systems and possess the necessary technical skills to integrate different software and platforms. A solid understanding of inventory management, financi...
