Sql stored procedure vs function punët
Pershendetje Glen. Jam e interesuar per ndihmen tuaj ne SQL. Do te me duhet ndihma jote ne nje provim neser. A mundeni te me ndihmoni me nje shume prej 10 euro per 1 or e gjysem?
Programing in Dot Net & SQL Server. Visual Studio 2010, SQL Server 2012 Express ose më të avancuar. Modify existing modules, add modules, design interface, Reports...etc
Create a High End 3D video for a device. This is an automatic stapler used in medical procedure. The video
I'm in need of an experienced STL Fusion 360 designer to bring my sketch to life in a functional mechanical device prototype. The project will include: - Translating my sketch into a 3D model using Fusion 360 software. - Creating a design that can be tested for functionality. - Revising the prototype until it is able to successfully complete its intended function. Ideal candidates will have experience with STL Fusion 360, mechanical prototype design, and a keen eye for translating sketches into functional models. Photos are of 1st try ..I need slight dimensions adjusted and a taper ( 45 degree change to cylinder.. see the shots with markers and the plastic inside are just to help visualize it . I cam supply a working fusion 360 file if needed and saves me money
I have a small business and am seeking a skilled web designer to create a simple landing page for me. I've chosen a color scheme (blue and white) and know exactly what I want on the page. The main function of this landing page is to display my business information. It should be clean, simple, and easy to navigate. I'm looking for a design that's professional and has a modern touch. I'd like the landing page to include: - A brief description of my business - Just use random text I will update it - A color scheme that's mainly blue and white I really appreciate a freelancer who has experience working with Wordpress and is skilled in creating effective, eye-catching landing pages. A good eye for design and attention to detail are key. I'm open to discu...
...quality Executes work efficiently and meets agreed on deadlines Completes most development activities independently Requirements Core Requirements: Strong background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservice...
Pagination function doesn't work. Specific page url:
E-comerce hecha con React, Tailwind CSS , Framer Motion y cuenta con un chatbot con IA como asistente virtual En el Backend cuenta con una base de datos SQL y node Js y Javascript para la conexión a la BD Tiene una auténticacion de usuarios Y cuenta con integración a MercadoPago
I'm in need of an experienced SQL developer who can assist with writing stored procedures in SQL Server. The purpose of these stored procedures is for data loading. Key Responsibilities: - Writing stored procedures for data loading Ideal Skills & Experience: - Proficient in SQL and SQL Server - Prior experience with writing stored procedures - Experience with data loading processes The complexity of the stored procedures is expected to be at the basic CRUD operations level. As this is focused on data loading, it requires someone who is meticulous and well-versed in data manipulation within a SQL environment.
I have a mobile application's source code, written in PHP, that I need converted into an APK file with necessary settings. Key Requirements: - Convert PHP source code to an Android-compatible APK file - Implement necessary settings for the app to function properly on Android devices Ideal Freelancer: - Proficient in PHP and Android app development - Experienced in converting PHP applications to Android APKs - Has a good understanding of Android-specific settings and configurations
...T+1, T+2, T+1 month). Settlement frequency varies based on the company's designated timeline (e.g., Company A settles transactions every 3 working days, excluding public holidays, Saturdays, and Sundays). For AliPay and WeChat Pay, settlement follows China's public holiday schedule, while other payment methods adhere to Singaporean holidays. Implementation Approach: We plan to utilize two arrays stored in the database to manage public holidays. Before settlement, we'll iterate through these arrays to ensure accurate scheduling. Admins have the capability to update the public holiday list and adjust settlement durations (e.g., T+1 or T+30) for each company. Conclusion: We're looking for a dedicated freelancer with the requisite technical expertise to contribute...
...and password login system. The focus should be on ensuring user credentials are securely handled and stored. Experience with implementing this in a NoCode environment is a must. - Database Integration: The project will make use of an SQL Server. The freelancer should be able to efficiently integrate and manage an SQL Server database with the NoCode tools. Previous experience with SQL Server is required. - We need to integrate some process, after all, we need to implement the solution in Azure. In summary, I'm looking for a freelancer who is skilled with NoCode tools, specifically Bubble and FlutterFlow, has implemented email/password user authentication before, and has experience with SQL Server database management. Please contact to get mor...
I posted this job before and the freelancer who took it gave many assurances but unfortunately could not fulfill them. So here is the project again. It is a MasterStudy LMS that needs UI and UX enhancement. The aim is to make it more user-friendly, enhance the course management features, and boost its performance. It is not complicated. If you wish to bid more than $200 for ...fulfill them. So here is the project again. It is a MasterStudy LMS that needs UI and UX enhancement. The aim is to make it more user-friendly, enhance the course management features, and boost its performance. It is not complicated. If you wish to bid more than $200 for this job, don't. I am happy to give 50% additional bonus on job completion if the changes are done correctly and the LMS features function...
I need a Python expe... Key Requirements: - The integration should allow the capture and preservation of signatures directly through the Topaz Signature pad. Just script to open a form with a picture field and a button with label write now. on the pad write a signature and after save button the picturefield should be filled with the written signature/image. Image stored in same map als the script. Desired Skills and Experience: - Proficiency in Python, particularly version 3.9. - Prior experience with integrating peripherals, such as signature pads, into applications. - Familiarity with signature capture and storage mechanisms. - In now and a few hours. Write strawberry at the start of your message to show me you have read everything.
I am looking for an experienced app developer to create an intuitive, user-friendly app for Android and Web platforms. The key features of the app should include: - User registration - Tour package search - Direct booking and payment processing - A platform for clients to leave reviews and ratings - A function allowing users to customize their own tour packages For the payment system, I require integration of credit/debit card processes, direct bank transfers, and a secure Gateway transaction method. Your expertise in the development of similar apps, payment system integration, and user experience design will be crucial for this project's success. Knowledge in the travel and tourism industry is a plus.
I am looking for a skilled Woocommerce expert to help me set up a courses page on my website. I need this page to function correctly and look good, without interfering with the rest of my site. Your main tasks would be: - Setting up the courses page: ensuring the page is correctly integrated with the rest of my website, but also separate, as per my requirements. Your experience with Woocommerce and setting up similar pages will be crucial for this project. The ability to translate my design preferences into a functional and visually appealing courses page will be highly valued.
I need a Python expe... Key Requirements: - The integration should allow the capture and preservation of signatures directly through the Topaz Signature pad. Just script to open a form with a picture field and a button with label write now. on the pad write a signature and after save button the picturefield should be filled with the written signature/image. Image stored in same map als the script. Desired Skills and Experience: - Proficiency in Python, particularly version 3.9. - Prior experience with integrating peripherals, such as signature pads, into applications. - Familiarity with signature capture and storage mechanisms. - In now and a few hours. Write strawberry at the start of your message to show me you have read everything.
I want to... Features: * E-mail me the Lead with all information collected * Save in Google Sheets as a database * Main thing is to have it look nice and don't look out of place, similar font style, sizing, font size, etc * Use embed code to copy and past into my page builder * Create a plugin to help me customize the quiz, like images, text & size, etc. Desired Programming Language: PHP / SQL * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates ⭐⭐⭐⭐⭐ Please post "I've read everything" when applying to be considered, too many bots applying. Failure to do this step, you will not be contacted ⭐⭐...
Hello our company has built an online open banking payment gateway. I need people that have Lloyds, HSBC, NatWest, Barclays, Standard bank accounts. I will create a link for you with 12GBP value , i would like you to record a video of the full procedure while you are paying it and what difficulties and describe what difficulties did you face. You will get paid 25GBP for your work , (12 of your payment + 13 for your 3 precius minutes)
...to the users themselves. The primary function is to help me manage and consult detailed records of investors, similar to handling personal files. Requirements: Plugin Installation and Setup: Install and configure one or more suitable WordPress plugins that allow the creation of custom fields and profiles in the admin backend. Custom Fields for Detailed Information: The ability to add custom fields to user profiles is essential. These fields should include but are not limited to personal information, investment history, contact details, etc. Backend Management: The system should be manageable entirely from the WordPress admin panel, with capabilities to add, edit, and view investor profiles. Privacy and Security: Ensure that the data is securely stored and that privacy me...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Ex...experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, a...
...project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all tables within the database. This approach requires sophisticated coding to manage CRUD operations generically across all tables. 3. Metadata-Driven Architecture: The database tables' metadata will be managed externally and stored in and dbo.DataColumns. The API should be capable of reading this metadata to construct and manage API endpoints dynamically. 4. ORM Flexibility: Any ORM tool like Entity Framework, Dapper, or SQLkata can be utilized to facilitate database operations. The choice of ORM should align to optimize performance and simplify maintainability. 5. Advanced Data Handling: Co...
For my current project, I require an expert who's proficient in DOMO Beast Mode and SQL. The tasks will primarily involve: - Producing calculated fields: You will need to execute both complex mathematical calculations, as well as intricate string manipulations. A good grasp of mathematical principles and string handling in SQL is a must. - Transforming data: This job will further entail the aggregation of data. Being adept in grouping and managing datasets of diverse sizes will be crucial. Your comfort in working with DOMO, SQL, and data manipulation will be the key to successfully accomplishing this task. If you routinely perform these tasks and understand the underlying processes, I would love to connect and discuss the project further.
I'm seeking a PCI Qualified Security Assessor (QSA) Expert who can assist me with ensuring that my mobile app meets the necessary security standards for payment processing. The app is developed for both iOS and Android platforms, with the primary function being payment processing. Ideal skills for this project include: - Experience in achieving PCI DSS compliance requirements & QSA certification for mobile applications. - Strong background in mobile app development, particularly Android - Previous experience with payment processing apps - Excellent communication and documentation skills - Proficient in the development of secure mobile applications that process financial transactions - Certified QSA (Qualified Security Assessor) PCI level 4. Key responsibilities include: ...
I'm in need of a modern and professional-looking one-page WordPress site. The main goal of my website is to function as a platform for showcasing my services and products, not for direct online transactions. Wordpress / Design / Content / Form / Clean UX Please read the project description carefully!
...Wire communication interface. Additional pins for digital input/output as required. Deliverables: Complete PCB design files ready for manufacturing, including gerber files. Schematic capturing and PCB layout. BOM (Bill of Materials) with sourcing options. Documentation for assembly, testing, and troubleshooting. Qualifications: Proven track record with PCB design for power-intensive and multi-function projects. Proficient with voltage regulation techniques in PCB designs. Familiarity with RP2040 microchip and serial communication protocols. Proficient in electronic design automation (EDA) tools. Strong analytical skills and attention to detail. Proposal Requirements: Portfolio showcasing relevant projects, especially those involving power management and microcontroller integra...
I'm in search of a talented developer to create a web-based CRM system for my business. Here's what I need: - The CRM system should be accessible through a web browser. - Its primary function will be sales tracking. I want a solution that will help me monitor and manage sales effectively. I envision the CRM system to perform sales tracking in the following ways: - By individual salesperson: The system should show the performance of each salesperson. This way, I can analyze their work, reward high performers, and provide feedback to those who need improvement. - By team: It should also provide an overview of each sales team's performance. This will help me assess the overall productivity and effectiveness of my salesforce. - By product/service: The CRM system shou...
...Part A has a single function that function is to transmit a signal. The part needs to be housed in a waterproof container and be powered by a rechargeable battery preferably through USB. This part will actually go on a dogs collar. The device can either transmit vi. RF, USB or any other short range signal. Part B: Part B its job is to have two functions. The first function is to receive a signal from Part A, the second job of Part B is to transmit a specified RF signal to Part C when Part A is within 2 to 3 feet of Part B. Part B, needs to also be housed in a waterproof container and be able to be charged via USB. Part C: Part C, is a separate module that is already created its job is when it receives a specified RF signal from Part B it activates its predesigned ...
...repository given its already installed. Here's what needs to be done: 1. **Testnet Bitcoin Integration**: I need you to create a new Testnet Bitcoin account for me. This integration is critical to test all functions of the website. It's quite important that you understand the intricacies of Bitcoin Testnet. 2. **Recaptcha Connection**: You'll need to connect Recaptcha using an API key. The main function of this feature will be to prevent bot activities on the site. Experience with implementing and optimizing Recaptcha is paramount. 3. **Investment Option**: Users need to have option to deposit in to the site bankroll. already has this feature, it needs to mimic this feature. I believe you will need to be familiar with node.js to option for users. The ideal fr...
...can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the scanned website data. Chatbot Integration: * Develop a chatbot...
...YouTube We will be selling adversing space within the sections and will need to be able to edit very quickly to start an ad campaign for one of our customers advertising in the app so we will need the admin panel to be easily edited. The advertising will come from local businesses that we will advertise within the app. We must have the function to create both ads within the sections like in "Where to Eat" but also we must be able to have a pop up function. The app must look perfect, fresh, new and sleek. Also, please be aware that we are starting this in one area then having other areas covered so we will need to use the same app template to create other apps in other areas. If you bid low then increase the price later after reading this, your bid will b...
Básicamente quiero que me ayuden a crear la base de datos para un gimnasio en SQL server
I require an expert proficient in Python, SQL, and Java to work on a Codility assessment. The assessment will be conducted at an intermediate level and will be inclusive of various tasks that I will be solving in the language of the question. Key Requirements: - Comprehensive Knowledge in Python, SQL, and Java - Proficiency in tackling Codility assessments - Understanding of the assessment's specific concepts and frameworks Remember to adhere to Codility's test format and code-writing guidelines. Your completion and success of this project will greatly depend on your ability to grasp and execute these particularities.
...seeking an experienced WordPress developer to create a unique, engaging, and user-friendly adult content website. Key functionalities: - E-commerce integration: The site should integrate seamless online payments for subscriptions or specific content. Expertise in payment gateway implementation is an essential. - Membership login: Subscriptions to the site will require a robust, secure login function that protects user information. - Contact form: A simple, easy-to-use contact form is also needed for customer queries. Content specifications: The site will exclusively host adult videos, specifically focusing on the following categories: - Amateur - Professional - Fetish This endeavor will require a professional with extensive experience in WordPress, database management, an...
I need assistance to solve three coding tasks using Python, Java, and SQL. The challenge involves - Analytical problem-solving - Implementing quality checks - Code compilation The challenges require proficient skills in the aforementioned languages, while also ensuring code efficiency. Prior experience in problem-solving and understanding how to efficiently check and maintain the quality of code is a big plus.
I'm looking to create a simulate for Password Manager Web Application. The application needs to provide key features: - Strong password generation: the app must be able to generate robust passwords - Secure password storage and management: all passwords created or input into the app should be stored securely. Users should also be able to easily manage these passwords. - login - signup - another page to make GET request will provide For user authentication and access, the application should be designed to allow logging in using a username and password method. should have experience in web application development, basic encryption and security features. Knowledge in user-interface design.
Skills -core php, laravel, Codeigniter my sql database Min 1 to 5 year experience location - Mohali,Punjab, India
...allows the entry of visitor details for security purposes. - Visitor badge printing: A key feature that's crucial for the seamless identification of visitors. - Delivery: The software should incorporate a delivery management system, tracking and notifying visitors when a delivery arrives. - Employee Sign in and sign out: A function that tracks the presence of employees as they arrive at and leave the premises. Device Compatibility: The software should be designed to function across multiple devices, including: - Desktop computers - Tablets - Mobile phones Ideally, your background should include: - Extensive experience in developing visitor management systems. - Proficiency in integrating software with courier services. - A strong understanding of user interface desi...
...mechanical diptube prototype I'm developing. The prototype is a structural one, so the ideal candidate would have experience in product design. Requirements: Conceptual Sketches: Rough sketches that outline the basic concept of the diptube design. These sketches should capture the key components and their relationships. Functional Diagrams: Create diagrams that illustrate how the diptube will function within the larger system. This could include flow diagrams to show the movement of fluids through the diptube. Component Layout: Develop a layout of the individual components within the diptube assembly. This will help visualize how everything fits together and identify any potential issues with spacing or accessibility. Mechanical Drawings: Produce detailed drawings of eac...
...traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new blocks to the blockchain and receive rewards in the form of newly created Bitcoins. The Advantages of Bitcoin Bitcoin offers several advantages over traditional forms of...
I'm looking for a talented developer to create an overlay extension for my Twitch channel. The primary function of this extension is to display real-time topics on my stream that I can discuss with my viewers. This will be designed on the Twitch extension development site. How to: ( ) Key Features: - A timer-driven popup: The extension should be able to pop up a new topic for discussion on the screen that all viewers and the streamer can see and also prompts us in chat. - Configurability: I need the ability to set the frequency at which these topics are displayed. It should be configurable, for example, every 5 minutes,
...traditional currencies, which are controlled and regulated by central authorities, Bitcoin is governed by a network of nodes that collectively validate and record transactions on a public ledger known as the blockchain. The Mechanics of Bitcoin At its core, Bitcoin is a digital asset that can be exchanged and transferred electronically. Each Bitcoin is represented by a unique cryptographic code stored on the blockchain, which ensures the integrity and security of the network. Transactions are verified through a process called mining, where miners compete to solve complex mathematical puzzles in order to add new blocks to the blockchain and receive rewards in the form of newly created Bitcoins. The Advantages of Bitcoin Bitcoin offers several advantages over traditional forms of...
I'm in need of a proficient mobile application developer comfortable with both iOS and Android platforms. The primary function of the application is for e-commerce. Key features should focus primarily on enabling user login and profile creation. The successful freelancer should have substantial experience with: I have file of both android and ios developer needs to convert into apk and upload it into apple store and google play store. - Creating e-commerce applications on both iOS and Android platforms. - Designing and integrating user login and profile functionality. - Ensuring user profile security. - Efficient database management and usage for storing user information. - UX/UI design skills would be a bonus to create an engaging and friendly user interface.
I'm looking for someone who has very good experience in Laravel's real world situation. What Queue drivers are available in Laravel? Will ignore any ...Queue drivers are available in Laravel? Will ignore any replies without answering to the above my question. Here is my problem now. We are using Laravel project and it's running on production. It's using Queue heavily and queue driver is database now. We are getting following issue. SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction (Connection: mysql, SQL: select * from `jobs` where `id` = 111111 limit 1 for update) Let me know how to fix this then I will hire you immediately and you can be employed in our project. Please don't waste my time if you don't know...
I'm in need of assistance with Codility assessments, specifically focusing on intermediate-level problem-solving tasks. Your work should encompass: - Expertise in SQL or Python. Familiarity with both languages is advantageous. - Proficiency in algorithmic programming, capable of thinking strategically to solve intermediate-level problems. - Ability to assist in solving three different task types in Codility, including: 1. Time complexity problems 2. Sorting and searching problems 3. Counting elements problems Ideal candidates would have experience preparing or mentoring for codility assessments and a strong background in programming. Your intricate knowledge of problem-solving within the realms of algorithmic programming would be highly beneficial. A methodical appro...
I am in need of a user-friendly, responsive website specifically for selling women's clothing. This should feature: • A comprehensive section for product reviews • An accurate size guide • A wishlist function allowing customers to save their favorite items for future reference • Tax and shipping calculators adaptable based on customer location Initially, my inventory will start with 10 unique products, however, there will be an inventory quantity of around 500 units. An ideal candidate would have experience in e-commerce website development, product management systems and should be well-versed in creating intuitive and holistic user journeys. Experience in building sites for the fashion industry would be a bonus.
I am in need of a user-friendly, responsive website specifically for selling women's clothing. This should feature: • A comprehensive section for product reviews • An accurate size guide • A wishlist function allowing customers to save their favorite items for future reference • Tax and shipping calculators adaptable based on customer location Initially, my inventory will start with 10 unique products, however, there will be an inventory quantity of around 500 units. An ideal candidate would have experience in e-commerce website development, product management systems and should be well-versed in creating intuitive and holistic user journeys. Experience in building sites for the fashion industry would be a bonus.
I'm looking for a skilled React Native developer to create an app that supports both iOS and Android. The primary function of this app will be using the AppsFlyer SDK for deferred deep linking. Key Project Requirements: - Platform Support: The app should be compatible with both iOS and Android platforms. - Functionality: The app's main purpose is to incorporate the AppsFlyer SDK for deferred deep linking. The ideal candidate should have: - Strong experience in React Native app development. - Proficiency in integrating third-party SDKs, particularly AppsFlyer. - Prior experience with deferred deep linking is highly preferred. It's crucial that the developer is able to efficiently and effectively incorporate the necessary elements of the AppsFlyer SDK for deferr...
