Tsql Projects

Transact SQL help

I have an OK knowledge of Transact SQL but struggle with more complex queries. I'm looking for someone who can help me create the queries that I need on an on-going basis. Typically my requests will be for help with specific queries and each one will almost certainly be no more than an hour at a time. So very short, sharp 'projects'. So I'm looking for a longer term 'helper' who I can call upon when needed. I *might* be interested in a one-to-one on-line session to get a better understanding of TSQL queries.

TSQL script writing from a Sql server tables

I want a script that will calculate - how many nights guests stayed in total in our hotel from the arrival date and departure date. - how much revenue was made from each guests (maybe using the total revenue column or a sum of roomrevenue, Foodrevenue and otherRevenue) - guest lead time (which is the time they booked, until the time they checked in - that is arrival date minus reservation date) this should be done for all definite stays only and IsActive and match stayID = profileStayID = CustomerMasterId from linkprofile table. kindly contact me for the tables

TSQL script to add re-occurring rows within next 30 years

I need a TSQL (SQL Server 2016) script written to list components that will reoccur in the next 30 years. I will put this query in SSRS so needs to be simple but robust. For example component A has a lifecycle of 6 years with the current programme year of 2025, it will need to list additional rows in my query programme years 2031, 2037, 2046. *lifecycle is a field, programme year is a field. This is the existing query and new query must be dynamic as programme years can change. select [Component Description] ,case when nullif([Progamme Year],'') is null then year(DateAdd(yy, Lifecycle, Cast([Installation Date] As date))) else [Progamme Year] end [Progamme Year] ,Lifecycle ,cast(replace(nullif([Total Cost per install],''), '£','') as decimal(10,2))[Total Cost per install] from [DBAdmin].[dbo].[AssetsDwellingBusinessNewPlan] PLease see existing sample and output required. Attachment: Items in white background are from the table, item in yellow is an example used, items in red are the expected output. The output should also include programme years that have no costs against them, so 2020, 2021 etc. Happy to provide further details.

opportunity

Corporate/marketing website development. NOT in wordpress etc...

We are a SAAS platform provider, and develop our own online platform using HTML/Javascript/C#/TSQL etc... However, we don't have the time in house to develop our own marketing website initially, but would intend to maintain it going forward in house. Hence, we are looking for someone to design it initially with the content we provide, in such a form that we can edit and develop it further. Hence, we do not want it developing in Wordpress or similar, and without a CMS, but needs to be coded from scratch such that the HTML/Javascript/.net etc... can be easily edited by us going forward in our existing visual studio environments. We will provide all primary content such as company logo, text for the different pages/sections, associated images, and videos to embed. However, we need someone with experience designing corporate websites, as this is for our main site to promote our product. Our existing site is very archaic and the content is out of date too, so we are in urgent need of a relaunch. In addition to the content we have put together, we have also provided a list of sites, the design of which we like below as a guide to what we are trying to achieve... https://www.sisense.com/ (This in terms of style and layout - but not colour - is the closest to what we are looking for) http://www.themill.com https://www.airbnb.co.uk/ https://www.chillysbottles.com/uk We also have a colour pallet for all our branding which we will supply for the designs. In total, we have one landing page, with up to 10 other pages with a mix of content of text, images and videos, all of which will be supplied. Any further questions, please message through people per hour.

PL/SQL Expert for RTF Extraction from BLOB and to be transferred to HTML with ctx_doc

This is something we can easily do in TSQL on SQL Server but for which we don't have the PL/SQL on Oracle RAC expertise. The challenge: - A unicode table contains a BLOB field (not a CLOB) with encoded RTF text - We can get the RTF text by casting it to a varchar2 character but the problem this is that this variable is limited to 2000 characters in unicode - This would be a sample select that perfectly extracts the rtf string from the blob into multiple 2000 character varchar2 variables: select utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,1)) as DESCMF01, utl_raw.cast_to_varchar2(dbms_lob.substr(gdtxft,2000,2001)) as DESCMF02 from F00165 where GDTXKY = '128374|MN' - The idea would be to have a stored procedure that can extract the RTF in one go and transform it in HTML using the embedded ctx_doc library and would provide a full string with the HTML data. The RTF formatting is really basic only (2000 standard) so ctx_doc should be able to do this without a problem. So the deliverable should be the code to extract the full RTF data and do the transformation to HTML and return a full string with the html data. Please provide an estimate for this development.