Dynamic query in sql server with example 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 ;)
... setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm looking for a skilled De...
I need a skilled graphic designer to create an innovative, catchy mobile mechanic logo. Key requirements: - Predominant colors should be blue and black - Logo must include the symbols of a wrench, car, tire, gear, or piston - Aesthetic theme of the design should be modern Ideal candidate sh...requirements: - Predominant colors should be blue and black - Logo must include the symbols of a wrench, car, tire, gear, or piston - Aesthetic theme of the design should be modern Ideal candidate should have: - Strong graphic design skills - An ability to mirror my visions into the design - Excellent eye for color coordination - Past experiences in logo design would be advantageous. Ultimately, I'm aiming for a logo that encapsulates the dynamic, cutting-edge nature of my mob...
I'm in urgent need of a server expert for troubleshooting my web server. The issue needs to be resolved URGENTLKY Key points: - Immediate need: The server issue is affecting our website's uptime, and I need a quick resolution to prevent further disruptions to our business. - Troubleshooting: The task primarily involves diagnosing the root cause of the issue with the web server and implementing a fix to restore its normal functionality. Ideal skills and experience: - Extensive experience in server troubleshooting, particularly with web servers. - Ability to work swiftly under pressure, delivering a solution within a tight time frame. - Strong communication skills for keeping me updated on the progress and the propose...
I'm in need of a versatile e-commerce website developer who can help me create a platform similar to alibaba.com. The website is intended to sell a variety of products including Electronics, Clothing, Home goods, and Websites. Key Requirements: - The website needs to enable the sale of ready-made products, with a specific focus on tailor-made website accounts. - I'm also seeking customization options for my products, specifically in terms of size dimensions, material choice, and 'Internet Browsing'. Skills and Experience: - Proven experience in developing multi-product e-commerce platforms. - Proficiency in creating platforms with dynamic product offerings and customizable options. - Strong understanding of consumer beh...
I need an experienced NextJs (ShadCn) + Prisma (Postgres) developer to build an E-commerce application within a week. Key Requirements: - I already have a DB sche...online test, generate links and take test using the application - The whole app will be less than 10 pages - The App will have a lot of funtionality like generating common test link, session specific test link, generating test scores/result, question bank support, dynamic questions... The ideal candidate should have: - Solid experience in NextJs, ShadCn, and Prisma. - Proven track record in E-commerce application development. - Ability to deliver high-quality work under tight deadlines. Please only apply if you are confident in your ability to meet these requirements and can deliver the proj...
...Your design will be pivotal in helping us commemorate this milestone in a special way, so we're looking for something truly special. Key requirements for the logo: - Design Style: I'm seeking a blend of urban flair and cleanliness. The logo should have a bold and eye-catching appeal, reflecting our group's dynamic spirit. - Branding: Options for branding could include the following words - B5, Bad Boys Skate Crew, Bad Boys, 5th Year Anniversary, BBSC - Color Scheme: The logo should primarily feature the colors black, white, and/or red. You can choose to combine these in various ways, keeping in mind the overall theme and style. All colors do not have to be included. - Symbolism: While the logo does not necessarily need to include roll...
...Money!!! Do you thrive in a fast-paced environment where your success is directly tied to your effort? Are you passionate about connecting businesses with the power of a stellar website? If so, we want YOU on our team! We're a High Converting Website Design Agency looking for a driven, commission-only sales superstar to join our ranks. In this role, you'll be responsible for: Prospecting and Cold Calling: You'll identify potential clients who need a website refresh or a brand new online presence. Be prepared to make a positive first impression and build rapport over the phone. Understanding Client Needs: You'll have a knack for uncovering a client's vision and translating that into actionable website goals. Selling Solutions: You'll ...
hello I am currently planning to start a startup. I am currently entering the IT field (fields such as Facebook and Instagram) and need a programmer to join me. The working hou...join me. The working hours per day will be more than 40 hours, and a small salary may be paid per month. I have very creative ideas and am ready to grow into a global company. If you join me, I will provide you with an additional salary increase and a higher position as the company grows (e.g. Data Manager/Marketing Manager, etc.) Anyone who can do any of the following is welcome. -programmer -translator -lawyer -Server maintenance -Marketing expert -Anyone else who can contribute to the growth of the company Anyone who has a lot of passion and is starting a journey with me for my co...
We are looking for a skilled construction estimator to provide accurate cost estimates for a 3 dwelling cons...accurate cost estimates for a 3 dwelling construction site. The estimator will be responsible for analyzing project plans, performing quantity take-offs, and calculating material, labor, and equipment costs. The ideal candidate should have a strong understanding of construction industry standards and be proficient in using estimating software. Attention to detail, strong analytical skills, and the ability to work independently are essential. This is a great opportunity to join a dynamic team and contribute to the success of a high-profile construction project. Skills required: - Construction estimating - Project planning - Quantity take-offs - Estimating software - ...
I'm in need of an expert who can set up Webmin on my Ubuntu server. The primary reason for this is to facilitate server management. Here's a bit more detail on the tasks: - Setup Webmin: The primary task here is installing and configuring Webmin. It should be set up properly and securely to ensure that the server can be effectively managed through the panel. - Additional Server Tasks: Other tasks might include firewall configuration and VPS setup. These tasks are important to ensure the server is secure and running properly. Ideal candidates for this role should have: - Proficiency in Ubuntu server setup - Experience with server panel software, specifically Webmin - Strong understanding of server secur...
...lead generation. • Contact Options: Replace the contact button with a simple white band featuring options to schedule a call or contact via WhatsApp. • SEO-Optimized Blogs: Develop engaging blog content focusing on relevant keywords and SEO best practices. • About Us Section: Revamp the About Us section to be concise, interactive, and visually appealing. • Live Chat Support: Integrate a live chat feature for real-time assistance and guidance to potential clients. • Enhanced Testimonial Page: Improve the testimonial page for credibility and social proof. • Scroll Bar Placement: Move the scroll bar to the top of the website for an immersive viewing experience. • Website Speed Optimization: Enhance website speed with a sleek load...
I need a plugin that includes Apple Pay, Google Pay, and Link payment methods. This plugin should offer a dynamic button to facilitate these transactions based on Stripe's documentation. Please view the documentation here: The app that uses the plugin should also be able to customize the 'statement description', which is a capability provided by the Stripe API (createPaymentIntent). The suitable person would have experience in creating Bubble plugins, and hopefully would be easy for the person to make a quick and simple payment integration.
Hey users, i already have my static portfolio written in html,css and javascript. I just wanted to make it as dynamic. I wanted to add all my content to be loaded from firebase backend. Link to portfolio : It is just a small project and in near future will also look for SEO For Portfolio Connect with me if you are interested
...lighting designer to create a dynamic and energetic lighting setup for a 5 piece cover band. Key requirements: - Create a lighting setup that energizes the audience - The design should include a minimum of 25 different clues that will create iambiance from intimate for softer songs to very energetic for upbeat songs. See songlist attached. - The design should include a playback button for each song which includes up to 10 cuelists for each section of a song. A document describing where the scene changes occur will be provided separately. - The lighting fixtures include 2 moving heads, 2 U`King Spider Moving Head Light, 2 SLI-FLATSET1, 2 Chauvet COLORSTRIP MINI DMX-512 LED RGB Light Bar, 2 chauvet slimpar64 and 2 Venue thinpar 38. - The design should be created with the a...
I'm in need of a videographer who is specialized in creating dynamic and attention-catching TikTok content, with a focus on life coaching and fitness. A successful applicant will have: 1. Experience in creating promotional content for TikTok. 2. Demonstrated understanding of fitness and life coaching concepts. 3. Ability to create engaging content that can promote life coaching services and fitness regimens. Responsibilities include: - Developing TikTok videos that illustrate life coaching tips and fitness advice. - Creating engaging content that includes exercise planning, goal setting, and nutrition guidance. - Delivering promotional videos that can effectively engage in and grow our audience on TikTok. An ideal candidate would be a sk...
I'm looking for a social media expert to create and manage a series of Instagram ads to ...driving product sales - Creating engaging and effective image, video, and story ads - Monitoring and analyzing campaign performance, and making data-driven adjustments to increase ROI Ideal Candidate: - Proven experience in managing successful Instagram ad campaigns - Strong understanding of social media advertising best practices - Ability to create high-quality and attention-grabbing image and video content - Proficiency in data analysis and campaign optimization - Excellent communication and collaboration skills This role offers the opportunity to work with a dynamic team and make a direct impact on our product sales. I'm looking for a freelancer who can hi...
Hello, I am currently looking for an experienced graphic designer to refresh my company's logo. It's a modern styled logo and I'd love to retain the current color scheme. However, the key to this update is that I want the refreshed version to be much more dynamic. Ideal skills and experience: - Proven graphic design experience - Strong creativity and design skills - Ability to understand and incorporate company color schemes - Good understanding and previous experience in branding - Experience in creating dynamic logo designs Looking forward to receiving your exciting proposals!
I require assistance in creating an Adobe fillable PDF form for my clients. This form will be used to collect data. - The PDF form will need to include both text fields for entering information and checkbox fields for multiple choices. - I also need a box around the bottom portion (last two questions) Freelancers must have experience in Adobe fillable forms and demonstrate an understanding of how to create dynamic and user-friendly forms.
I'm seeking an accomplished artist who can transform my website's homepage into an interactive user experience through incorporation of motion graphics. In this project, you will: - Design and implement motion graphics tailored specifically for the homepage of my website. - Leverage your creativity to generate a dynamic interface that captivates user attention and promotes interaction. Ideal candidate should have: - A wealth of experience in producing high-quality motion graphics. - An understanding of user interaction and their response to visual cues. - Previous experience in website design and enhancement. Let's transform and capture the eyes of all who land our homepage.
I'm in need of an experienced developer to create a comprehensive calendar with specific functionalities. It should assist professionals in keeping track of various events like meetings, deadlines, and appointments. Key Features: - Event Reminders: It's essential that the calendar includes an event reminder system to provide timely alerts. - Recurring Events: The ability to schedule recurring events is also pivotal. - Multi-Platform Sync: The calendar should seamlessly sync across web and desktop platforms, and there should also be an option to generate a physical copy. Ideal Skills: - Experience with building robust calendar applications - Expertise in cross-platform syncing - Proficiency in user-centric design. -Monthly overview -Mon...
Rare Opportunity for the Right Person with the Right Attitude. We are a nimble & brash independent direct-to-consumer US based company branching into exclusive & clever Democratic political swag for the next six months. And we are looking to partner with an entrepreneurial social media expert with a sharp mind and an even sharper wit, who can cut through the clutter with our merch. If you’ve got the creative social media chops, and can deliver, then your upside is UNLIMITED. This opportunity begins immediately! Contact us for all details!
...handle dynamic tasks in a bustling entertainment setting. I require someone with a knack for weaving engaging narratives while maintaining an informative tone that appeals to a general audience. Your Responsibilities: - Write compelling articles about various music and entertainment-related topics. - Conduct in-depth interviews with artists, industry professionals, and key players in the music scene. - Create fascinating documentaries that spotlight notable industry trends and events. Ideal Skills and Experience: - Strong written communication skills and a flair for storytelling. - Prior experience in music journalism or related fields. - Excellent research skills and a keen eye for industry trends. - Ability to engage a ...
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
I'm in need of a talented graphic designer who can create a modern and minimalist logo for my brand "Valentius Kryptix". The primary use of this logo will be for brand recognition, hence it needs to be unique, memorable and easily identifiable. It should represent my brand and its values in a sleek and contemporary way. It MUST include/highlight the letters V & K. Key Requirements: - Modern and minimalist design style - Ability to craft a sleek and unique logo - Understanding of brand recognition principles - All file formats including CDR file The logo will be used across multiple channels like my website, social media, business cards, flyers and even merchandise such as apparel and mugs. Therefore, the design should be versatile and able to maintain its...
exactly similar to this f-system
...will focus on service sales only, so expect to work closely with the target audience of hostels to close deals. Key Responsibilities: - Implementing a multi-faceted promotion strategy: I'm looking for someone who is well-versed in social media marketing, email marketing, and direct outreach. You will be using these methods to reach out to hostel owners and managers to promote my service. - Closing deals: You should be an excellent salesperson with exceptional communication and negotiation skills. The primary objective is to turn leads into sales, so the ability to close deals and meet sales targets is essential. Ideal Candidate: - Sales experience: Prior experience in a sales role is a must. Experience in the service industry or with hos...
I have a WordPress site where I'm facing some issues with taxonomies. Specifically, I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was add...
I’m looking for a proficient developer with deep knowledge of Android Studio and Google Firebase to design a dynamic app for me. The exact purpose of the app is yet to be determined, but rest assured, your responsibility will include implementing user login and data fetching features. Ideal Skills: - Expertise in Android Studio and Google Firebase. - Strong understanding of user authentication and data retrieval techniques. Running on a flexible timeline, I am keen to get started on the development as soon as feasible. However, missing data regarding the type of data to be fetched and the purpose of the app will be clarified as we move forward.
I need a male voiceover artist to deliver a friendly, engaging voiceover for my Discord server's rules. The script is less than 50 words long and simply outlines the server regulations. Freelancers with previous experience in voiceover work, particularly in a casual and friendly tone will be ideal for this task. Understanding the nuances of Discord would be a plus.
...+ Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Office skills to drive automation opportunities. • Well-versed with dynamic loops, data extraction from images. • Wo...
I need help migrating my Joomla-based website, which currently features a Currency Converter, to a new hosting server. Key Requirements: - Migrate the entire website (including the Currency Converter feature) from the existing server to a new one. - Ensure that the Currency Converter functionality remains intact and fully operational post-migration. Ideal Skills and Experience: - Proficiency in Joomla, PHP, and MySQL. - Prior experience with migrating websites, particularly those with dynamic features like Currency Converters, would be beneficial. - Strong attention to detail to ensure all components of the website are correctly transferred and operational.
I'm in need of a talented professional for video editing. Due to initial project uncertainities, I haven't yet specified the purpose and length of the video, nor the nature of the footage. However, flexibility and adaptability are critical due to these variable elements. Ideal Skills and Experience: - Proficiency in diverse video editing software - Proven record of handling different types of footage (events, products, and travel) - Creativity and adaptability to suit different types of video - Ability to work effectively with vague initial direction and refine based on feedback - Experience in both short and long format video editing would be advantageous So, if you want to work in a dynamic setting, this job is the perfect for you.
...Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Clo...
...com/watch?v=H7XTE9Yc7XM The final video should be engaging to viewers, while maintaining a level of professionalism. This is essential, as it will be a key part of my content that I'll be sharing with my audience. I'm preferring video editors who are good with Malayalam Key Project Requirements: - Edit 10-30 minute long-form videos - Use dynamic editing with fast cuts, transitions, subtitles (English), and use animations to represent visualizations. - Create a final product that's engaging and professional Ideal Candidate: - Creative approach to dynamic editing - Great attention to detail - Expertise in Adobe after effects Please note that this project might be a long-term collaboration for the right candidate. Looking forwar...
PiipAi is actively seeking a dedicated and experienced QA (SOFTWARE TESTER) to join our dynamic team. About Us: PiipAi is a forward-thinking software company committed to delivering innovative solutions that empower businesses. Our flagship product is a comprehensive Human Resource management suite designed to streamline operations and optimize people management. We envision this suite as a specialized CRM, tailored specifically to people-centric management. Role and Responsibilities: As a QA (Software Tester) at PiipAi, your role is pivotal in ensuring the quality and reliability of our software. You will work closely with our development team to meticulously test and validate our applications, identifying and rectifying any issues that may arise. Key responsibilities...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% ...
I'm looking for four funky, Gen Z-inspired t-shirt designs. These designs should be innovative and fresh, inspired by the style of ...These designs should be innovative and fresh, inspired by the style of the Bluorng brand. The ideal candidate for this project should have a keen eye for Gen Z aesthetics and be able to translate that into a dynamic, eye-catching t-shirt design. Key Points: - 4 t-shirt designs - Funky, Gen Z-inspired style - Innovative and fresh, inspired by Bluorng Brand - Ideal color palette: Bright and bold Ideal Skills and Experience: - Strong understanding of Gen Z aesthetics - Experience with innovative and fresh designs - Proficient in translating brand concept into designs - Prior experience in t-shirt design and printing - A portf...
hello We are currently looking for someone to manage the server that will run our website and app. (Please enter “ITO” to confirm) -Work: Anywhere you want -Job description: Manage everything from server hosting to operation In particular, maintenance/repair to ensure that security is very strong. Video conference once a week Submit work details and inspection results as a report every three days -Salary: $100/month ((Budgets may continue to increase as the company grows in size and sales increase))
