Completed

Update View to Include EAV Table as Columns

I have a view that returns the Non-EAV base values for an entity. I need this view modified so that additional columns and values are added based on an EAV table. Looking for someone available to update the view now. A full DB schema can be provided if necessary.

View to Update:

ALTER VIEW [dbo].[OrganizationConnections]

AS

SELECT

[url removed, login to view],

COALESCE(NULLIF([url removed, login to view],''), [url removed, login to view]) as OrganizationName,

[url removed, login to view] as OrganizationCode,

[url removed, login to view] as OrganizationNotes,

[url removed, login to view] as CategoryName,

[url removed, login to view] as CategoryDescription,

[url removed, login to view] as ConnectionTypeName,

[url removed, login to view] as ConnectionTypeDescription,

[url removed, login to view] as Protocol,

[url removed, login to view] as ConnectionGroupName,

[url removed, login to view] as ConnectionGroupDescription,

[url removed, login to view] as ConnectionName,

[url removed, login to view] as ConnectionDescription,

[url removed, login to view] as ConnectionNotes,

[url removed, login to view] as ConnectionURI,

[url removed, login to view],

[url removed, login to view]

FROM

Connections

INNER JOIN ConnectionTypes ON [url removed, login to view] = [url removed, login to view]

INNER JOIN ConnectionGroups ON [url removed, login to view] = [url removed, login to view]

INNER JOIN Categories ON [url removed, login to view] = [url removed, login to view]

INNER JOIN ConnectionProtocols ON [url removed, login to view] = [url removed, login to view]

LEFT OUTER JOIN PrimaryConnectionCredentials ON [url removed, login to view] = [url removed, login to view]

LEFT OUTER JOIN Credentials ON [url removed, login to view] = [url removed, login to view]

INNER JOIN Organizations ON [url removed, login to view] = [url removed, login to view]

Query to identify additional columns and values (EAV):

SELECT

[url removed, login to view] ColumnName,

[url removed, login to view] ColumnValue

FROM

ConnectionProperties

INNER JOIN PropertyNames ON [url removed, login to view] = [url removed, login to view]

INNER JOIN PropertyTypes ON [url removed, login to view] = [url removed, login to view]

WHERE

[url removed, login to view] = ???;

--Query to identify additional columns and values (EAV table lookup)

SELECT

[url removed, login to view] ColumnName,

[url removed, login to view] ColumnValue

FROM

ConnectionProperties

INNER JOIN PropertyNames ON [url removed, login to view] = [url removed, login to view]

INNER JOIN PropertyTypes ON [url removed, login to view] = [url removed, login to view]

WHERE

[url removed, login to view] = ???;

Skills: Database Administration, SQL

See more: cakephp progressive update view, freeze table columns, freeze html table columns, loop table columns php, mysql loop table columns, drag drop table columns javascript, using php loop table columns, php looping trough table columns, access update query slow odbc table, richtexbox table columns, create table columns csv file using php, create table columns csv files, create table columns csv file, loop mysql table columns, update radio button status table using php

About the Employer:
( 4 reviews ) Walton, United States

Project ID: #15980671

Awarded to:

sunbrek

I will require the schema to properly update your view. I'm an Informatics Engineer. C# (.NET), C++, Java Tutor at College and Unity3D (C#) Game Developer I have worked for many software development firms under int More

$30 USD in 1 day
(0 Reviews)
0.0

2 freelancers are bidding on average $28 for this job

ahmetgorunucu

I'm 2 years experienced Database Admin. I believe I can do it now. ..................................

$25 USD in 1 day
(0 Reviews)
0.0