Tsql xquery jobs
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
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...
...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.
...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
...with the possibility of 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: 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 ...
add foreign key to a tsql table on Azure synapsys the regular code doesnt work
Need Power BI reports with DAX and TSQL code.
Looking for 1 to 1.5 years exp ASP.Net , Power Builder , Microsoft SQL Server, Database should be strong , TSQL, Stored Procedure. If you knowledge of Laravel / CI thats a plus. Contract Duration : Min 3 months (will be extended based on requirement) Time Zone : US Time shift Working Hours ; 8-8.5 hours Working Days : Mon - Friday
For our Dating Platform we are searching Full Stack Developers for a long term partner ship (6 month -). Our Server is linux based, you should have the follow skills: Database Architecture Database Design XQuery NGINX PHP JavaScript Java Node.js
We have a already developed project on Stylus Studio and xquery thorugh which we are converting EDI to XML as per our mapping business logic we are facing some error so we required help to rectify the error
Dear freelancer, I have a sql server db with the following columns: Date, number1, number2, number3, number4, number5, number6 and few other columns. I need a tsql query that will create all possible combinations for numbers from 1 to 90 escluding occurences in database. For example, if there's already in db a combination such as 8, 11, 18, 46, 48, 88 then it should be excluded from the result set. Parameters to be accepted are as follows: NUMBERS TO BE EXCLUDED: set of number that should be excluded from result set CONTINUOUS NUMBERS YES/NO: Exclude from result set sequences with continuous numbers (eg. 12345 or 1, 2, 15, 16, 22, 23, etc) RANGE OF NUMBERS (FROM 1 TO 10): How many numbers to be included in result set RANGE OF NUMBERS (FROM 11 TO 20): How many numbers to be i...
Requirement - Zoom Developer (DB Specialty) training wish list PAX – 15 – 20 ( Both Freshers & Laterals) Technologies to be covered 1. SQL Server Integration Services (SSIS) 2. SQL Server Analysis Services (SSAS) 3. DAX 4. Advanced TSQL – Emphasis on Stored Procedure development Expectaions: Should have some familiarity with coding in general of course. Frontend UI Developers should have the following general skillset: Net Core, ASP.NET, Web API, Microservices, C#, TSQL, AngularJS, Java Script, Linux, Azure Power Apps, Bots, RPA, Python.
