Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(PERSONALE.COGNOME)
- FROM [Common].[dbo].[PersonalePlusFull] PERSONALE,
- [Common].[dbo].[AccountRete] ACCOUNT,
- [Common].[dbo].[MetaProcessoSediAnalitiche] SEDI
- WHERE PERSONALE.MATRANAG = ACCOUNT.Matricola
- AND PERSONALE.SEDEATTUALE = SEDI.Codice6
- AND LOWER(ACCOUNT.Dominio) = '{0}'
- AND LOWER(ACCOUNT.Account) = '{1}'
- AND UPPER(PROFILO) IN ('MV', 'LV', 'IV', 'HV', 'GV', '7V')
- AND DATACESS IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement