Thursday, 2 January 2020

SQL Key-Value Paired Join

SELECT * FROM Tabe1 u
JOIN (
(123, 'peter6@gmail.com', 3),
(555, 'jbrown@gmail.com', 4),
(946, 'jdoe12@gmail.com', 1)
) v(EmployeeId, Email, Department)
ON (
v.Email = u.Email
and v.EmployeeId = u.EmployeeId
)


No comments:

Connect PowerBI to SQL Server - TrustServerCertificate

Under the server that Power BI installed,  Go to System Properties -> Advanced -> Environment Variables  Add this Variable Name PBI_S...