Tsql xquery työt

I have a set of data in a sql server 2005 database that I need to sort some records. I am looking for someone with expert TSQL skills to help with this and possibly more projects to come. The details for the project are attached. You will not need to access my database, the sample script provided should give enough information to provide the tsql solution. If you are interested in this project please provide your experience with tsql and Microsoft SqlServer and your estimated completion time. I would like to get started on this right away. Thank you!

Help with ETL... Help with data integration in an MSSQL enviroment that does not use SSIS and soly relise on TSQL procedures and views. I need someone to map legacy database structure to a common data staging structure through views. I can provide with data structure example from legacy system for one entity and the expected output for that entity in the views. I would require the sql code to create the views to match the staging structure.

Help with ETL... Help with data integration in an MSSQL environment that does not use SSIS and solely relies on TSQL procedures and views. I need someone to map legacy database structure to a common data staging structure through views. I can provide with data structure example from legacy system for one entity and the expect output for that entity in the views. I would require the sql code to create the views to match the staging structure.

Help with ETL... Help with data integration in an MSSQL enviroment that does not use SSIS and soly relise on TSQL procedures and views. I need someone to map legacy database structure to a common data staging structure through views. I can provide with data struture example from legacy system for one entity and the expect output for that entity in the views. I would require the sql code to create the views to match the staging structure.

I need a C# and TSQL formula that will calculate the monthly Payment, APR, interest paid, PMI paid of mortgage loan. The parameters that will be provide are Home Value, Loan Amount, LTV, Loan Term, additional fees and PMI (mortgage insurance). The MI needs to be calculated into the APR until the loan balance is less than 78%. Something similar to

I have written a stored procedure (SQL Server 2005), but I'm having difficulty getting the final part to work. These are the steps that the stored procedure is supposed to go through: 1. Get cursor for all duplicate entries from a table by grouping 5 fields where count is bigger than 1. 2. Cycle through each row in cursor and generate a SELECT where all rows that match each the 5 fields for each cursor. This will return all the rows that belong to each cursor row. 3. Keep the first row within this SELECT and delete all the other rows. This will delete all duplicates and leave just one row. I can do all three steps except that I cannot delete all the other rows for each cursor row. I can retrieve these rows but cannot seem to delete everything after the first row. This is a ...

I have written a stored procedure (SQL Server 2005), but I'm having difficulty getting the final part to work. These are the steps that the stored procedure is supposed to go through: 1. Get cursor for all duplicate entries from a table by grouping 5 fields where count is bigger than 1. 2. Cycle through each row in cursor and generate a SELECT where all rows that match each the 5 fields for each cursor. This will return all the rows that belong to each cursor row. 3. Keep the first row within this SELECT and delete all the other rows. This will delete all duplicates and leave just one row. I can do all three steps except that I cannot delete all the other rows for each cursor row. I can retrieve these rows but cannot seem to delete everything after the first row. This is a ...

We are looking for a top IT person to look after our website, database and programming work on an ongoing basis. Below is a brief outline . Our company iLOVEshopping operates several online shops for which the bulk of sales come from iLOVEsport. Websites i...other companies that also sell our prints and send us orders for which we them pass those orders onto our printers. Our demands for IT are not huge and usually requires on an average week 5 to 10 hours of work. The person would also work on our database , creating many reports and general website work. The skills must one have are as follows: C# ASP.net Microsoft mvc sql server including tsql IIS administration html css javascript classic asp Must also have good communication skills to liase with us via skype...

Hi I have some minor errors in some XML files that I need to be fixed. This is very simple work for a developer experienced in XQuery. It should not take more than 1 hour to fix. I will run the corrected files and then accept the work as complete once the files work correctly(These files are used in custom XQuery code in a custom software which uses Saxon XQuery Processor). I do need this done today itself. Yours sincerely, Arvind.

...Consider above xml data. Write XPath statement to get the value of Name attribute. Answer: Consider above XML data. 2. What is the Ancestor element of element? Answer: 3. Write an XPath statement to get the value of category attribute of “XQuery Kick Start” book element. Answer: 4. Which of the following query statement is used to select all title and price elements from given XML data? a. //book/title | //book/price b. //book/title & //book/price c. //book/title AND //book/price d. //book/title + //book/price 5. //book XQuery expression will return from XML data. e. All book elements f. All grandchildren elements of book element g. Returns an empty node set h. Whole document 6. @ symbol is used to: i. Select the root no...

...Consider above xml data. Write XPath statement to get the value of Name attribute. Answer: Consider above XML data. 2. What is the Ancestor element of element? Answer: 3. Write an XPath statement to get the value of category attribute of “XQuery Kick Start” book element. Answer: 4. Which of the following query statement is used to select all title and price elements from given XML data? a. //book/title | //book/price b. //book/title & //book/price c. //book/title AND //book/price d. //book/title + //book/price 5. //book XQuery expression will return from XML data. e. All book elements f. All grandchildren elements of book element g. Returns an empty node set h. Whole document 6. @ symbol is used to: i. Select the root no...

Need to SQL developer to develop a TSQL view that will count the number of projects per person in an existing view on a functional Project Server 2010 development server. Example: Count the number of projects per person per month and set into new field (number-of-projects). Divide the capacity by the number of projects. The resource has 2 projects for January 2013 and the actual capacity calculated is 35.2 / number of projects (2) = 17.4

...Uses Cases provided by the W3C Working Group is available at It provides many good examples of XQuery. Please read and then answer the following questions. Questions 1.“” and “” are the DTD and XML files for the bibliography documents of a bookstore. Please formulate the XQuery for the following queries: a)For each book in , list the title and price, grouped inside a “result” element. Then group all “result” elements inside a “results” element. Save the result as “”. b)Using “” as input, find the price of the book “Data on the Web”. are encouraged to use Saxon to test the XQuery you make in Question1. (Some of you have ...

...the failed backups and Restoration of databases.  Upgrade/Migration of MS SQL Server 2000 to MS SQL Server 2005, MS SQL Server 2005 to MS SQL Server 2008 using any suitable approach (in place or side by side)  Downgrade of SQL Server 2005/2008 from Enterprise edition to Standard/Developer Edition.  Creation of database maintenance plans, rebuild/defrag indexes, integrity checks. Creation of TSQL scripts for full, differential, transaction log backups, optimizations, integrity checks on some instances that has special requirements beyond maintenance plans.  Scheduling jobs in SQL Server Supporting huge production databases, troubleshooting the problems.  Utilization of DBCC commands for maintaining database consistency  Utilization of Dynamic Management Views for knowing Bl...

I am looking fro someone to implement a PHP SOAP based Web Service. Features of PHeXist to process XQuery statements upon xml stored in an eXist XML database. I will share complete details with selected bidders. It's a small project. Thanks

I am looking fro someone to implement a PHP SOAP based Web Service. Features of PHeXist to process XQuery statements upon xml stored in an eXist XML database. I will share complete details with selected bidders. It's a small project. Thanks

For starters, I need a few hours help configuring a classic ASP search function to access some uploaded Microsoft Word files (doc and docx), and search through the text for indexing. Need to be able to work with T-SQL code. Ideally, a strong understanding will of T-SQL statements and relational queries will be helpful.

This project will be all about analyzing data. You will be developing a solution to help us analyze mountains of data we collect. We are going to need someone who has skills with SQL Server Management Studios, SSIS Package Creation, TSQL, and someone who is strong at creating SQL queries. We also want someone who is familiar with MVC, or WebMatrix as these are the engines we want to use. We run collections to collect data; after that data is collected we need a way to match the data up with products, so we can make intelligent business decisions with that data after it has been collected. We will need to work together to develop a system to analyze the data quickly and efficiently. After we get the SSIS package to import the data, and match it up with the products then we wi...

PROJECT: CONVERSION OF ...CONVERSION OF SQL REQUESTS FOR MDB TO TSQL FOR DB (MS SQL SERVER) Converting Access database request to MS SQL server (TSQL) requests. About 120 database queries based on ACCESS (mdb) need to be converted to T-SQL queries for MSSQL Server 2008. Each request has plenty of parameters. Please bid only if you are professional in TSQL. The project is not difficult, but needs to be worked out 100% accurate. Results need to be tested based on 3 sample databases we provide. Each test database as mdb and db. Results need to be tested and documented. Please check out the queries provided in attached pdf. The Project has about 40 simple, 40 mid and 40 complex queries. Find examples attached. The complex query example is shown as SQL and ...

PROJECT: CONVERSION OF ...CONVERSION OF SQL REQUESTS FOR MDB TO TSQL FOR DB (MS SQL SERVER) Converting Access database request to MS SQL server (TSQL) requests. About 120 database queries based on ACCESS (mdb) need to be converted to T-SQL queries for MSSQL Server 2008. Each request has plenty of parameters. Please bid only if you are professional in TSQL. The project is not difficult, but needs to be worked out 100% accurate. Results need to be tested based on 3 sample databases we provide. Each test database as mdb and db. Results need to be tested and documented. Please check out the queries provided in attached pdf. The Project has about 40 simple, 40 mid and 40 complex queries. Find examples attached. The complex query example is shown as SQL and ...

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

I need a script that will pull a list of SQL server names from a csv, then take that list and check to see if the "Write to Windows Application event log:" is set. If it is set it will write the details of how it is set (when the job fails, when the job succeeds, when the job completes) to another file. If it is no...a script that will pull a list of SQL server names from a csv, then take that list and check to see if the "Write to Windows Application event log:" is set. If it is set it will write the details of how it is set (when the job fails, when the job succeeds, when the job completes) to another file. If it is not set, it will set it to a state of "when the job fails". Prefer a TSQL, or a Powershell script to take care of this. Will also con...

I want to use the information from this website:- From what i understand, It converts XML to sequence diagrams using XQUery. I tried running the code on sausalito and xquery editor but I wasnt successful. I want someone to run it and fix the bugs if any.

I want to use the information from this website:- From what i understand, It converts XML to sequence diagrams using XQUery. I tried running the code on sausalito and xquery editor but I wasnt successful. I want someone to run it and fix the bugs if any.

Fix the following error: Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: in /home2/netcubec/public_html/cp/addon/ on line 16 Couldn't connect to SQL Server on - cPanel server - freetds installed - I can connect to mssql server with TDSVER=7.2 tsql -H -p 1433 -U username but cannot connect from php

We are a company based in Costa Rica, we have some local customers in the finance industry, we also have some internal projects and we are at a point were we need an extra help. One of our main products is a custom CMS with special features for banking industries built in .Net. We need a .Net developer with strong knowledge of web development which includes javascript/jquery, HTML, php, .Net and TSQL basic knowledge is needed as well. We are interested on hiring someone to work on special modules, sites, so on. We will assign the job and provide estimates and pay an hourly rate(starting with 64hours per month,16 hours per week ), we are just beginning to test how the remote employee works for us, if this is successful experience we are definitely interested on hiring on a monthly sa...

We are a company based in Costa Rica, we have some local customers in the finance industry, we also have some internal projects and we are at a point were we need an extra help. One of our main products is a custom CMS with special features for banking industries built in .Net. We need a .Net developer with strong knowledge of web development which includes javascript/jquery, HTML, php, .Net and TSQL basic knowledge is needed as well. We are interested on hiring someone to work on special modules, sites, so on. We will assign the job and provide estimates and pay an hourly rate(starting with 64hours per month,16 hours per week ), we are just beginning to test how the remote employee works for us, if this is successful experience we are definitely interested on hiring on a monthly sa...

I want you to **provide me or implement an algorithm called TreeMatch**. I need it for my project. It is used to match extended xml queries (XPath and XQuery). The algorithm can be found in the IEEE Transaction Paper (IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2011) The title of the paper is "Extended XML Tree Pattern Matching: Theories and Algorithms" and can be downloaded from google or from the attachment. (algorithm starts at page 7 of pdf) There are 4 algorithms in the paper (all these are part of the same algorithm called TreeMatch). I need these implemented in Java, along with a small front end to accept the queries and display the output. (This should be integrated into an existing front end created with swings) The program should accept Extended XML ...

Hi, We have a established software working on a large Data set related to Trading Instruments. Task is to optimize the Data Drilling Process .Skill required is Database Optimization through TSql. Money and Mile Stones can be negotiated while we you explain the full process and you revert with the level of optimization that can be done .

Hi, We have a established software working on a large Data set related to Trading Instruments. Task is to optimize the Data Drilling Process .Skill required is Database Optimization through TSql. Money and Mile Stones can be negotiated while we you explain the full process and you revert with the level of optimization that can be done .

...and mission. Provide user support to application users to ensure the tools created are used as intended and aide GIS data sharing with official federal, state, and local organizations. This position is located in Warren, MI. Basic Qualifications: -2+ years of experience with creating and managing Microsoft Access and SQL Server databases, including creating tables, relationships, data models, TSQL, performance tuning, or normalizing data -4+ years of experience with ASP .Net for 3.5 or higher and Web development, including C# or VB -2+ years of experience with developing Visual Basic and VBA applications to automate forms and respond to user events connected to SQL Server or Microsoft Access databases -Experience with writing SQL queries and performing database reporting ...

...and mission. Provide user support to application users to ensure the tools created are used as intended and aide GIS data sharing with official federal, state, and local organizations. This position is located in Warren, MI. Basic Qualifications: -2+ years of experience with creating and managing Microsoft Access and SQL Server databases, including creating tables, relationships, data models, TSQL, performance tuning, or normalizing data -4+ years of experience with ASP .Net for 3.5 or higher and Web development, including C# or VB -2+ years of experience with developing Visual Basic and VBA applications to automate forms and respond to user events connected to SQL Server or Microsoft Access databases -Experience with writing SQL queries and performing database reporting ...

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

Greetings, we need a programmer for different reports (BIRT), using BaseX (XQuery). DB PostgreSQL. Programmer must know Russian language well.

Write a bunch of queries in TSQL 2008. All pretty simple. i NEED A BUNCH OF QUERIES WRITTEN BASED UPON CRITERIA i WILL PROVIDE.

Write a bunch of queries in TSQL 2008. All pretty simple. i NEED A BUNCH OF QUERIES WRITTEN BASED UPON CRITERIA i WILL PROVIDE.

This is a good opportunity to join a small team working on an ongoing project for the right person with both good technical skills, experience and a reliable, professional attitude. The project requires good MS SQL/TSQL skills, asp.net (vb) web development, Ajax, JS and HTML. You do not need to be a graphic designer but you do need excellent coding skills. You will work using Visual Studio, SVN for change control and from specification documents. You will also need good english skills, though it doesn't matter geographically where you are based. A methodical and structured approach to coding and producing performance efficient work is important. You may also be required to produce test plans for your work and perform some Q/A tasks. This is...

Required Skills: - ASP .NET, C# - HTML, Javascript, CSS, XML These skills are also a plus: - jquery - TSQL Work needed: - Facebook integration: Basic facebook connect integration already exists on the site. We need to extend the integration to do things like post to connected users's walls, integrate with facebook timeline, and other facebook related functionality.

...tasks that need to happen out-of-band such as querying Google or verifying mail addresses. There is a work allocation framework in place, but this needs to be improved and a new UI created to manage the transition of work items through the process. ii) All code is written in C# on .NET 4. The web module is ASP.NET in C#. The database is Microsoft SQL Server with stored procedures written in TSQL. There are no .NET assemblies loaded into the database. iii) The user authentication module is complete. The UI could probably do with some work but this isn't key. The time-sheet module is complete (except for some small reporting requested amendments). The marketing UI is very basic (Probably around 10% complete) and needs substantial work. The worker module is probab...

I need a stored proceedure which I can execute from my VB.NET Client Server Application which will get the current Session ID and give me the last 5 Minutes of TSQL Statements which have been run. SQL Profiler can perform this in a Post analysis function however this is to problem solve a app issue while in production which makes it impossible to start the profiler at the approriate time. The SQL Server is also SQL Server Express 2008. I would prefer to not have to switch this on and off however I'm not sure if it is possible to achieve without constantly running some sort of audit which will impact performance. Note: I am not interested in simply returning the current running SQL, but in the SQL which ran a couple of minutes ago.

I need a stored proceedure which I can execute from my VB.NET Client Server Application which will get the current Session ID and give me the last 5 Minutes of TSQL Statements which have been run. SQL Profiler can perform this in a Post analysis function however this is to problem solve a app issue while in production which makes it impossible to start the profiler at the approriate time. The SQL Server is also SQL Server Express 2008. I would prefer to not have to switch this on and off however I'm not sure if it is possible to achieve without constantly running some sort of audit which will impact performance. Note: I am not interested in simply returning the current running SQL, but in the SQL which ran a couple of minutes ago.

We are looking for Perl Developer for a contract based in Brighton Knowledge of web development techniques such as HTML, CSS and JavaScript ● Experience of XML technologies such as XSLT, XPath, XQuery ● Knowledge of SQL database systems such as PostgreSQL, MySQL, Oracle, SQL Server or SQLite ● Experience of the Linux / Unix environment ● Knowledge of version control with Subversion, CVS or similar systems ● Knowledge of web servers and application servers such as Apache/mod_perl ● Experience of Perl web development with frameworks such as HTML::Mason ● Experience of Perl database technologies such as DBI and Class::DBI ●

...descriptions (by prefixing such terms with a hyphen '-'). The application is currently being developed in Eclipse (Indigo release) on Linux at the moment and the full source will be available in Subversion to the winning bidder. All work will need to be committed into the Subversion repository by the person engaged to complete the project. Programming is to be done in Java (and possibly XSLT/SQL/Xquery depending on the implementation strategy). To be considered, bidders need to be able to demonstrate: 1. previous work on Android applications 2. previous work with XML data, especially using the limited libraries available on the Android platform Bids will also be assessed based upon the proposed implementation strategy for the search function. Will they...

I have few queries to be completed by are my queries.I would pay fix amount for this .I need it before 24 hrs starting now. Attached is a file that u can work on its an following are the queries 1. Find the countries with emerging democracies, which continents they belong to, and the size of their population. ...ethnic group and the percentage associated with that ethnic group. 9. List the countries in Europe in descending order on the size of their population. Inside of each country, nest the provinces in decreasing order of their population. Output all population values using <population> and </population>. 10. Find the maximum depth of the XML document you were given (see ). Use <maxdepth> and </maxdepth> to enclose the value.

Hi I need some help with the xquery .I have 10 queries that has to be run.I need it by are the queries . This is quite clear.I need the logic .Here is the XML document i have uploaded from which i need these xquery. I dont think its very hard .I had other projects and i am new to this so sort of just outsourcing. 1. Find the countries with emerging democracies, which continents they belong to, and the size of their population. Here is the required answer structure: <answer-1> <country>+ <name> ... </name> <continent> ... </continent> <population> ... </population> </country> </answer-1> 2. Find all the countries in Africa, with infant mortality greater than 15% and growth rate less tha...

Translate 3 Stored Procedures written in SQL Server T-SQL to Oracle. - The oracle version is 8i - The stored procedures have cursors - Access to the database won't be provided, you send us the code and we test it on our oracle server. - Final payment will be done when the full SP's are done and tested

Hi, we need xquery scripting. Found you on the Freelancer.com. Would you be interested?

I have XML documents stored in a data base. These XML documents are an XML version of a medical note. I use SQL Server Reporting Services to retrieve the XML from the data base and then apply an XSLT to render a version of the XML document into Microsoft Word. I need help improving the mechanism I use to retrieve the data from the XML document. ## Deliverables These XML documents have Sections and Sub-Sections. Each section or subsection has a title and then content that is either a series of paragraphs or a list. I currently use a Stored Procedure to generate a data set that has 1 row for each section in the XML. The Stored Proc uses a cross-apply statement to pull the data out of the XML document and generate the data set. The current approach works well as long as the XML document ...

I want you to **provide me or implement an algorithm called TreeMatch**. I need it for my project. It is used to match extended xml queries (XPath and XQuery). The algorithm can be found in the IEEE Transaction Paper (IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING, 2011) The title of the paper is "Extended XML Tree Pattern Matching: Theories and Algorithms" and can be downloaded from google or from the attachment. (algorithm starts at page 7 of pdf) There are 4 algorithms in the paper (all these are part of the same algorithm called TreeMatch). I need these implemented in Java, along with a small front end to accept the queries and display the output. (This should be integrated into an existing front end created with swings) The program should ac...

Tabels Im looking for a T-SQL / ASP.net specialist who can build me 2 stored procedures to get URLs from the database every item (page) in my datbase has a URL, the structure / level of pages is store in the databse called tblStructure the tblStructure has 2 columns, 1 column ID and 1 column ParentID The table tblStructure defines the relation ID / ParentID If ParentID = 0 then you are on TOP / home example : Home > Level 1 > Level 2 > Level 3 tblStructure **************** ID ParentID Second table tblPages has a PageID, a PageName and a PageURL if a item is on level 3 you will get URL homefirst-level-URLsecondlovel-URLthrid-level-URL tblPages **************** PID Name URL There is a link between ID and PID What is need 1. Dat...