Advertisement
asifior

CommonAuthorizationQuery

Sep 16th, 2014
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1.           SELECT COUNT(PERSONALE.COGNOME)
  2.           FROM [Common].[dbo].[PersonalePlusFull] PERSONALE,
  3.           [Common].[dbo].[AccountRete] ACCOUNT,
  4.           [Common].[dbo].[MetaProcessoSediAnalitiche] SEDI
  5.           WHERE PERSONALE.MATRANAG = ACCOUNT.Matricola
  6.           AND PERSONALE.SEDEATTUALE = SEDI.Codice6
  7.           AND LOWER(ACCOUNT.Dominio) = '{0}'
  8.           AND LOWER(ACCOUNT.Account) = '{1}'
  9.           AND UPPER(PROFILO) IN ('MV', 'LV', 'IV', 'HV', 'GV', '7V')
  10.           AND DATACESS IS NULL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement