Sql list tables leebooks 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

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 ;)

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

...waiting list for me. The key purpose of this list is to manage customer demand. Key Requirements: - Prefer customers to join the waiting list via a website form. The form should be intuitive and easy to use. - When customers join the waiting list, I would like to collect their Name, Email address, and Phone number. I am looking for a skilled developer who can create a seamless and easy-to-use waiting list. The ideal candidate should have experience in: - Web development with proficiency in building forms - Understanding of customer data collection and management - Prior experience in creating waiting lists is a plus Please provide examples of similar projects you have worked on in the past. Thank you. As well as the above I am starting a new com...

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

...equipo colaborativo, español nativo. b - JAVA2EE con experiencia superior a 2 años c- Conocimientos en programación Java Swing d- Experiencia en programación previa demostrable de al menos 1 año en programas de gestión tipo ERP, SGA, POS, CRM, facturación, contabilidad, etc. e- Entorno de trabajo sobre GITHUB, JIRA, ECLIPSE f- Conocimientos de programación SQL sólidos 2.- CERTIFICACIÓN PREVIA DE LOS PERFILES. a. Es para colaborar en un producto ya en explotación y distribuido en miles de instalaciones, por lo que la calidad y certificación previa son totalmente obligatorios. b. Por ese mismo motivo buscamos colaboradores permanentes y a mu...

I'm looking for a skilled professional to format my lengthy book for publication as a paperback on Amazon. - Total word count: 58,000 words - Formatting requirements: I need someone who is familiar with the pdf layout requirement for publishing a paperback book on Amazon. - Book content: Text only, no images or tables The ideal freelancer for this job should have experience in book formatting, particularly for Amazon's print-on-demand service. Your role will be to take my manuscript and format it appropriately for print publication, ensuring it meets Amazon's requirements for paperback books. It's important that the layout is clean and professional, with appropriate page breaks and chapter headings.

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.

I need a freelancer to revamp the tables and figures in my Word document. The current visuals need a professional overhaul, without losing the data integrity. Key project details are: - **Recreation Scope:** I prefer the tables and figures to be redesigned with a corporate and professional theme. The goal is to enhance the visual appeal while maintaining the substance and clarity of the data. - **Technical Expertise:** The ideal candidate should be well-versed with Word functions and capable of creating visually appealing yet professional graphics. - **Communication:** Clear communication is key. I expect regular updates and the opportunity to provide feedback throughout the revision process. Ideal skills for the job include proficiency with Microsoft Word and a strong un...

...continuously improve our data solutions Key Skills :- • Bachelor's degree in Computer Science, Information Technology, or related field. • 4-5 years of professional experience as a Data Engineer with a focus on Azure Databricks and Azure Data Factory. • Strong proficiency in SQL, Python, and/or Scala for data manipulation and scripting tasks. • Experience working with data lakes, data warehouses, and ETL processes. • Familiarity with cloud platforms (preferably Azure) and related services such as Azure Blob Storage, Azure SQL Database, etc. • Excellent problem-solving skills and attention to detail. • Effective communication and collaboration skills to work with cross-functional teams. • Azure certifications (e.g., Microsoft ...

need seo experts/developer to fix google search console/SQL index issue. we have many pages not indexed on gsc, need seo experts/developer to fix it. I'm currently facing an issue with pages on my website not being indexed and therefore not showing in Google's SEO results. It's crucial for the successful completion of this project to have these pages visible on Google again. Ideal candidates for this task should have: * Extensive experience with Google Search Console * Proven expertise in resolving indexing issues * A deep understanding of SEO best practices Please include your past work related to resolving such issues in your application. A detailed project proposal would certainly be a plus. Prompt completion is advantageous, although a precise timeline has...

I'm in need of an experienced finance expert who can help me calculate financial ratios for Nestle over a period of 3 yea...over a period of 3 years. These figures will be vital in evaluating the financial health and performance of the company. Key Project Requirements: - Calculating profitability, liquidity, and solvency ratios for Nestle for 3 years - Presenting the calculated ratios in tables - No need for a comparative analysis with other companies, just Nestle Ideal Skills and Experience: - Proven experience in finance and accounting - Deep understanding of financial ratios - Experience in presenting financial data in clear and organized tables I'm looking forward to working with a professional who can provide accurate and reliable financial analysis. I will...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

I have a 11-50 page PDF document that I need converted to a Word file. The primary purpose of this conversion is to enable me to edit the content, while also retaining the existing formatting. Key Points: - The PDF file is relatively straightforward with basic text and minimal formatting, no tables, lists or images. - The ideal candidate should be proficient in typing and familiar with the basics of formatting in Word. - As the document is a bit lengthy, attention to detail and accuracy are crucial. I'm looking for a freelancer who can deliver a clean, editable Word document that mirrors the original PDF. Please include relevant experience in your proposal. Thank you.

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

...seeking a highly skilled data engineer with a strong proficiency in Apache Kafka to work on a data integration project. The main objectives of this project are: - Integrate various data sources: structured (SQL database), semi-structured (XML, JSON), and unstructured (emails, documents) - Develop a robust data flow architecture - Ensure efficient data transmission across systems The perfect freelancer for this job should possess the following characteristics: - In-depth knowledge and practical expertise with Apache Kafka - Experience with integrating diverse data sources, such as SQL databases, XML, JSON and unstructured data (emails, documents) - Proven track record of successful data integration projects Feel free to schedule a meeting using this link.

I'm in need of a website and custom...(Django/Flask), Ruby (Ruby on Rails), or PHP (Laravel).  Database: MySQL, PostgreSQL, MongoDB, or similar.  Web server: Apache, Nginx, or equivalent. 3. Payment Gateway Integration:  Select and integrate with a payment gateway provider that meets the project requirements (e.g., Stripe, PayPal). 4. Security Measures:  Implement secure coding practices to prevent common vulnerabilities (e.g., SQL injection, XSS).  Use encryption for sensitive data storage and transmission. 5. Hosting and Deployment:  Leverage existing hosting provider of the platform supports the required technologies; otherwise recommend an alternative platform.  Set up automated deployment pipelines for continuous integration and delivery (CI/CD).

I have a 11-50 page PDF document that I need converted to a Word file. The primary purpose of this conversion is to enable me to edit the content, while also retaining the existing formatting. Key Points: - The PDF file is relatively straightforward with basic text and minimal formatting, no tables, lists or images. - The ideal candidate should be proficient in typing and familiar with the basics of formatting in Word. - As the document is a bit lengthy, attention to detail and accuracy are crucial. I'm looking for a freelancer who can deliver a clean, editable Word document that mirrors the original PDF. Please include relevant experience in your proposal. Thank you.

I have C# MVC Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Error message appear with no details, need to make the error message has Show More to display the details of the error. 2- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 3- Packages Load from APIs instead of loading from DB (2 APIs) 4- SubscribedPackages Call API instead of inserting into a DB (1 API) 5- Schemes Load from APIs instead of loading from DB (1 API) 6- Uploads Call API instead of inserting into a DB (1 API) 7- Users Call API instead of inserting and reading from a DB (5 APIs) you must have C# MVC experience. ------------------...

I am urgently in need of experienced professionals who can help me fix a crucial database issue with my website built on Node.js. There are certain missing tables that cause the application to crash whenever specific buttons are clicked on the site. Key Details: • The crashing issue is experienced when the Login button, Submit form button, or the Add to cart button is clicked. • Due to these unsolved errors, the terminal indicates that a certain table name is not found. Ideal Skills and Experience: • Solid background in solving database issues in Node.js platforms. • Experience in working with missing tables and rectifying database errors. Application Requirements: Freelancers interested in this project should include detailed descriptions of their p...

I am seeking a detail-oriented freelancer with demonstrable experience in data collection to gather texts, images, numbers, and tables from a particular website. My instructions, which will include 1 to 5 photographs, will guide you in precisely what data I need to be gathered. The freelancer will be expected to: * Carefully collect the specified data from the website * Ensure all text, images, numbers, and table-based data are meticulously compiled * Consolidate all the collected data into a neat Excel spreadsheet Your experience in data collection should be highlighted in your application. Experience in using Excel for data organization will be a key advantage.

...users. This project is centered around social media analysis and trend prediction. Key Points: - You will only be required to generate a list of followed accounts' IDs for each user that is provided - The data you collect will be used to predict trends in user behavior and preferences Ideal Skills and Experience: - Proficiency in data scraping, particularly from social media platforms - Familiarity with Instagram's API and limitations Further notes - I am very familiar with scraping in general myself. There are many obstacles with Instagram - namely, the endpoint where the 'following' list is found requires a logged in sessionid. I have a very large list of users (11 million overall) that I need this data found for. Honestly, I'd prefer ...

...Existing Environments. Maintain Documentation For System Processes And Procedures. Participate In Code Reviews, Contribute To Team Knowledge, And Mentor Junior Developers. Required Skills: Strong Proficiency In Perl Scripting And Python Programming. Experience With XML Technologies, Including XML Parsing And XSLT Transformations. Good Understanding Of Relational Database Management Systems And SQL. Excellent Problem-Solving Skills And Ability To Think Analytically. Strong Communication And Interpersonal Skills, With An Ability To Communicate Complex Concepts To Non-Technical Stakeholders. Additional Qualifications: Experience With Web Technologies (HTML, CSS, JavaScript) Is A Plus. Familiarity With Software Development Methodologies Such As Agile/Scrum. Perks And Benefits:...

I'm in need of a skilled freelancer to set up and install Primavera P6 EPPM 21.12 locally on Windows. This is a single user setup, with SQL database configuration included. Key Tasks: - Install Primavera P6 EPPM 21.12 on a Windows system - Complete and configure the SQL database for the software Ideal Freelancer: - Experienced with Primavera P6 EPPM installations - Proficient in SQL database setup and configuration - Understands the intricacies of Windows OS - Prompt and clear in communication

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

...address and make a payment. Rating page. Users will be prompted to login before accessing this. Star ratings will be filled in here, and the welcome text will have each users [first_name]. Generate a custom QR code to a rating page with pre-filled order number (unique identifier from above) Order confirmation email. With animated banner and QR code. SQL database. All data from the users, questionnaires, orders, and ratings will be stored in a postgres SQL. I have specified the database design (see below). Currently there is no API to warehouse/shipping (postage of orders are handled manually, but please set up the database with the future API integrations in mind). Manual order (in backend). Basically, I want to be able to look at the sample ratings for each sample order a...

I'm looking for an experienced developer to create a versatile iOS note-taking app. The primary goal of the app is to provide a comprehensive platform for text formatting, creating, saving, and printing notes. Your main tasks will include: - Implementing essential text formatting features like bold, italic, and underline. - Enabling users to insert various elements such as images, tables, graphs, and backgrounds. - Customizing fonts and other text styles. - Providing options for saving notes in various formats like pdf, txt, rtf, and doc. - Incorporating a seamless printing functionality. To be successful in this project, you should have a strong background in iOS app development, particularly in the context of note-taking and text formatting. Proficiency in tools like Flutte...

...skilled and experienced content writer to pen an engaging, informative piece on modular conference tables. This article is intended to educate a diverse audience that includes office managers, interior designers, and furniture retailers about the benefits of opting for modular conference tables. 800-1200 words within 4 days. Key Focus Areas: - Flexibility of Modular Conference Tables: Delve into how their customizable and adaptable design can cater to varying needs and changing office landscapes. - Variety in Design and Style: Explore the vast array of designs, styles, and aesthetic appeal these tables provide, uplifting the environment they are placed in. - Describe why modular conference tables are suited for a wide variety of meeting spaces. Idea...

...like the app to have, but don’t have the skill to incorporate them: - searching (CoreData represented in tables and lists) - filtering and sorting SwiftUI tables - generating pdf forms via a wizard or questionnaire that will ask the user for answers to specific questions for the form (e.g., placeholders in a form template: name, date, etc.) and an ability to share these generated pdfs from the share sheet - batch adding a set of reminders to a specific reminder list using EventKit (and being able to edit this list of reminders from a settings page in the app where multiple reminders can be listed for adding with one tap on the reminders view) - generating pdfs of some of the views (tables and lists) and being able to share them from the share she...

I'm in need of a skilled .NET developer to create...additional integrations may be required in the future. Experience with integrating external systems and APIs would be beneficial. - User Roles and Permissions: The application may need to support multiple user roles and permissions. While this is currently marked as 'unsure', the ability to handle this efficiently would be a plus. Ideal Skills: - Proficiency in .NET development - Strong knowledge of SQL databases and data management - Experience in user authentication and registration systems - Previous work involving user role and permission management - Flexible to adapt and integrate external systems when required If you're a skilled .NET developer with a track record of creating user-centric web applicatio...

I'm in need of an experienced developer to bring my SQL codes with the triggers to life with a well-designed Apex Oracle application. The app is expected to have the following features: - Implementing data entry forms that are intuitive and user-friendly. - Developing robust data analysis reports that provide valuable insights in an easy-to-understand format. - Setting up a comprehensive user authentication and security system. - Creating a visual design that aligns with my company's corporate branding while also being colorful and vibrant. - Ensuring the application is responsive and works seamlessly on both desktop and mobile devices. - Implementing an efficient navigation and information architecture to enhance user experience. The ideal candidate for this project sho...

I'm in need of a skilled web developer highly experienced in both Angular and Javascript. The primary objective for this project is to create a website with a responsive design that aligns with my provided brand guidelines. Key Qualifications: - Proficient in Angular and Javascript - Extensive experience in responsive design - Extensive experience in .Net Core and SQL Responsibilities: - Adhere to design and branding guidelines during web development - Create a website that is user-friendly on all devices. Please ensure to provide examples of past work with responsive web design during your application.

...applications, with the aim to identify and eradicate any potential vulnerabilities. Key Tasks: - Perform Open Source Intelligence (OSINT) - Port scanning - Man-in-the-middle (MiTM) attack simulation - Focus intensively on injection attacks (SQL, XSS) - Authentication and session management puncturing - Cross-Site Scripting (XSS) evaluation The ideal freelancer will have: - Strong experience in cybersecurity and penetration testing - Excellent knowledge and experience with Linux-based systems - Proven experience in web application security testing - Firm understanding of SQL, XSS and authentication vulnerabilities Your final deliverable will be a complete penetration testing report, detailing vulnerabilities found, their potential impact, and recommended remediation step...

I'm in need of an experienced Python developer to assist with the development of critical web security tools. While specific tools aren't outlined below - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing

Hello - I need to put one of the tables you did into an A2 poster please - but make it a bit more marketing rather than formal looking

SAPUI5 Expert Required on an ad-hoc basis Must have the following skillset -Binding Complex Structures -List Report creation -OData Service Expert -ABAP and BAPI understanding and knowlegde -SAP Plant Maintenance Module SAP PM SAP ABAP DPC Class and retrieving data from PM PM Transactions, Work Orders and Notifications and knowlege of tables SAP Gateway Services SAPUI5 SAP Fiori Elements MVC Framework Bootstrapping SEGW Project Working arrangement: Via Teamviewer/Teams ONLY English Communication Ad Hoc , Remote Position Must be available in SAST (GMT+2) Timezone

I'm looking for a JavaScript developer with experience in ARIS-based scripting. The script I have needs to be modified and expanded like so: - Addition of custom functionality - There are certain tasks this script must perform which it currently doesn't. - Enriching the user interface change color codes, add more tables etc. list of 8-10 changes needs to be done. I need more tables incorporated into the script that pull additional information. Ideally, you'll have a demonstrable knowledge of ARIS-based JavaScript and a strong understanding of UI development. Accomplished script performance is a must.

I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate to ask if you have any queries. Thank you!

I require a capable DTP for an extensive task: converting over 1000 pages from PDF format into Word while ensuring to maintain the existing table structure, preserve all possible formatting including colors, font styles and also include headers and footers. The tables to be converted are of a basic complexity level, mainly comprising of simple rows columns. Ideal candidate should have good knowledge of DTP, proficiency in data conversion with a keen eye for detail to maintain the accuracy of data and its presentation.

I'm looking for an experienced cafe interior designer to create trendy and modern designs for my cafe. Ideally, the atmosphere should be both stylish and inviting, erring on the side of warm tones (especially reds, oranges, and yellows). The seating arrangement should focus on regular tables and chairs, providing a comfortable space for customers. Experience with similar projects would be highly advantageous.

I am looking for an expert in data extraction, particularly from multi-page PDFs containing various elements, including text, tables, and images. This is a step one for us in developing a new AI_first documents management system. The scope of this project requires the accurate extraction of clean, structured data for systematic storage. Key Skills and Experience: - Proficient in data extraction and structuring from unstructured PDF files - Detailed-oriented with a focus on accuracy and consistency Project Details: - Pull data from several multi-page PDFs - Skillfully handle different types of data including text, tables, and images - Extract clean and structured data. - Systematize the stored data for easy future access The project is completed once we receive the ...