1 Resources for

lead1

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

Quick Reference: PC Troubleshooting Pack: Help desk and IT support professionals need the fastest and most complete answers to keep every PC in action. Get the PC troubleshooting solutions you ...; Buy Now

Microsoft Word Crash Course: This pre-packaged presentation contains everything you need to instruct end users about how to get the most out of Microsoft Word -- even if you don't consider yourself a public speaker.; Buy Now