Загрузка данных


SELECT 
    sr.RequestID,
    sr.RequestTime,
    ru.UserName,
    ru.UserDomain,
    rt.RequestTypeName
FROM 
    [Service Request] AS sr
JOIN 
    [Request User] AS ru ON sr.RequestUserID = ru.RequestUserID
JOIN 
    [Request Type] AS rt ON sr.RequestTypeID = rt.RequestTypeID
WHERE 
    rt.RequestTypeName = 'AcquireLicense'
ORDER BY 
    sr.RequestTime DESC;