Select statement in pl sql block 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.
hii! sir aisa bhi gussa muje block he krdeya call bhi pick nhi krte
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). --------------...
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
Moi! Mulla olis reilu 585 sananen suomeks kirjoitettu personal statement yliopistohakua varten mutta mä en millään kerkee sitä kääntää englanniks nyt kun on yo-kirjotukset tulossa kovaa vauhtia kuukauden päästä. Kiinnostaisko mokoma duuni ja paljon pulitat kyseisestä hommasta? :)
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
Hei, Haluaisitko kääntää työhakemukseni suomesta englantiin? Tarvitsen käännöksen opintotehtävääni varten, opsikelen yliopistossa ja sen takia teksti edellyttää tieteellisestä rakennetta. Deadline on jo perjantaina... Ystävällisin terveisin, Simon Rundlöf
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 looking for a cross-platform mobile app developer to create an app focused on daily reporting. Below are some key details to be aware of: - The ...should be well-protected. - Please provide examples of similar cross-platform apps that you have developed. - Experience with reporting functionalities and/or data security is a plus. Features of the Application will be, Name and class of app is daily Class reporting Software 2. Select the class you taught today from class 3 to class 12 3. Select the topic 4. Upload videos, and queries. 5. Mark it as done partly done or not done 6. Integrate it with calendar 7. Mark holidays 8. Integrate GPS location in it Please respond with details on your experience, how you would approach this project and any relevant p...
...Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Deliverables Order *Quiz ---------- Select service select size Select colours Select additional information Comments Attachments Submit Two way chat (communication...
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
...password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experience in integrating excel upload features in web applications. - Package management: Understanding of package assignment and management in an app. - Excellent understanding of securi...
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
...to recreate a complex web platform in JavaScript. This is expected to be a three to six month project, requiring a minimum of six full time developers. This platform will reside on the AWS network, preferably using MySql and Linux. We will be recreating a PHP/MySQL platform to a JavaScript/MySQL platform with approximately 200 features. This new platform will require a significant upgraded user experience, integration of animated graphics and faster reports processing. Our current platform has some components that are 10 to 20 years old. You will be creating from scratch and not using ANY of the current code. Key Developer Requirements: - Extensive experience in JavaScript platform development. - Access to skilled User Experience programmers - Knowledge in Google...
...correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01")) Shell ("D:khalid " & jpegfilename & " " & pdffilename) ' = True sheetxx(i).Select sheetxx(i).ChartObjects(1).Activate For Each objCht In fname1 & i & ".gif", "...
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
...driving, the driver's statement is captured, and based on that statement, part of the reason for the request is explained to the driver. ・Example: Memorizing the correlation between the driver's statement and part of the reason for the request. ・Example: If the driver's statement is similar to a recorded statement, a related explanation is presented to the driver. ・Example: Acquiring the cause of the request and downloading related information based on that cause. ・Example: This process is repeated until manual driving starts or until the switch to manual driving is indicated by the driver's statement. ・Example: Also has the capability to receive related information from a specific device, which is provided based on the drive...
I'm looking for a Shopify expert to create a site that accommodates multiple pricing factors in order to sell my products online, while also ensuring that the design is consistent with my existing brand assets. Key requirements and considerations for the project include: - **Multiple Pricing Handling**: You will need to create a mechanism that can adjust product pricing based on various inputs like length, cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current brand ass...
...-family, -restaurants, (please note, we do not expect these to be included into our logo unless it would be beneficial to the design). We dont expect the font shown in any of the pictures to be used. Key Requirements: - Create a logo that can be used for our business, that represents our Brand for signage and collateral etc. - Ensure this logo can be adapted across our various products through slight changes in colour and design, to accurately represent each product while maintaining the brand. An example might be having a different colour for each type of meat - bring us your ideas!!! - Design a logo that is classic and timeless in style, reflecting the traditional and valued nature of our brand. - The logo should be versatile, able to be used across a variety of...
I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offe...
...construct a simple, one-page website for my restobar. Key features should include: - A rustic and minimalistic design that's eye-catching and easy to navigate - Integrations with Google Maps for location and social media, specifically Instagram, with recent IG posts visible on the site - The inclusion of key elements like a few select high-resolution photos, our menu, and contact information The ideal freelancer for this project should have a wealth of experience in website design and should be familiar with integrating various platforms into a site. I need a detailed project proposal that outlines your suggested approach to the job. Familiarity with the restaurant or hospitality industry might be an advantage, but it isn’t a requirement. I'm looking forw...
...of Bible, sections of the Bible i.e. Pentateuch / History Books / Writings / Prophets / Old Testament / New Testament. The user doesn't have to choose these each time, just the first time, to be saved in browser. If they want to modify it in the subsequent questionnaires they take, they are able to do so as an option. 2. Then there is a simple 10 question questionnaire. All using API logic. For each question, a random (use a true randomiser) verse is selected using the API within the sections of the Bible selected. A. The user is given the possibilities of the books for selection (as in select which book the verse is from). IF the user selects the correct book where the verse came from, THEN, the user is given the possibilities of the all chapters of ...
I have a React website utilizing Tailwind CSS with Stripe integration. TASK 1: I'm using the following imports from @stripe/react-stripe-js for the input fields:import { CardNumberElement, CardExpiryElement, CardCvcElement, useStripe, useElements } from '@stripe/react-s...1: I'm using the following imports from @stripe/react-stripe-js for the input fields:import { CardNumberElement, CardExpiryElement, CardCvcElement, useStripe, useElements } from '@stripe/react-stripe-js'; Attached are two images: the first shows the current design, and the second illustrates the new design that I want to implement. TASK 2: will be to save credit cards on stripe, so user can select which card they want to use: like this :
I'm seeking a skilled and versatile bookkeeper to manage my accounts in QuickBooks. Key Responsibilities Include: - Daily entry of transactions - Financial statement preparation - Tax planning and filing Ideal Qualifications: - Proficiency in QuickBooks - Experience in managing both accounts payable and receivable - Strong understanding of tax planning - Excellent attention to detail - Previous experience working with a diverse range of transactions I value clear communication and a proactive approach to managing my finances. The role may be expanded in the future if the right candidate demonstrates a keen eye for financial strategy.
...before. I am sure there are some things missing here but feel free to add your input. I do think this should give you a somewhat decent idea. Affiliates can sign up from CF Website or by invitation. (email) Affiliates have portal they can see activity Post Training Materials Marketing Materials Post messages to “group.” CF has ability to send group emails to all affiliates CF has ability to Block/Remove Affiliates Links they use for sales generation tracks which Plan Package their client signed up for. Affiliate receives a commish based on: Sale with Demo but no Training provided by Affiliate Sale with Demo and no Training No Demo, No Training Lead only Ability to create Sales reports for each Affiliate so that CF can issue Commish checks We may
...3500 stocks 9 min => 350 stocks. Maybe we could do multiple queries of 350 stocks? Because what is in place stops after 1800 files out of 7000. And obviously it starts again each time at the beginning when we restart... so it is always the same stocks which are updated. It would be better if the already downloaded data was not deleted, but kept and downloaded only the missing delta. This would allow us to have large data If we downloaded 1 year of data 7 days ago and we select 1 year, then only the last 7 days are downloaded, which goes faster. The data is then aggregated and deduplicated if necessary. 2) In the "indicator" section, be able to add, modify, delete existing indicators. 3) In "Add an indicator" (to be moved to the "...
I'm looking for a freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. Key Details: - Final Format: The final invoice should be in PDF format. - Summary: I'd like the invoice to include a summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context and importanc...
...and Experience: - Proven experience in graphic design, preferably for real estate - Strong portfolio of designs - Creativity and innovative ideas - Exceptional attention to detail -Familiarity with creating designs that generate leads and convey trust. Let's create a postcard that grabs attention and conveys our strong reputation in the market. We are looking for a postcard design for our home-buying business. I'm attaching several examples of our past postcards and several examples of current cards being used in our industry. The card needs to be clean, simple, and to the point... with an overall message of the following: Sell your house fast with no fees or repairs. We want to lean into the fact that we're local and have bought hundreds of ho...
...nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are,...
I am seeking a vibrant, innovative brand strategist for a budding brand. The ideal candidate will understand how to speak to professionals in the 25-40 range successfully, recognizing their needs, tastes, and aspirations. Tasks: - Development of a brand strategy from scratch encompassing all key factors: the vision, mission, personality and the positioning statement. - In-depth competitive analysis to understand stand-out strategies in the current market. - Collaborative creation of a novel, targeted marketing plan. The suitable candidate should have: - Able track record of successful brand creation from zero. - Proficient understanding of marketing towards a professional demographic. - Sound knowledge of competitive analysis techniques.
...management, budget tracking, and document sharing. The primary function of this software will be to drive project efficiency by keeping all project details organized, deliver real-time budget oversight, and facilitate instant file exchanges. This tool is intended for use by my project managers and office administrators. Consequently, the ideal freelancer for this task should possess a strong proficiency in cloud-based software development, particularly those intended for construction project management. Your experience should also extend to designing user-friendly interfaces that cater to the needs of project management and administrative professionals. Web Application A cloud-based platform designed to streamline project management, financial tracking, and employee/subcontracto...
...for Jira Cloud. The script should modify the behavior of a select field within the platform. Key Features: - Dynamic Select Field: The select field should dynamically change based on the values chosen by other issues in the project. This means that as the field is selected, it should update to exclude values already in use by other issues. - Hide Values Already In Use: The script should ensure that the select field does not present options that have already been selected by other issues in the project. - Customize Form Behavior: The script should also allow for custom form behavior in Jira Cloud. This project requires a developer with experience in Jira Cloud and strong skills in Groovy, the required program...
I'm currently in need of a talented fiction writer who can craft captivating stories within the fantasy genre. Key Details: - Your primary task will be to develop a compelling narrative that keeps readers engaged and eager to follow the storyline. - While the narrative perspective is not predefined, I expect you to select a suitable viewpoint that aligns with the story's requirements. Ideal Candidate: - A passionate and experienced writer with a knack for immersive storytelling. - Prior experience in writing within the fantasy genre will be a significant plus. - Ability to adapt to different narrative perspectives and showcase versatility in your writing style.
...delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a must. Ideal Skills and Ex...
I'm working on a project using Ignition 8.1.31 and need a feature implemented. The goal is to have a dropdown list in the perspective view that allows the user to select files from a specified directory. Key Points: - The dropdown should be populated with the file names upon the user clicking a perspective View button. - The Load button should be located on the perspective view. The ideal freelancer for this job should have experience with Ignition 8.1.31 and familiarity with creating dropdown lists that are dynamically populated based on user interactions.
Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black peo...
a) investment cost analysis ) b) p&l c) Revenue analysis and d) Analysis of operating expenses
1) investment cost analysis (fixed) b) p&l c) Revenue analysis (3 years minimum) d) Analysis of operating expenses
...professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and noti...
To woRk collectivialey to create with leadership an engaged and positive work enviroment lour peers innovation | research understand stewards budget communcatioN scheduling & planning Provide a positive an work experienflanning. events, acuare Uncationg, tenteR recognition a astargning opportunity,
I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this proje...
...patients and staff. Key Features: - Online Payment: The system should support online payment through Stripe. This will allow patients to pay for their appointments in advance. - Swedish Payment Provider: Integration with the Swedish payment provider Swish is important, as many of our customers prefer to pay using this method. - Video Conferencing: The system should enable the setup of online meetings. These meetings should be conducted via video conferencing. This feature will be useful for remote consultations and follow-ups. - Calendar Booking: The system should have a calendar booking feature, which allows patients to select their preferred date and time for an appointment. Information Collection: - Patient Information: The booking process should collect the patient&#...
Google Search Ads Cold Traffic Analysis - Select best countries and why - budget requiremetns - KPIs to follow
