SQL Server Stored ProceduresJobb
Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.
Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.
Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok
Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer
Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget
Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...
Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.
Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.
Server installation, Xen virtual, mysql, apache
Jag har pågående arbete relaterat till vårat tidigare projektLogo for SrvTrack - a Server Monitoring System'
...Googles Adwords-API så kan det bli aktuellt att göra motsvarande projekt där. **English version** We're looking for someone who has experience working with Facebook's API for advertising, who can help us automate the process of publishing targeted ads from our system to Facebook. Our system is based on a Java-environment, where we have a large number of job ads targeted to different groups stored in a database. It's some of these jobs we're looking to publish as Facebook ads, targeted at the correct audience (gender/age/region). This project can either be done as something you write in Java, which will be added as a module to our current system, publishing selected data to Facebook. Alternatively we'll provide and xml/json-file...
Hej! Behöver hjälp med en samba-server till Mac, som ska användas till videoredigering. Programvaran finns, men ska skrivas om helt och hållet, med lite ytterligare funktionalitet.
Behöver ett kort skript som gör följande, typ: 1. Packa ihop ett antal filer 2. Skicka till server 3. Anslut till server 4. Packa upp filen 5. Sätt lite rättigheter på servern
I need a proficient legal expert to draft a motion to dismiss for a case that is challenging the court's jurisdiction. I am targeting this in the State Court. K...this in the State Court. Key Details: - The legal basis for the jurisdictional challenge is both on Personal Jurisdiction and Subject Matter Jurisdiction. - Your main task includes researching relevant common law case citations for use in the motion. Ideal Candidate: - Your skill sets should include, but not limited to, strong legal research, excellent drafting, and knowledge of state court procedures. - A background in law with a successful track record in drafting motions to dismiss will be highly advantageous. - Familiarity with common law is crucial for this project. Prompt and accurate delivery is paramount...
...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of da...
Tutti i siti web che puntano al server in questione ritornano un errore 503 Service Unavailable. intervento da effettuare al più presto tramite connessione TeamViewer (dal mio pc ci sono tutti gli accessi SSH admin ecc...). per visualizzare l'errore, di seguito un sito web impattato dal problema : grazie
I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of inv...
...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred. 8+ years of total experience. Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle. Proficiency in SQL and PL/SQL programming languages. Strong understanding of database design principles and data modeling techniques. Experience with database performance tuning and optimization. Excellent communication and leadership skills. Ability to work effectively in a fast-paced environment and manage multiple priorities. Relevant certifications in Netezza and Oracle te...
Our existing ...CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...
I've encountered an internal server error on my website when accessing a specific page. This issue is particularly critical as some of my visitors are unable to access my site due to this error. While some visitors can browse the website, others are completely blocked. Key Project Details: - The error is triggered when accessing a specific page. The rest of the website is accessible. - The issue is causing a split in visitor access, with some able to view the site consistently and others unable to access at all. - The problem is particularly urgent as it is directly impacting my site's usability. Skills and Experience Needed: - Proficient in troubleshooting common internal server error causes. - Experience in addressing website access discrepancies for users based...
I encountered an internal server error while trying to access a specific webpage on my website. The error is isolated as it only occurs on certain pages. Some visitors can access the site and some cannot. For example: I can access with WiFi but not with my mobile connecction. The ideal freelancer for this project should have: - Proficient understanding of server-side technologies and the workings of web servers. - Strong problem-solving skills and the ability to troubleshoot technical issues effectively. (Wordpress) and (godaddy) - Experience in handling internal server errors, ideally on specific pages. - Good communication skills to effectively inform me of the error's cause and resolution. Please contact me if you have experience with this issue and think you...
...with the data visualizations, such as filtering views based on time or sentiment. Tools & Techniques: Web Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. D...
I'm in need of an experienced web developer with strong shell scripting skills. While the main purpose of the website application is not specified, it's targeted at the general public. Ideal Skills and Experience: - Proven expertise in web application development - Experience in creating websites geared towards the general public - Robust skills in shell scripting - Ability to independently make decisions to enhance website functionalities Note: As the tasks for shell scripting are undefined, a flexible way of working is preferred for meeting emergent needs in the project.
...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...
I'm in need of CNC cutting plans for designing disassembly joints primarily enhancing recycling purposes. The design will majorly involve the use of wood. - The project focuses on three types of joints - Butt, Lap, Mortise, and Tenon. Each should be designed with dismantling in mind to facilitate recycling procedures. - The ideal freelancer should have significant experience in CNC cutting design, with an in-depth understanding of woodwork joint designs - Familiarity with sustainable design principles, especially concerning recycling, will be highly appreciated. The overall goal is to minimally impact the environment while producing functional and aesthetically pleasing joints. Your contribution will play a significant role in my journey towards eco-friendly woodwork des...
I'm in need of an IT professional to set up an SMTP server on my Debian server. The primary purpose of this setup is to allow the server to send out automated email notifications for a custom-built application. Key requirements and expectations for this project include: - Setting up an SMTP server specifically utilizing Sendmail software on a Debian server - Ensuring that the configuration is optimized for automated email notifications - Providing guidance or documentation on how to integrate the SMTP server with my custom-built application Ideal candidates for this project should possess the following skills and experience: - Proficiency in working with Debian servers and setting up SMTP servers - Prior experience with Sendmail configurat...
I'm in need of an experienced professional or team to assist in a comprehensive pre-employment vetting process. This is for various positions with...comprehensive pre-employment vetting process. This is for various positions within our company in Erbil, Iraq. Key Requirements: - Conduct detailed background checks for potential employees. - Verify personal and professional references. - Perform a thorough criminal background check. Ideal Skills: - Extensive experience in HR, security or related field. - Familiarity with the pre-employment vetting procedures in Iraq. - Strong investigative and research skills. Your assistance will be crucial in ensuring that our recruitment process is thorough and our company's interests are protected. Please provide a rough timeline for...
I am seeking an RPA Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt file - starting cell (no...
...create an automated document verification system focused on improving the document management process of educational or related institutions. The system needs to handle verification processes for transcripts, certificates, and IDs. Key Features: - Real-time Verification: It is imperative that the system can verify documents immediately upon submission. - Secure Storage: Verified documents should be stored securely, ensuring confidentiality and data protection. - User-friendly Interface: The system should have an intuitive and simple-to-use design to allow effective handling of documents. Integration: - The system should be capable of API integration for seamless incorporation into existing structures. Ideally, the developer should have a strong background in system developmen...
I have a PostgreSQL database hosted on AWS. When trying to connect to my database server from my web application, I'm consistently receiving a TCP/IP error. Key Project Points: - The issue is specifically related to the TCP/IP connection between the web application and the AWS PostgreSQL database server. - The PostgreSQL database is hosted on AWS; it's not a local instance. - The web application is the only service experiencing this issue with the server. Ideal Freelancer: - Proficient in AWS services, particularly Amazon RDS for PostgreSQL. - Strong background in dealing with network errors, particularly TCP/IP. - Experience in troubleshooting web application and database connectivity issues.
Our established US-based LED sign manufacturing business seeks reliable guidance on navigating the complexities associated with expanding to Uruguay. We are seeking a knowledgeable professional to provide assistance in navigating the business registration and legal set up. The ideal candidate will possess: - Understanding and familiarity with Uruguayan business laws & procedures applicable to foreign investors establishing their presence locally, including but not limited to taxation (RUT), labor legislation through CASMU registration process as well as relevant permits/licenses based on our intended scope of operation. - Exceptional communication skills both in English and Spanish for seamless collaboration with US executives while representing us effectively towards authoriti...
Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.
Hello After a reboot of a server our cpanel not working anymore, need urgent helpwith IMMEDIATE availability
...seamlessly integrate with the Aftership API. The main goal of this integration is to automate the process of generating DHL shipping labels. Key Responsibilities: - Utilizing JavaScript to create a script within the Airtable app for this purpose. - Configuring the Aftership webhook to relay the responses from the API to my Zapier app. Once the DHL shipping labels are generated, they should be stored within the Airtable app. This will allow for manual retrieval and distribution as needed. Skills and Experience Required: - Proficiency in JavaScript is a must. - Prior experience working with Airtable scripting and API integrations. - Familiarity with Aftership and Zapier would be beneficial. - Understanding of DHL shipping label generation processes. It's important that t...
I'm in need of a programmer well-versed in TIA (V18) Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility wil...Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility will be to help me export a datalogfile created in TIA (V18) Unified to a CSV file using JavaScript. The purpose of this export is for archiving, as the datalogfile is stored locally. Please reach out if you believe you have the right skills and experience...
I'm currently facing an issue with a backup failure concerning application data using an offsite backup solution. The issue requires urgent attention as it's impacting business continuity and data management. Ideal Skills: - Expertise in offsite backup solutions - Strong knowledge of data recovery procedures - Provided experience with application data Responsibilities: - Diagnose the cause of the backup failure - Recover application data from backup - Ensure future robustness of our offsite backup system.
We need an expert to produce content for our card-based learning platform. The content will specifically focus on: - Banking procedures Ideal skills should include: - Expertise in banking and financial services - A profound understanding of card-based learning and content creation - Ability to impart complex procedures in a detailed, yet easy-to-understand manner Our focus is for learners to grasp fully optimised banking operations. We require a detailed walkthrough, so freelancers would be providing comprehensive, step-by-step guides on various banking procedures. This is a creative yet strategic role, perfectly suited for someone well-versed in both the banking industry and engaging content creation.
...hard-to-find information. Requirements: Expertise in Data Privacy: The ideal candidate should possess a thorough understanding of data privacy laws and regulations, particularly regarding the removal of personal information from online platforms. Technical Proficiency: Proficiency in online reputation management tools and techniques is crucial. Familiarity with Google's removal policies and procedures is a definite plus. Attention to Detail: Meticulous attention to detail is essential to ensure that all instances of my personal information are effectively erased from the targeted websites. Why This Matters: In today's digital age, our online presence can significantly impact our personal and professional lives. Protecting our privacy is paramount, and removing sen...
Following skills are required: 1) Azure Pipeline creation for deploying Spring Boot application to Azure App Services (not Azure Spring App Services) 2) Azure Pipeline experience to deploy Artifacts (Gradle) We need somebody to walk us through the steps within an online meeting. We have set-up to Spring applications one needs to be stored as Artifact and the other one is based on the Artifact solution (dependency) and needs to be deployed to Azure App Services. We estimate the meeting to take between 2 - 4 hours. We'll only consider candidates who have performed this activities already.
I need assistance completing a simple WordPress plugin that posts directory data to a database and displays it on a page. The data includes names, images, and links extracted from HTML. Therefore, the required functionalities inc...Familiarity with handling data through form submission and visualization techniques. The data integration will not involve manual input, spreadsheet import, or API connection as the data is already displayed on the page. We just need it saved. This is to complete a mostly complete wordpress plugin which already captures the user ID, Data source ID and captures the html data which needs to be stored. We have a problem getting the plugin to trigger an Ajax response which we need help debugging. Please submit your bid if your skills align with these req...
...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we
I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portf...
...work like any navigator only when a search is going on (keep rotation with arrows otherwise) Keep H/P shortcut and click things to hide: -Instead of only selecting and hiding, the user could maintain the shortcut (H or P) and pick what to hide progressivly. Press 1/2/3/4/5/6/7/8/8/0 (above the letters) to show/hide the main collections: -The state of visibility of the objects has to be stored and recovered. Add the bonus collections in the searchbar options: -A bonus collection is a list of objects. The name of the list should appear in the searchbar and the objects whose name is in the list should be selected when this bonus collection is selected. See in the Unity project for the bonus collections as in this 'BONUS' sheet: () Keep 'H'...
...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...
I'm looking for a server administrator with intermediate Drupal experience to handle ongoing maintenance. Key responsibilities include: - Monitoring the server's performance and troubleshooting any issues that arise. - Ensuring the server remains secure and up-to-date with the latest patches. - Regularly backing up the server's data to prevent loss in case of failure. - Updating and maintaining the Drupal installation, ensuring compatibility with the server setup. Ideal skills and experience: - Proficiency in Linux server administration and management. - Intermediate level of experience with Drupal, including installation and configuration. - Strong troubleshooting and problem-solving skills. - Understanding of best security practices for server...
...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled f...
Bought a react eCommerce template (front-end & back-end) from theme-forest. Provided documentation is not enough for server side installation. I need professional assist to install the project on server side and install the theme on server side.