Stored procedure sql server tree child parent 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). -------...

Task is to include all these pages to the first footer area same style as they currently are on our live site 1. Remember to bring all these theme customisations to inside child theme folder - if this is correct way to work. 2. This modification is only to be done to the main template and the frontpage-template that you created. I want you to create these footer links (shown below) to the second lowest blue footer. These links needs to be nicely located and they need to be responsive with the theme as they are now at Kiinteistönvälittäjä Espoo POINT THIS TEXT TO > önvälittäjä Kiinteistönvälittäjä Helsinki > önvälittäjä Kiinteistönvälittäjä Jyväskylä > https://...

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 need an expert with solid experience with AWS services, particularly Elastic Beanstalk and S3. As part of this project, I require: - Debug two Docker applications - Deployment of two applications on Elastic Beanstalk within my existing architecture. - Set up of two S3 buckets intended to store app data and archive data. The data to be stored is expected to be in the medium range (1-10 GB). Therefore, the buckets must be optimized for this scale. Required skills and experiences: - AWS Elastic Beanstalk: It's crucial for you to understand and proficiently manage application deployment within my infrastructure. - AWS S3: You need to have expertise in creating and managing S3 buckets, specifically for storing application data and archiving purposes. The main aim of this p...

I need a skilled Power BI developer to support me with key aspects of my project. Your tasks will include: - Data modeling and visualization - Creating insightful dashboards - Generating detailed reports You'll need to connect and work with data from Excel spreadsheets and SQL databases. So, competency and experience with these data sources is crucial for this project. I'm looking for an intermediate Power BI developer. You should have a solid understanding of Power BI functionalities and the ability to translate data into clear visual insights.

As one aiming to maximize my productivity, I'm in need of a proficient data entry professional who can assist in data transcription, processing, and validation. This task revolves around: - Handling a medium scale data volume, approximately between 100-1000 records. - Processing data I have currently stored in an Excel Spreadsheet. Freelancers with the following skills are ideal for this job: - Expertise in Excel and data entry practices. - Experience in data validation. - Strong attention to detail. Your primary responsibility would be to ensure the accuracy and usefulness of my data efficiently. Your proficiency and speed are key to the success of this project.

We are in urgent need of an OVH Server Security Specialist to address recurring security issues with our server. Our server has been frequently compromised by viruses, resulting in the creation of malicious files and folders across directories. Additionally, these viruses have been generating .htaccess files that block access to internal pages of our websites. We are seeking an experienced professional who specializes in OVH server security to configure and implement optimal security measures. The ideal candidate will have a proven track record of effectively securing OVH servers against various threats and vulnerabilities. Key Responsibilities: 1- Conduct a comprehensive audit of our OVH server to identify existing security vulnerabilities and compromi...

...will be essential to provide a comprehensive analysis. - Data Visualization & Reporting: Building a robust reporting system will be necessary for clear, concise insights. - Automation & Migration: Implement RPA to automate repetitive tasks and ensure a smooth transition from PowerBI to Tableau. Skills Required: - Proficiency in PowerBI, Tableau, MicroStrategy, Excel, RPA, Data Bricks, Postgres SQL, and Python. - Experience in automating business analytics workflows. - Strong understanding of data cleaning, integration, and visualization. - Proven track record in successful migrations between data visualization platforms. I'm looking for someone who can take ownership of this project and deliver it with high precision and efficiency. A proactive approach to proble...

I'm in search of a seasoned DevOps consultant with strong expertise in Kafka and Akka. The role centers around the design, implementation, and monitoring of our cloud-based infrastructure on AWS. Strong scala programming skills and experience with Scala frameworks such as Akka. Efficient in designing and developing REST API’s. Experience with SQL and NoSQL databases. Proficiency in software design patterns and principles. Experience with version control tools such as Git. Good understanding of Agile methodologies and a collaborative mindset. Excellent problem- solving and analytical skills. Experience in unit testing (eg. JUnit/ Mockito). Experience in cloud- based environments such as AWS or Azure. Experience with Kafka and Elasticsearch. Experience : 5+ years only

...must have experience in developing RESTful APIs. You should be able to design and implement API endpoints that are efficient and scalable. - Integrating SQL Databases: In this specific project, we're focusing on SQL databases - MySQL and PostgreSQL. Your expertise in database integration should be strong. You should be able to design database schemas that align with the overall structure of the project and implement effective data retrieval and storage mechanisms. The ideal candidate for this position should have: - Proven experience working with Java Spring Boot - A solid understanding of RESTful API development - Extensive experience with SQL databases, particularly MySQL and PostgreSQL - Strong communication skills, as you'll be required to assist and...

...draggable points like this: Displaying data like this: It is a user survey to capture a users response on the axis. Once they have selected their input, they will answer 3 text box questions, and add their email and click send. 1. Experience must be responsive 2. Form must have a captcha 3. All deatils must be stored in the backend as well as emailed to us. We must be able to filter responses in the backend. Key Responsibilities: - Design a visually appealing one-page WordPress site - Implement an X Y axis for data visualization - Ensure the X Y axis is responsive and functional across devices Ideal Candidate: - Proficient in WordPress development - Experienced in data visualization techniques - Strong understanding

In search of an experienced executive recruiter to assist with our ongoing needs. Our established business operates within the Placement and Recruitment industry. We specifically require assistance with executive recruitment in our firm. ...business operates within the Placement and Recruitment industry. We specifically require assistance with executive recruitment in our firm. Key tasks: - Identify and engage potential executive hires - Pre-screening of candidates - Coordinate interview process The ideal candidate is detail-oriented and has extensive experience in executive recruiting. They know the ins and outs of recruitment procedure and understand the nuances of sourcing leaders for an established organization. Strong network within the industry is a plus. Looking forward to ...

I am seeking a skilled individual for data entry into an SQL Database. This project involves: - Converting digital non-structured data into SQL format - Inputting the converted information into an SQL Database accurately The ideal freelancer will: - Have SQL Database knowledge and expertise - Show proficiency in handling non-structured data - Demonstrate attention to detail and accuracy Experience in data entry, particularly into SQL Databases, would be greatly beneficial for this role. Your responsibilities will not only include converting and entering data but also ensuring its accuracy and consistency. I expect a high degree of meticulousness and precision from you.

I'm looking for a skilled Google Ads expert To help Audit the Google ads account and audit lead generation campaign on the Google Ads, targeting young adults (24-35F, 28-45 M). Key Requirements: - The main aim here is to generate leads for my business. -Audit for a procedure to extract google data for visitors - It's crucial to understand and effectively cater to the young adult demographic. Ideal Skills and Experience: - Proven track record in running successful lead generation campaigns on the Google Display Network. - A deep understanding of the 18-35 demographic, their online behaviors, and preferences. - Strong analytical skills to track, evaluate, and optimize campaign performance.

I'm seeking a professional software developer with extensive Code...a variety of business activities, such as managing schedules, tracking project progress, and more. Key Features: - **Database Management**: The software should primarily focus on data storage, retrieval, and basic data manipulation. Database Management Functionality: - **Data Reporting and Analytics**: Developing the capability to generate detailed reports and perform basic analytics on the stored data will be crucial. Ideal Skills: - Strong experience in Codeigniter - Proficiency in database management - Understanding of data reporting and analytics - Ability to create user-friendly interfaces This project will be a great fit for you if you're looking to work on an interesting and challenging softwa...

I'm seeking an online tutor experienced in delivering Python programming lessons for my 9th-grade child, a beginner in Python. Key focus areas would be: - Basic syntax and setup - An introduction to data structures - Problem-solving and fundamentals of algorithms The ideal tutor should have previous experience in teaching Python to teenagers, and be skilled in making complex concepts simple and engaging. Staying patient, consistent, and adaptable to different teaching methods according to the student's progress and understanding are important attributes. Kindly mention any relevant experience you have had in Python tutoring while placing your bid.

...recurring problem with my Linux web hosting server. The issue essentially revolves around the Apache service, which keeps turning itself off and on sporadically. This continuous fluctuation is causing disruptions in the operation of my hosted websites. The primary goal of my project is to address and resolve this persistent Apache service problem. I need a skilled server administrator or a Linux system expert to investigate the root cause of the Apache's erratic behavior and implement a permanent fix for the issue. Key Requirements: - Proficient in Linux server administration - Expertise in Apache server configuration and troubleshooting - Experience with identifying and resolving service disruption problems - Ability to work remotely and access ser...

I am seeking a skilled logo designer who possesses a keen eye for realistic illustration. The logo I envision needs to include the elements of objects, abstract shapes, a bourbon barrel and a palm tree. I want the final design to be rendered in grey scale. The ideal freelancer for this project would have: - Extensive experience in logo design - Proficiency in creating detailed, realistic illustrations - A strong portfolio showcasing both these skills - Excellent ability to integrate specified elements into a cohesive and appealing design - Good understanding of color theory, specifically grey scale I look forward to seeing how your skills can bring my vision to life. It’s a California and Kentucky mix

...accomplish With our team always here to help Ability to communicate and solve exciting tasks will be essential. We all collaborate together closely, work at same time with real time communication very important Experience: 1. PHP and related such as CodeIgniter, Laravel, .. 2. JavaScript and other front end technologies 3. Mobile App Cross Platform is plus for upcoming challenge 4. PostgreSQL, My SQL, etc. Work Requirements: 1. One Dedicated Programmer working on project 2. Agreed upon start finish each day to work at same time as our team 3. In addition to this site time tracker, Live Screen Sharing when paid hourly In your response: 1. Confirm agreed to above work requirements 2. Resume, Skill Listing, Example work 3. What days and times can you work in your time zone ? 4....

...software engineer with specialization in Artificial Intelligence, Machine Learning, MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and comprehensive Microsoft technologies. Preference will be given to candidates in the USA time zone. Key Details: - Main Objective: The main goal of this project is to develop a new software application. - Platforms: The application will be developed for Web, iOS and Android. Ideal Skills & Experience: - Proficient in Artificial Intelligence and Machine Learning with a proven track record in similar projects. - Expertise in MS Copilot, Cloud Computing (Azure), MS Power Platform, SQL Server, iOS, Android, and Microsoft technologies. - Prior experience in developing cross-platform applicat...

I have a rough idea of a logo (see attached) but I'd like to make a few changes: 1) The trees on the left and right should be fully green (not just part of them). 2) The sky above should be blue (but the white clouds can stay). 3) The background houses (behind the front house) should have full walls ...some other color (not the weird green dot in the middle). 5) The random dots around the edges should go away. 6) The "OMT" on the bottom should have a solid color behind the whole thing (no gap between "M" and "T") 7) The background should be black. Beyond that, feel free to try some other tweaks as well if you'd like! OMT is marketing for local customers in their neighborhood (thus the house/tree imagery), so we want it to be a mix of p...

I'm looking for a professional with a deep understanding of SQL injection to help me identify vulnerabilities in a MySQL database. If you're experienced in this area, I'd be glad to work with you. Key Expectations: - Identify vulnerabilities: Your primary task will be to thoroughly test the database for potential vulnerabilities, considering various injection techniques. - No access: Since I don't have any access to this database, I'm looking for someone who can perform this task remotely. You'll be expected to provide a detailed report on the vulnerabilities identified, so I can address them with my database administrator. - Change database values: Additionally, I'd like you to demonstrate the ability to change database values, as a proof of con...

I'm looking for a talented artist who can create a 48" x 48" realistic art collage of a hungry child made entirely of old Venezuelan Bolivars. The child must be the focal point of the piece, positioned front and center. Key Requirements: - Preferably a Realistic Art Style: The artist should be able to create a piece that realistically portrays the child through the use of Venezuelan currency. - Experience with Collage Art: Experience in creating collage art, particularly with unique materials, is highly preferred. - Attention to Detail: The ability to work with small pieces of currency and bring out the realistic features of the child.

...skilled software developer to create a comprehensive Schools Management System for IOS, Android, and the Web. The system will streamline school administrative processes, improving efficiency and productivity. Key Features: 1. Attendance Tracking: Provide a quick and efficient way to monitor and record student attendance. 2. Gradebook Management: Capable of managing and updating student grades. 3. Parent-Teacher Communication: A communication platform for parents and teachers. 4. Staff, Activities and Approval Management: Tools for managing school staff, activities, and approval processes. 5. Registration System: An efficient system for student registration. UI Design: The user interface should be colorful and interactive, aiming to provide a pleasant user experience while ensu...

As someone requiring a Linux Server Administrator with AWS expertise, I require specific support with server maintenance and updates - specifically involving an Apache environment. Your role will entail ensuring optimal performance and uptime. A diverse skill set including the following is vital: - Proficiency in Linux server administration, particularly within an Apache environment - Knowledge on server maintenance and updates - Capability to handle AWS resources management and environment We are looking for a Linux server administrator with expertise in AWS to manage our server infrastructure. The responsibilities include ensuring the smooth operation of the servers and addressing any issues that may arise within our custom-built system. We wi...

...Python 3.10 for subsequent steps. 3. The top of the directory contains and requirements.txt. Run the following command to first install all dependencies from there: pip install -r 4. Run python main.py. If everything goes well, you will see the following output: This means your indexes were successfully created. 5. Navigate to s2/intermediate/ folder where the indexes are stored. s2/intermediate/ is the inverted index file. This postings can be read in memory and used to construct vector representations. 3 What functions should I implement? You will find an incomplete function named rank and evaluate() already defined in main.py. It is called from the main function. Complete this function to implement ranking of documents using vector based models and their

This error has been traced back to the Apache webserver, it is a PHP and WordPress error "Please check that the mysqli PHP extension is installed and enabled." Key tasks for this project include: - Identifying the root cause of the 'Internal Server Error' message - Resolving the issue promptly to restore the website's functionality Ideal Skills and Experience: - Proficiency in PHP and Apache webserver - Strong experience in debugging and resolving 'Internal Server Error' issues - Excellent problem-solving and communication skills

Hello! We're in search of a logo for our organic olive oil company, 'Azeite da Torre.' We're looking for a design featuring a beautiful olive tree that reflects our brand's luxury and organic nature. Attached are some olive tree examples for inspiration. Good luck to all participants, and thank you for your submissions!

I need someone proficient in garden maintenance, with particular emphasis in weed removal, tree trimming, mulch laying and rock cleaning. My flower beds are small. You must be comfortable dealing with insects, specifically bees, ants and cicadas. Key skills and experience would include: - Expertise in weed removal and tree trimming - Proficient in laying mulch and cleaning rocks - Exceptional understanding of yard work safety standards involving insects - Previous experience with medium-sized yards is a plus. - Most importantly, must not be bothered by the presence of bugs and insects, especially bees, ants, and cicadas.

I'm in need of a skilled FlutterFlow developer to create a web application that can generate PDF reports from documents stored in Firestore. Key Requirements: - Platform: FlutterFlow inside an already existing app. - PDF Customization: The reports need to have a moderate level of customization with specific layouts. - Generation Frequency: The reports should be generated within the app on-demand by the user. Skills and Experience: - Proficiency in integrating Firestore as a database for document retrieval. - Prior experience in creating PDF generators from specific document layouts. - Understanding of user-triggered, on-demand report generation. - Knowledge of building Custom Functions or Actions within FlutterFlow. - Ability to advise on the best implementation strategies ...

Google big query - for writing sql queries for the complex data

...the AI pair programming LLM. The primary functionality of this application will be to assist users in coding with intelligent code suggestions, aiming at an advanced Python level. Key Responsibilities: - Developing the application using Python, C++, SQL, and React. - Concentrating on providing intelligent code suggestions as a core feature. - Ensuring the application's capability to handle advanced level Python coding. - Create proper documentation of the code and features introduced. Ideal Skills and Experience: - Proficiency in Python, C++, SQL, and React. - Previous experience in developing intelligent coding or suggestion systems. - Deep understanding of machine learning concepts and their applications. - Familiarity with application development for coding assis...

Need to configure the Function on an Video call to configure and define the below function for resizing images. I am in need of a functional AWS Lambda function, proficiently...exclusively in Node.js. The successful applicant should have good experience with Node.js and AWS Lambda functions. - Image Resizing: The function needs to resize images on the fly, meaning it should dynamically generate resized images based on incoming requests. Experience with dynamic image processing will be of great advantage. - Image Source: The original higher-resolution images will be stored in Amazon S3, so knowledge of Amazon S3 is a must for the function integration. In summary, if you are skilled in Node.js, AWS Lambda, and Amazon S3, this project is for you. I'm looking forward to seeing ...

I'm currently experiencing several issues that strongly suggest a malware issue on my apache server. My website's performance has seriously declined, and much to my disturbance, Google has flagged my site as dangerous. I haven't taken any steps yet to resolve these issues so now I'm seeking professional help. To be successful in this project, you will need: - Expert knowledge of Apache servers - Strong experience in malware removal techniques - Excellent understanding of domain whitelisting - Safety assurance to recover my domain status on Google I'm looking forward to making my website perform faster and being flagged safe on Google and other antivirus platforms.

...the family business when I was 14 years old. It was a fairly happy home but my parents argued a lot. They ended up getting divorced when I was 14. Joe then reconnected with Donna and finally married his high school sweetheart. She had three kids of her own and their father left when they were little kids. Donna raised them on her own. Joe helped Donna go after her kids father for 19 years of back child support. In 2004 my father spoke at a few local events and interviews about what swift boat detail was really like for the Kerry campaign when he ran for president. He was friends with many of the "swift boat sailors for truth" members who got a very large fine for lying in 2004. He never spoke to them again for what they said about John Kerry. Around 2000 my father and s...

...shared hosting server, which currently manages to support up to 100,000 concurrent users. As my requirement increases, there's a need to further improve its ability to handle more. My server largely deals with devices on the ground, transmitting continuous data back to the server, and the sheer volume of synced devices can lead to server strain. I require a professional who has: - Expertise in server management and optimization - Proven experience with scaling shared hosting servers - Knowledge related to server load balancing - Proficiency in data flow optimization Your task would include the analysis of the current setup, troubleshooting potential bottlenecks, and implementing successful changes to increase concurrent users. Please hav...

Hi Ganesh D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...programmer to build a web scrapping tool that can effectively scrape specific data across 1000's of web pages. The specific websites for this web scrapping operation will be college and university athletic pages. Therefore, among the required skills is the versatility to adapt to different websites' structures and frameworks. In terms of data structure, the scraped data should be organized and stored in a Google Sheets according to categories. This approach allows for a more coherent and systematic pattern for data analysis and representation. The ideal professional for this task should possess: - Proficiency in web scrapping - Expertise in Python or other relevant programming language - Experience with Google Sheets and database creation - High attention to detail...

I need an expert with in-depth experience in ZFS pool management on a Linux operating system. The data lost from the corrupted pool wasn't critical to our operations, but we primarily stored databases, and the loss was still a hassle. Your main responsibilities would be to: - Investigate the root cause of the pool corruption and provide a detailed report on your findings. - Suggest and potentially implement steps to prevent such incidents from happening again. Ideal skills and qualifications: - Extensive experience with ZFS and Linux systems. - A history of troubleshooting and resolving data corruption issues. - Prior experience with database storage and recovery. - Strong problem-solving capabilities. - Excellent communication skills to explain complex technical concepts in...

I'm in need of a talented, creative writer to draft a science fiction story for a radio production. The story should be centered around a child who discovers a new planet in outer space. Key Requirements: - Genre: Science fiction - Setting: Space - Plot: Focused on the main character's journey to discovering a new planet Skills and Experience: - Proven experience in writing engaging stories, particularly in the science fiction genre - Ability to create a captivating plot with a strong narrative arc - Familiarity with radio scriptwriting is a plus, but not mandatory This project is ideal for a creative writer who can combine imaginative world-building with a compelling storyline.

I'm in need of a freelance Node.JS expert to help me with my Node.JS server setup. - Ideal candidate should have extensive experience in setting up and configuring Node.JS servers. - Knowledge of web and mobile application architecture is a plus. - Preference will be given to those with previous experience in API backend development.