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] = ???;

Database Administration SQL

Project ID: #15980671

About the project