SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DROP TABLE IF EXISTS dbo.EAV;
CREATE TABLE dbo.EAV
(
    AccountID integer NOT NULL,
    Property varchar(30) NOT NULL,
    Value sql_variant NULL
);
INSERT dbo.EAV
    (AccountID, Property, [Value])
VALUES
    (123456, 'Status', CONVERT(sql_variant, 'Active')),
    (123456, 'City', CONVERT(sql_variant, 'Los Angeles')),
    (123456, 'RegistrationDate', CONVERT(sql_variant, CONVERT(datetime, '2018-05-11 11:30:14.000', 121))),
    (543210, 'Status', CONVERT(sql_variant, 'Active')),
    (543210, 'City', CONVERT(sql_variant, 'Las Vegas')),
    (543210, 'RegistrationDate', CONVERT(sql_variant, CONVERT(datetime, '2018-05-11 11:13:14.000', 121))),
    (888888, 'Status', CONVERT(sql_variant, 'Inactive')),
    (888888, 'City', CONVERT(sql_variant, 'Toronto')),
    (888888, 'RegistrationDate', CONVERT(sql_variant, CONVERT(datetime, '2015-05-12 11:13:14.000', 121)));
9 rows affected

SELECT
    P.AccountID,
    P.[Status],
    P.City,
    P.RegistrationDate
FROM dbo.EAV AS E
PIVOT (MAX([Value]) 
    FOR Property IN 
    (
        [Status], 
        [City], 
        [RegistrationDate])
    ) AS P
WHERE 
    P.[Status] = CONVERT(sql_variant, 'Active')
    AND P.RegistrationDate = CONVERT(sql_variant, CONVERT(datetime, '2018-05-11 11:30:14.000', 121));


AccountID
Status
City
RegistrationDate


123456
Active
Los Angeles
11/05/2018 11:30:14