Sql server management studio query examples 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ä.

En ole IT ihminen, niin en tiedä minkälaista työtä kotisivun rakentamisen tarvitse. Voin kertoa toki mitä kaikkea informaatio siihen tulee. Niin tässä on puhelinnumeroni soitakaa niin annan lisäätietoja jos hintatarjous vaati sen. Rita Albors 0504911358

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

himanshubittoo himanshubittoo himanshubittoo himanshubittoo

server optimisation

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

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

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

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You...timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through ...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I need a data computer operator to assist with online data entry tasks. The data will primarily be sourced from online platforms and will be used for updating our database. Key Responsibilities: - Efficient and accurate data entry from vario...operator to assist with online data entry tasks. The data will primarily be sourced from online platforms and will be used for updating our database. Key Responsibilities: - Efficient and accurate data entry from various online sources. Ideal Skills and Experience: - Proven experience in data entry, particularly from online sources. - Strong attention to detail. - Familiarity with database management and updating. Please note that the primary focus of this role is accurate and efficient data entry, so attention to detail and reliability ar...

I require a skilled content marketer to focus on newsletter writing, Linkedin / Twitter writing and social media management. - The main goals of this strategy are to increase our newsletter traffic and build personal brand. - The target audience for this campaign is B2B especially CMOs, Founders, Sales Leaders and Business Professionals (business to business). Ideal candidates should have a strong writing background, extensive experience in B2B content marketing, and a proven track record of driving traffic and personal brand building. Social media expertise, particularly in B2B contexts, is a must. Please provide examples of previous relevant work in your proposal.

...designs that will be relevamt in today's fashion world without clashing with the purpose of earthiness and spiritual connection. - Minimalistic Patterns: Please keep the design simple yet captivating. The patterns should be kept to a minimum, focusing on the structure and overall appeal of the hijab. - Pastel Colors: I prefer colors on the softer side. Light pink, baby blue, and soft peach are some examples to consider. Ideal candidates for this project should have experience in fashion design, particularly in creating designs for scarves or similar accessories. Ability to understand and adhere to the design brief, as well as a creative eye for textures and colors is essential. The successful designer will be able to balance modern fashion trends with the traditional respec...

The purpose of this report is to propose the system analysis for the client, with the intention of ensuring all stakeholders involved agree to the planned solution. Throughout the project the analysis, development, implementation and testing phases will be conducted using the industry standard, agile development life cycle. This specifies that changes can be made if required and appropriate. The system analysis report is intended for all the project’s major stakeholders: the client, the trainers, the costumers ,if they can be involved, and the development team.

...with content creators to ensure accuracy and relevance. Implement SEO best practices to enhance site visibility and traffic. Plugin Management: Advise on the selection and installation of WordPress plugins to enhance site functionality. Regularly update and manage plugins to ensure compatibility and performance. Monitor plugin performance and troubleshoot any issues that arise. Qualifications: Proven experience in managing and maintaining WordPress websites, particularly e-commerce platforms. Strong understanding of WordPress CMS, including themes, plugins, and customizations. Proficiency in HTML, CSS, JavaScript, and PHP. Experience with SEO and content management strategies. Knowledge of website security protocols and best practices. Excellent problem-solving skills an...

We as an Agency are i...platforms. This role will include a range of tasks such as: Discord: - Deleting inappropriate messages. - Managing user conflicts. - Enforcing server rules. - Building and maintaining an engaging server environment. Telegram: - Monitoring chat activity and ensuring user's compliance with community guidelines. - Identifying and removing spammers. - Managing user bans efficiently without disrupting the positive community vibe. - Providing guidance to users, addressing their queries, and enhancing their platform experience. Ideal candidates should have prior experience managing these platforms and have great conflict resolution and community management skills. Your expertise in creating a vibrant, engaging, and rule-respecting community wil...

...from our target. Apart from that, we have the need to comply with Google Policies, wich are the following: Conversion Measurement and Privacy adjustments. Privacy and measurement support proposal for the company and its 2 main assets/landings. Both with different Google Ads pixels. - Audit of essential conversion measurement pixels. - Audit Measurement in the relationship with the consent management tool/cookie banner/CMP. Incorporation of a CMP. Cost of the CMP by the client. - Audit and Set up in GA4 and GTM of measurement coordination with the CMP. - Set up of "Consent Mode" in GA4, a mechanism to comply with legal regulations and Google Analytics processing requirements. - Set up Enhanced Conversions. Review of requirements and submission of Data Layer require...

...in an inspirational and motivational style to engage the viewer and create a sense of excitement. See examples here: You can use stock video content from sites like: Key Requirements: - Create a 60-second video - Target audience: Young adults (18-34) - Style: Inspirational and motivational Ideal Skills: - Video production - Creative direction - Understanding of young adult audience psychology Experience: - Prior work on similar product introduction videos - Experience creating inspirational or motivational content - Proven track record of engaging young adult audiences. In this contest, you can send examples of your previous work or a short demo of work you intend to complete for the project. The purpose of the

I am in need of a professional data entry specialist able to handle a variety of data types and formats. This includes text, numbers, and images, with the bulk of the work being in Excel format, but also invo...bulk of the work being in Excel format, but also involving Word and PDF files. The task involves inputting a small amount of data, less than 100 entries. Ideal Skills and Experience: - Proven experience in data entry, ideally with a variety of data types - Expertise in Excel, with the ability to organize and manage data effectively - Attention to detail to ensure accurate data entry - Time management skills to complete the task efficiently - Familiarity with Word and PDF formats Your precision and understanding of various data formats will be key in executing this task suc...

...need of a computer engineer who can assist me in developing a WhatsApp embedded onboard system. This system should be capable of sending, receiving, and managing messages. Key Requirements: - Implementation of WhatsApp integration for an onboard system. - Functions to send, receive, and manage messages through the onboard system. Preferred Skills: - Proficiency in C#. - Familiarity with Visual Studio MVC projects. - Experience in embedded systems and software development. - Familiarity with messaging application development. - Strong problem-solving abilities for hardware-related issues. Should you have a background in both computer engineering and software development, with a particular proficiency in C#, I'd like to hear from you. This is a unique project and I'm l...

...inspirational and motivational style to engage the viewer and create a sense of excitement. See examples here: You can use stock video content from sites like: Key Requirements: - Create a 60-second video - Target audience: Young adults (18-34) - Style: Inspirational and motivational Ideal Skills: - Video production - Creative direction - Understanding of young adult audience psychology Experience: - Prior work on similar product introduction videos - Experience creating inspirational or motivational content - Proven track record of engaging young adult audiences. Please send examples of your previous work. Bids without examples/portfolio will be rejected! Long-term collaboration for an excellent freelancer. Please

...virtual assistant to help me manage interactions on my Facebook and Instagram profiles. Your main task would be to reply to 1000 comments on these platforms, a one-off job. My preference is for a mix of personalized and generic replies, as appropriate. I will have the rest written already and must be done NOW! Urgent work Ideal skills and experience include: - Proven experience in social media management - Excellent written communication skills - Ability to strike the right balance between personalized and generic responses - Familiarity with Facebook and Instagram platforms Your role will be crucial in maintaining and boosting the engagement on my profiles. It's a one-time job to start with, but if the collaboration goes well, there may be potential for ongoing work. Loo...

I am looking for a skilled Shopify and Woocommerce expert to smoothly transition my existing Woocommerce site to Shopify. Key aspects of migration will include: - Transfer of Product Catalog: The project involves migration of more than 5...accurate transfer of my product's custom price variations from Woocommerce to Shopify. For this project, the ideal freelancer should have prior experience in ecommerce site migrations, particularly between Woocommerce and Shopify, and a strong understanding of product catalog management and customization. Proven attention to detail will be crucial to accurately migrate all necessary data and ensure no loss of functionality. Essential Skills: - Shopify - Woocommerce - Site Migration - Ecommerce - Product Catalog Management - C...

I am in need of a skilled video creator who has experience in both 2D and 3D animation. The ideal candidate for this role should be able to create realistic animations for educational purposes. Key Responsibilities: - Develop engaging and informative 2D and 3D animations - Ensure that the animations are realistic and suitable for educational content...Proficient in 2D and 3D animation software - Strong portfolio of previous realistic animation work - Experience creating educational videos - Good understanding of effective storytelling - Attention to detail and ability to meet deadlines If you are a creative and detail-oriented video creator, and you have a passion for creating educational content, I would love to hear from you. Please provide examples of your previous work in your...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

I need a comprehensive and professional formatting of a government project report. This report is aimed at analyzing the effectiveness of current government programs, identifying areas for further improvements and suggesting recommendations for future initiatives. The needed formatting require...recommendations for future initiatives. The needed formatting requirements include: - Font style and size - Heading styles - Margins and spacing - Including images, tables etc. Ideally, you possess a keen eye for detail and an understanding of government report structures. A background in preparing and formatting formal documents or reports is a plus. The project has to be completed ASAP, so time management skills are crucial. Please bid, outlining your relevant skills and estimated turnar...

...the capabilities as a specific spec for what the input text file contains. 4. You can make it a price depending of what it can do and list possibilities. 5. If there is an app that allows a TXT definition like what I am saying, then I would consider buying that, but I tried that and this gig is really for having it developed. Search for FLOWCHART and click on IMAGES and you'll see hundreds of examples. Include: 1. Source Code 2. Compiled Code 3. User documentation. 4. Technical (programmer) documentation: Technologies used, overall flow, for each function/subroutine what the input and output are. Should be 1-2 pages (the more the better.) 5. I get a week to test it. At first you can run it. When it's working I'll test it myself. If I find bugs they are fixed ...

I require an experienced professional to assist me in creating a Drupal website, developing Moodle courses, and integrating the two platforms seamlessly. Key Project Details: - Drupal Website Development: I'm looking for someone who has extensive experience in Drupal to create a professional, user-friendly, and re...courses, especially those involving text-based lessons, video tutorials, and interactive quizzes. - Drupal-Moodle Integration: Previous experience in integrating Drupal and Moodle will be a significant advantage. If you can demonstrate the necessary skills and experience, and are committed to delivering high-quality work within the specified timeframe, I'd love to hear from you. Please provide examples of your previous work and your proposed approach to this ...

...group specifically targeting local community members in the United States. Key Responsibilities: - Implementing strategies to increase the group's membership - Engaging with the audience and fostering a sense of community - Delivering a regular flow of content that is relevant to the local community I'm specifically interested in a freelancer who: - Has a solid background in social media management and growth - Possesses experience in creating and curating engaging content - Understands the nuances of community building on Facebook Ideal Deliverables: - A noticeable increase in the group's membership within a specified timeframe - A boost in the group's engagement levels - Consistent and relevant content delivery Previous experience in growing Facebook ...

As a skilled writer looking to earn money, I'm keen to explore the world of copywriting. I'm seeking a professional copywriter who can guide me on how to monetize this skill. Key Requirements: - Show me the ropes: I need a comprehensive understanding of the art of copywriting, and how this skill can be used to generate income. - Help me get starte...looking for practical tips, strategies, and possibly even some initial assignments to help me start earning money as a copywriter. Ideal Skills and Experience: - Proven success as a copywriter - Ability to explain and demonstrate how to make a living out of copywriting - Excellent mentoring and coaching skills - A portfolio of clients and projects could be a great asset Please provide clear examples of how you can assist in...

As a skilled writer looking to earn money, I'm keen to explore the world of copywriting. I'm seeking a professional copywriter who can guide me on how to monetize this skill. Key Requirements: - Show me the ropes: I need a comprehensive understanding of the art of copywriting, and how this skill can be used to generate income. - Help me get starte...looking for practical tips, strategies, and possibly even some initial assignments to help me start earning money as a copywriter. Ideal Skills and Experience: - Proven success as a copywriter - Ability to explain and demonstrate how to make a living out of copywriting - Excellent mentoring and coaching skills - A portfolio of clients and projects could be a great asset Please provide clear examples of how you can assist in...

I'm seeking an experienced WordPress developer to craft an e-commerce website primarily using Easy Digital...- Integrate Easy Digital Downloads as the core marketplace plugin. - Set up multiple Indian payment gateways, such as Net Banking, BHIM, GPay, and Phone Pay, ensuring security and ease of use. - Optimize site for performance, scalability, and SEO. Ideal Skills: - Proficiency in WordPress & Easy Digital Downloads - Experience with payment gateway integration - Strong portfolio with e-commerce examples - SEO and performance optimization expertise The successful freelancer will demonstrate a strong understanding of e-commerce strategies, particularly within the WordPress landscape. Your experience with Indian payment systems will be pivotal. Let's create an onlin...

I need an experienced social media manager to take over the content creation and posting for a number of clients. - **Content Creation**: I currently have a mix of text-based and image-based posts. You will be responsible for creating similar design content. - **Posting Schedule**: I need 4 posts a week on bo...mix of text-based and image-based posts. You will be responsible for creating similar design content. - **Posting Schedule**: I need 4 posts a week on both Facebook and Instagram for each client. - **Audience**: No specific target audience to focus on. This will be an ongoing project, progressively starting with 6 clients. The ideal candidate should have a solid understanding of social media management, excellent design skills, and be able to consistently deliver engagin...

I'm in need of a modern and creative logo, along with accompanying artwork, for my food trailer. THE NAME OF THE BUSINESS IS: - "SMASHHH" BURGER -" SMASHHH" SHAKES & MOCKTAILS - "SMASHHH" COFFEE Key Requirements: - Modern Style: I'm looking for a logo and artwork that reflects a contemporary, sleek and clean design. - Elements: The logo sh...include my company name and a representation of a food item. Timeframe: I need this project completed as soon as possible. Ideal Candidate: I'm seeking a designer with experience in creating modern logos and brand assets. It would be beneficial if you have specific experience in the food industry. Your portfolio should showcase your ability to create clean, impactful designs. Please prov...

...the CC (reserves the money) and then it should activate a phone line and create a PDF with QrCode and then capture the money but it doesn't activate the phone line or send the pdf. We also want to integrate a few new suppliers via their API so we need new functionalities added to the plugin. -woocommerce plugin FIX - linux management - deploy on linux, create new features - long term maintenance Gitlab version control - create pipeline to our staging server and do version control RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintai...

I am looking for an experienced and creative social media specialist to create and manage advertising campaigns for my business across several platforms - namely Facebook, Instagram, Twitter and TikTok. Skills and Experience required: - Proven experience in managing paid social campaigns on Facebook, Instagram, Twitter and TikTok - I...Skills and Experience required: - Proven experience in managing paid social campaigns on Facebook, Instagram, Twitter and TikTok - In-depth knowledge of these platforms' advertising algorithms and audience segmentation - Ability to create engaging content suitable for each platform - Strong understanding of analytics and ability to optimize campaigns based on results Please apply with relevant examples of campaigns you've managed and resu...

My project requires an expert in machine learning, particularly with a focus on using Python for neural networks. Ideal Skills and Experience: - Proven experience in machine learning projects - Expertise in Python programming - Proficiency in neural network programming - Strong understanding of deep learning Your understanding of machine learning principles, advanc...Skills and Experience: - Proven experience in machine learning projects - Expertise in Python programming - Proficiency in neural network programming - Strong understanding of deep learning Your understanding of machine learning principles, advanced Python programming, and neural network frameworks will be pivotal to the success of this project. Please detail your relevant experience and provide examples of similar...

...ensure the form works flawlessly across all devices and browsers Bonus at extra payment: - Validation - Implement form validation to ensure data integrity and accuracy (this will be optional as second task, i.e. do not mind about validation here, but you may if you want for extra bonus). Additional Information: - The Word document will be provided to the selected candidate. - Please include examples of similar work you have done in the past (Screenshots or Links). If you have the skills and experience required for this project, please submit your proposal along your planned timeline and state if you are able to deliver the php-part as well (i.e. form->array and array->default-values-in-form). Please calculate your proposal amount carefully as we will NOT accept "I...

I'm seeking a beginner level IT Technical Trainer with expertise in Networking, Operating Systems Trouble Shooting, and MDM. The candidate I'm looking for should have: - Solid foundation in Networking - Knowledge of MDM (Mobile Device Management) - Ability to troubleshoot various operating systems The mode of training delivery preferred is in-person at our location. Therefore, local candidates or those willing to commute will be ideal.

I am seeking a skilled and experienced designer who can help me with a simple yet crucial task: changing the color of my product images. I have 2 products with around total 9 images, all of which are currently yellow, and I need them to be transforme...the Hue/Saturation tool - A good eye for aesthetic improvements - Experience with product image editing or e-commerce Deliverables: - All files should be high-resolution(similar to original photos) and in a format same as given image not same as sample color image. Please let me know if you're proficient with Photoshop and have experience with similar projects. I'm looking forward to seeing examples of your past work. Attached Zip file of images. It includes 12 colour variations and 2 products. It means, total 24 variatio...

...equivalents in your native language. Additionally, you will evaluate the context dependency of these proverbs. Responsibilities: - Read and understand provided English proverbs. - Identify and provide equivalent proverbs in your native language, along with their translations. - Assess whether the meaning of the equivalent proverbs changes depending on the context. - Provide brief explanations and examples if the meaning is context-dependent. Requirements: - Fluency in English and at least one other language. - Strong understanding of proverbs and idiomatic expressions in both languages. - Attention to detail and the ability to provide clear, concise explanations. - Previous experience in translation or linguistic annotation is a plus. This is a remote, freelance position. If y...

I'm seeking a social media manager to help me with my Facebook and Instagram accounts. Key Responsibilities: - Grow my follower count on Facebook and Instagram - Enhance engagement on both platforms - Drive traffic...with my Facebook and Instagram accounts. Key Responsibilities: - Grow my follower count on Facebook and Instagram - Enhance engagement on both platforms - Drive traffic to my website from these social media channels I'm looking to: - Increase the number of followers - Boost engagement levels - Drive quality traffic to my website The ideal candidate should have experience in: - Social media management - Growing followers and engagement - Increasing website traffic through social media Your successful work on this project will be a great step towards long...

...dashboard. The primary goal of this project is to provide a user-friendly interface for my data, with the following features in mind: - **Data Visualization**: I want the dashboard to be able to display key data pertinent to my business. This may include sales data, user activity, and website traffic. - **User Management**: While not explicitly stated, I understand the importance of user management in an admin dashboard. Therefore, building a system that allows for user management is a crucial part of this project. - **Role-based Access Control**: I want the dashboard to have role-based access control. This means that users will have different levels of access based on their roles within the organization. Your responsibilities will include the following: - **Data ...

I'm looking for a skilled developer who can create an Outlook extension with integrations to vTiger CRM. The main features the extension should have include: - CRM Integration: The extension should seamlessly integrate with vTiger CRM for maximum efficiency - Contact Synchronization: It should be able...functionalities with vTiger CRM - Email Tracking: Ability to track emails in Outlook that are related to data in vTiger CRM The ideal candidate for this project should have: - Experience in developing Outlook extensions - Proficiency with vTiger CRM - Strong background in CRM integrations - Excellent understanding of lead generation processes - Familiarity with email tracking mechanisms Please provide examples of similar projects you've worked on to help me evaluate you...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.