SHOW:
|
|
- or go back to the newest paste.
| 1 | --Prikazati administratorima glavne informacije top10 zaposlenika koji su najvise vremena proveli na bolovanju, te im dodjeliti privatne mail adrese za laksu komunikaciju sa zaposlenicima | |
| 2 | ||
| 3 | USE AdventureWorks2012 | |
| 4 | SELECT TOP 10 WITH TIES SUBSTRING(E.LoginID,CHARINDEX('\',E.LoginID)+1,20) 'Login', PW.PasswordSalt'Secure password',PE.EmailAddress'Email',
| |
| 5 | LOWER(P.FirstName+SUBSTRING(CONVERT(NVARCHAR,YEAR(E.BirthDate)),3,2)+'@'+LEFT(E.JobTitle,1)+SUBSTRING(E.JobTitle,CHARINDEX(' ',E.JobTitle)+1,1)+'.fit.ba') AS 'Private mail',
| |
| 6 | DATEDIFF(YEAR,E.BirthDate,E.HireDate)'Starost kada se zaposlio', DATEDIFF(YEAR,E.BirthDate,GETDATE())'Starost' | |
| 7 | FROM [HumanResources].[Employee] AS E | |
| 8 | JOIN [Person].[Person] AS P ON E.BusinessEntityID = P.BusinessEntityID | |
| 9 | JOIN [Person].[Password] AS PW ON P.BusinessEntityID=PW.BusinessEntityID | |
| 10 | JOIN [Person].[EmailAddress] AS PE ON P.BusinessEntityID=PE.BusinessEntityID | |
| 11 | ORDER BY E.SickLeaveHours DESC |
