Tsql xqueryprojekty
Utworzenie prostej tabeli oraz wstawienie do niej kilka przykładowych rekordów. Napisanie procedury w Transact-SQL. Szczegóły w wiadomości prywatnej.
Napisać 2 procedury w T-SQL. Napisać 2 procedury składowane w PL/SQL Napisać 2 wyzwalacze w T-SQL. Napisać 2 wyzwalacze w PL/SQL. - Jeden z wyzwalaczy ma być FOR EACH ROW. Zadania mogą realizować to samo w obu językach. Zadanie ma być sensowne biznesowo. Pozdrawiam:)
...Developerów i Developerów aplikacji mobilnych. Wymagania: - doświadczenie w tworzeniu poprawnego i przejrzystego kodu C# - znajomość praktycznych zasad programowania i projektowania obiektowego, w szczególności technologii WWF, WCF, - znajomość MVC - znajomość języka angielskiego w stopniu pozwalającym na czytanie dokumentacji Dodatkowe atuty: - znajomość git-a - znajomość Microsoft SQL Server 2008/2012 (TSQL), Oferujemy: - wypłatę na czas - luźną atmosferę bez korporacyjnego rygoru - pracę w biurze Warszawie, część zadań możesz też wykonać zdalnie o dowolnej porze - pracę przy ciekawych i innowacyjnych projektach dla dużych firm - możliwość rozwoju i wsparcie przy realizacji własnych pomysłów/projektów - dostęp do wiedzy/szkoleń w zakresie ...
Pomoc przy XML/Xpath/XQuery ok 30min pracy piątek
...zawartych Od kandydata oczekujemy: - wykształcenia wyższego informatycznego (ew. student ostatnich lat) - gruntownej znajomości języka SQL (wykorzystywany silnik: MS SQL Server 2008) - gruntownej znajomość technologii Microsoft.NET, w szczególności C#, LINQ - bardzo dobrej znajomość technologii internetowych, w tym: HTML, CSS, JavaScript, jQuery - dobrej znajomości technologii XML/XPath/XQuery/XSLT - zdolności organizacyjnych, samodzielności w działaniu, kreatywności i pro aktywności - mile widziana znajomość zagadnień z dziedziny Business Intelligence w zakresie narzędzi raportujących Oferujemy: - atrakcyjne wynagrodzenie - samodzielne stanowisko pracy - pracę w dynamicznie rozwijającej się firmie, w profesjonalnym zespole - miłą atmosferę pra...
...in Gdansk, starting with a small team of 2-3 developers, managed by our Technical director, who moves to Poland. He also is an expert in Xslt, which we use a lot. We're looking for hardworking people with great webdevelopment who likes to work on great internet projects. What do you need? ======================================================== - C# en ASP.NET (Visual Studio 200*) - TSQL (SQLServer 200*) - HTML, Javascript, jquery - XML / XSLT - Communication in English What do we offer? ======================================================== - Salary based on freelance hourrate - interesting and highend webprojects - Possibility to learn (better) Xslt and Umbraco Sounds good to you? ======================================================== Se...
Działanie programu bardzo proste: wczytanie gotowego pliku xquery, wczytanie pliku xml, pobranie od użytkownika nazwy pliku wyjściowego. przerobienie pliku. koniec. pytania: qq: 5564996 Pozdrawiam,
...Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has to be at the ON SITE Dubai office. - Work Location -&...
I need an expert in SSRS 2019 and TSQL creation and optimization to assist in my project. Key Tasks: - Designing and developing robust SSRS reports - Writing complex, efficient TSQL queries - Ensuring optimal performance of both SSRS and TSQL You should have extensive hands-on experience with SQL Server Management Studio, Visual Studio Your background in handling complex data scenarios using these tools will be pivotal. Your role is critical in ensuring the project's success, so your proven expertise is a must.
I am in need of a skilled tutor who...am in need of a skilled tutor who can help me enhance my abilities in data integration and ETL (SSIS), reporting and visualization (SSRS), and database querying and management (TSQL). My main goal is to improve data integration processes. In this project: - You will support my learning to drive more efficient data integration operations. - In-depth knowledge and practical training on how to generate insightful reports and visualizations will be expected. - The training must cater to an intermediate level familiarity with SSIS for data integration. Ideal Skills and Experience: - Experience in SSIS, SSRS, and TSQL. - Ability to impart knowledge effectively. - Experience working with intermediate learners. - Familiarity with different...
I am in need of a TSQL developer expert to assist me with an advanced stored procedure development task. Requirements: - Advanced knowledge and experience in TSQL - Strong understanding of query optimization - Ability to create stored procedures from scratch - Attention to detail and ability to follow specific requirements Skills and Experience: - Proficient in TSQL and familiar with the latest developments and best practices - Experience in developing complex stored procedures - Ability to optimize queries for performance - Strong problem-solving skills and ability to work independently Please note that no existing documentation or examples are available, so the developer will need to create the stored procedure from scratch based on the given requirements.
I am looking for a freelancer to write a TSQL script for allocating several loans repayments on loan repayment schedules on a 'First In First Out' (FIFO) basis. Tables involved: 1. TblLoans (which contains the list of loans) 2. TblLoansRepaymentSchedules (which contains the loan repayment schedules) 3. TblReceiptsLoans (which contains the loan repayments) 4. TblReceiptsLoansSub (which will contain the result of the allocations of the loans repayments on the repayment schedule on a FIFO basis) Approach: 1. The script will iterate from the first to the last loan in TblLoans. 2. For each loan, it will iterate from the first to the last repayment in TblReceiptsLoans. 3. For each repayment, it will look up the loans repayment schedules in TblLoansRepaymentSchedules, alloca...
I'm looking for an experienced book cover designer to bring my book to life. The book is non-fiction, and I don't have any specific themes in mind. Here are my details: Title: SQL Practice and Interview Questions Subtitle: 45 Practice Problems and 15 Common Interview Questions for Your Practice. Author: Aubrey Love Published by: TSQL Basics Description: This book is filled with practice and interview questions for a DBA (Database Administrator). It also contains instructions on how to install SQL Server and other required software. It is designed for beginners as a starting point, and for intermediate and advanced DBAs to use as a desk reference guide. Size: 7.5" x 9.25" It will be published as a paperback, hardcover, and Kindle book on the Amazon KDP platf...
I am looking for a freelancer who is experienced in SQL and TSQL to assist me with query optimization. The ideal candidate should have strong skills in database design and data analysis and expert knowledge in SQL, PSQL and TSQL This is a very short project which should take no more then few hours.
I am looking for an experienced individual with advanced knowledge of Structured Query Language (SQL) and Transact-SQL (TSQL) queries to help me with my project. I need help with topics such as joins, subqueries, and indexes and need assistance with both writing the queries as well as understanding the concepts. My proficiency level in SQL and TSQL is advanced, so I am looking for someone who can provide the highest quality of work to meet my project goals. Task should only take no more then 2 hours
...am looking for an experienced IICS resource who can help me with writing xquery scripts. Specific Task: - The main task will be writing xquery scripts for my project. Existing Script: - I do not have an existing script, so the freelancer will need to create one from scratch. Complexity: - The desired complexity for the xquery scripts is basic. Ideal Skills and Experience: - Strong knowledge and experience in writing xquery scripts - Proficiency in IICS (Informatica Intelligent Cloud Services) - Ability to understand and analyze requirements to create effective xquery scripts - Attention to detail and ability to troubleshoot and debug xquery scripts If you have the necessary skills and experience in writing xquery scripts and work...
I am looking for an IICS resource who can help me with writing XQuery code. I have specific requirements for the code and need someone who can assist me in achieving my goals. The timeline for this project is flexible, allowing for more than 7 days to complete the task. Skills and Experience: - Strong knowledge and experience in writing XQuery code - Familiarity with IICS (Informatica Intelligent Cloud Services) - Ability to understand and execute specific requirements for the code
write TSQL in Microsoft sql server for 3,4,5 problems tasks as mentioned in this document Deadline: today in few hours
Proszę, Zarejestruj się lub Zaloguj, żeby zobaczyć szczegóły.
I need a PHP library installed on my Linux server. The library includes PHP, HTML, TSQL, and JavaScript. The specific library I need installed is the I am open to recommendations for the version to install. The operating system of my Linux server is not specified. The ideal freelancer for this project should have experience with Linux servers and PHP libraries.
Sql Developer Experience-5+ years Major experience in Sql,TSQL,SSIS and SSRS. Remote
Validate and change the start dates in startdate column of tblSchedule_Tasks by querying the enddate of the predecessor task. If the predecessor is 0 the start date remains the same. If the predecessor is 20 for example, you will ...actual start date. IE, StartDate April 19,2023 with a 2 day duration needs a end date of April 20, 2023. Also the query needs to begin with a startdate validated to a prececessor task. I would like to send you the tables in ssms format. After the queries are written I can take it from there. this is a common business use case in a scheduling program. Are you familiar with working with dates in tsql? i exported the two table using generate script in ssms. For simplicity use scheduleID = 20063 in tblSchedule_Tasks. there are several dummy jobs in th...
We are building 2 applications, and we need someone to help with optimizing the code and architecture. You should be able to identify opportunities to improve the applications, explain the improvement, and then implement the update. This is some of the required experience… Code and Architecture Optimization Best Practices and Proper Design Patterns SQL Server: TSQL, Stored Procedures, Functions .NET C# MVC Dapper ORM Vue.js / Angular.js (Nice to Have) Ongoing contract. Pay rate is negotiable
I need to create a POC to replicate data from one TSQL server on local host to a TSQL Server on AWS. It should be dummy data just need to show the process working and the data moving
According to our messages please complete the Job.
Hi! I have an python script to validate an document. There are just a few checks ( if, then, else). I want to convert this ruleset into xquery commands. Because this xml is going in database (base-x) and there i want validate this document according to the rules. The rules you can check in the attachment script.py.
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
? Very good working experience in C#, .NET 4.5, or above Framework And MVC ? Very good working experience in Web API, ASMX, and REST/SOAP services, ? Good knowledge in JSON, TSQL, SQL Server 2014, SPs, Table ? knowledge in Insurance domain will be an advantage ? Ability to handle the existing applications for enhancements individually with little help or no ? IIS Configuration and Setup in Cloud environments ? Experience building Single Page Applications (SPA) using Angular Js and or Angular (Secondary Skill) ? Excellent analytical and problem-solving skills ? Excellent verbal and written communications skills ? Experience in SDLC in Waterfall and or Agile
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
Analyze existing T-SQL code and new T-SQL, identify and document the test cases required for the DB restructure and ETL process refactoring. Perform SQL query tuning and optimization. Work with ETL developers to re-factor the existing ETL processes and create new process. Define and document test plans and test cases for the ETL refactoring and SQL changes. Develop test scripts (T-SQL) and perform data validations and verification's
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
I am looking for SQL, Tsql and SSR experts for project
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
I want a TSQL scalar function that obfusicates strings. I want it to loop through a string and replace all characters with a similar random character; lower with random lower, capitol with random capitol, digit with random digit, and all other characters the same. Example: INPUT: 5123 Myreal+ St, My/city, FL, 32533 OUTPUT: 8195 Uabshj+ Us, Ia/sdfh, HW, 84123
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
...Requirements 1. Software development experience and expertise on .NET core (Dot Net Core) 2. Latest technology stack (.Net framework 4.0 or higher, ASP.Net MVC, Web API, SQL Server 2014 or higher) with best practices. 3. Hands-on experience - jQuery, Angular JS, C#, JSON and XML. 4. Knowledge of ASP.NET Web API and best practices for developing web services. 5. Strong in terms of writing complex TSQL Queries i.e. Stored Procedures and Triggers. 6. Experience working in an Agile development environment. 7. Ability to work both independently and as part of a team. 8. Experience of performing code review for Junior Stack Developers. THIS POSTING IS NOT A ONE-OFF PROJECT OR A PROBLEM SOLVER POST. EVERYDAY REGULAR WORK WILL BE PROVIDED WITH DAILY STANDUP MEETING AND EVERYTHIN...
This work involves writing some XQuery expressions to extract helpful information from some real XML data. Topic containing a XQuery FLWOR expression, frequency with distinct-values(), find the probability from the value and sorting the top 30 from the list.
This work involves writing some XQuery expressions to extract helpful information from some real XML data. Topic containing a XQuery FLWOR expression, frequency with distinct-values(), find the probability from the list.
Hi Yierpan A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Programador senior con perfil full stack. Conocimientos y experiencia (1 año) en desarrollo móvil con tecnología React Native, conocimientos en desarrollo WEB .NET y API Rest, en BD relacional y programación TSQL, así como nociones de BD no relacional (COSMOSDB), también en despliegues en cloud e integración con servicios PaaS preferiblemente sobre Azure. Se valorara conocimientos en IoT. Jornada completa, flexibilidad horaria, semipresencial. Preferiblemente residente en Murcia o provincias colindantes.
...it to continue in 2023. Would you like to be part of a senior-level SQL Server growing team with opportunities for advancement? Job description - Design cutting-edge SQL Server solutions - on-prem and cloud - Proactively discover db issues - Find bottlenecks - Troubleshooting - Performance tuning Required skills - Verbal and written English required - SQL Server - TSQL - Attention to detail Preferred skills - Partitioning, AlwaysOn, Clustering, Indexing, Replication, extended events, baselining - Standard operating procedures Misc details - Our team works during New York EST business hours. We need at least some overlap on the timezones in order to have regular meetings and give feedback. - Knowledge of other programming langua...
Hi Geert B., I need help with Xquery already written for a task. We can discuss details over chat.
sql expert needed to complete project must know advanced sql queries Database Question 4 languages allowed: mysql, oracle, tsql, db2 Test duration 30 mins No. of questions 1 question
...extending for another 2. This will be a full time project eliciting 40 hours per week, Mon to Fri and if needed/approved, on the weekend as well. This is in the medical billing industry so the Developer has to meet the HIPA Compliance requirements. The ideal candidate should be efficient in the following technologies: Blazor, Xamarin, MAUI SQL Server TSQL queries, views and stored procedures Database functions XML Querying XML using TSQL Applying namespaces to XML queries EntityFramework Implementing EF Querying tables, views and functions Updating EF models .NET Framework Working with .NET Framework 4.5+ Asynchronous function Multithreaded development XML Serialization/Deserialization Reflection ASP.NET MVC Development using Razor Developing models Performing model v...
Hello My friend gave me your contact and said you can help me with my TSQL task I have. I am very new to the database field and would like to hire you. Please let me know. Thank you He said you charge per hour as well
