Completed

MS SQL Script - combine data from two tables to a new view / table

Awarded to:

MDeacon3

CREATE VIEW MyView AS SELECT [login to view URL], [login to view URL], [login to view URL], [login to view URL], [login to view URL] from MSGITEM i left join MSBPROPERTY p1 on p.MSGITEM_FK = i.MSGITEM_ID and [login to view URL] = 1 as 'Name More

€8 EUR in 1 day
(8 Reviews)
3.9

21 freelancers are bidding on average €31 for this job

sumon355

Hello, As an expert in writing complex sql queries, i am very much interested to write the required query to generate the view. I understand what you need, so you can award me and get the work done. Thanks

€28 EUR in 1 day
(171 Reviews)
7.2
BitSDestiny

I'd like to work with you on the project,Having 9+ Years of Experience as a Software Developer, successfully completed many projects (please see my reviews). Experienced in ASP.Net, C#, VB.Net, MVC, WPF, Visual Basi More

€50 EUR in 1 day
(32 Reviews)
5.0
murtaza1981

Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please feel free to discuss the project with me so that I can wrap More

€30 EUR in 1 day
(2 Reviews)
4.0
bnrajumnc

A proposal has not yet been provided

€55 EUR in 3 days
(9 Reviews)
3.6
supergana

Very simple stuff. I can do it in within an hour. If i am not able to accomplish it you do not have to pay.

€23 EUR in 1 day
(6 Reviews)
3.2
CyberLeafSol

Hello there, After reading your provided requirements. I found you need queries based on joins as you have small schema of relational database. Lets chat to accomplish in few hours.

€34 EUR in 1 day
(3 Reviews)
3.2
€34 EUR in 1 day
(4 Reviews)
3.0
mahmoud87hassan1

I am an experienced developer with close to 5 years experience in ASP.NET MVC and Web Forms,Web API work in the present. I also have a wealth of experience developing for a dynamic and responsive client side using adv More

€23 EUR in 2 days
(2 Reviews)
2.9
AndreyBarykin

Have big experience as Senior Database Developer/DBA. Expert in MS SQL. I Know well T-SQL, make queries of any complexity. I already know how to solve your task.

€14 EUR in 1 day
(4 Reviews)
2.7
katiewells3

The output for this view looks like it would be easily achievable with a pivot on PROPERTYTYPE / PROPERTYVALUE to bring the property values into separate columns then joining the two with some aggregation I am not s More

€29 EUR in 1 day
(3 Reviews)
1.7
€30 EUR in 1 day
(1 Review)
0.6
daisoftware123

Hi, I have gone through your REQUIREMENT. I can help you in this as I have much EXPERIENCE in Asp.net, C#, MVC, JSON Web services , ATOM Web services. Can we discuss the REQUIREMENT in detail? We work on dif More

€50 EUR in 3 days
(0 Reviews)
0.0
vermadeepak77

Hi, I am good in SQL and I already have the work sample ready with me, let me know when we can chat to share this sample Thanks Deepak

€30 EUR in 1 day
(0 Reviews)
0.0
spnandi

This query needs rows to column transposition to get the properties of the messages. Can get you delivered in one day.

€111 EUR in 1 day
(0 Reviews)
0.0
soltecke

Regards!, We are dedicated to implementing solutions in data mining, data science and business intelligence. We are also dedicated to the development of systems for SMEs. All at a low cost. Using tools such as: VBA More

€24 EUR in 2 days
(0 Reviews)
0.0
TodorCH

Hi i'm skilfull programer and i need this job to gain my reputation here. Hit me up for more details. hope we will cooperate:)

€8 EUR in 1 day
(0 Reviews)
0.0
€14 EUR in 1 day
(0 Reviews)
0.0
Eshmealpablo

Typical Skillsfor a SQL programmer include: Reviewing query performance and optimizing code Writing queries used for front-end applications (websites, desktop applications, or cloud apps) Designing and coding databa More

€23 EUR in 1 day
(0 Reviews)
0.0
rarruda1988

I am a Business Intelligence consultant, my role is to transform data into relevant information and display it in reports or Dashboards, so after creating the view I can generate reports also if you want. I am availab More

€12 EUR in 1 day
(0 Reviews)
0.0
€30 EUR in 1 day
(0 Reviews)
0.0