1 Resources for

authority_id

Sponsored White Papers, Webcasts, and Downloads

How to write DISTINCT in sql's CASE ?,For that below query i am trying: SELECT DISTINCT TO_CHAR(creation_dt,'MM/DD/YYYY') "Date of Creation",first_names "First Name", surname "Last Name", Section_Name "SSO ID",(CASE WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADREV' THEN 'Reviewer'WHEN Authority_id = 'LEADRR' THEN 'Reconciler/Reviewer'WHEN Authority_id = 'LEADADMN' THEN 'Administrator'WHEN Authority_id = 'LEAD1' THEN 'Reconciler'WHEN Authority_id = 'LEADVIEW' THEN 'Browser' WHEN Authority_id = 'LEADCRE' THEN...; Tags: Authentication/Encryption, SQL, m_shamanth, Authority_id, LEAD1; Discussion threads 2007-08-31

Disaster Recovery Plan Power Checklist: Development of a disaster recovery plan is a must. Although there may never come a time when the plan must be implemented, it is always best to prepar ...; Buy Now

IT Hardware and Software Purchasing Policy: Your IT Budget is tight. You want to get the most bang for your IT buck. That's where the IT Hardware and Software Purchasing Policy can help.
Thi ...; Buy Now