Sql server 2005 stored procedures työt

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). -------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

server optimisation

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...

DEFININTIONS local environment: developers laptop client: Wayne contractor: Faisal and his team PROBLEM STATEMENT Due to missing connection to database, the website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the we...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I am in need of a skilled freelancer with expansive knowledge in tax filing and planning, financial statement preparation, audit and assurance services, winding company procedures, and addressing private limited pending compliances. Ideally, you should have vast experience in handling financial matters for small businesses. Your application should include: - Detailed project proposal: Kindly break down how you plan to provide the services I require. Highlight your approach, the steps you will take, and the tools and methodologies you will employ to ensure everything is done professionally and up to standard. Skills and Experience: - Certified Accountants and Company Secretaries: Given the complexity of the work, it's crucial that you have completed professional certificat...

Server Admin for and Node.js

...reflect our current location. - Update contact phone number: You will also need to update the contact phone number associated with the account. - Update RFC: We require the "RFC" (tax identification number) to be correctly displayed in the account for invoicing purposes. We're seeking a professional with: - Proficiency in Google Ads: You should have a solid understanding of Google Ads billing procedures and be able to navigate the platform with ease. - Technical aptitude: The task will involve navigating the Google Ads account settings and updating the necessary information. Previous experience in similar tasks would be beneficial. - Remote assistance skills: As I require remote help to make these changes, you should be able to guide me through the process effic...

I'm in need of a seasoned IT professional who can set up a Windows-based VPN server for my company. The primary purpose of this server is to allow our employees to access the company's resources securely from remote locations, which is currently a pressing need for us. Key Requirements: - Configuration of a VPN server on Windows OS - Setting up a secure connection for remote employees - Allowing simultaneous connection for a small user base (1-10 users) Ideal Skills and Experience: - Proficiency in Windows OS - Hands-on experience with VPN server configuration - Knowledge of network security best practices - Prior experience with remote access solutions Your expertise will play a crucial role in enhancing the security and efficiency of our remote w...

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...

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...

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...

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

...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...

...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...