Database

CASE 
    WHEN SecurityLevel = 1 THEN 'Administrator'
    WHEN SecurityLevel = 2 THEN 'Supervisior'
    ELSE 'User'
END As SecurityLevel,

nauty wrote:

1. not able to see the "OracleClient" namespace after the "system.Data ".How can i get it.

nauty wrote:

2. if I want to get connected through Oledb. how can i do that.

SELECT SupplierID, NameOrCompany, IsLocal
  FROM
   (
    SELECT SupplierID
           , LastName + ', ' + FirstName AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=false
    UNION ALL
    SELECT SupplierID
           , Company AS NameOrCompany
           , IsLocal 
      FROM Suppliers 
     WHERE IsLocal=true
    ) x
 ORDER BY NameOrCompany

Select a.username as User, b.domainname as Domain, a.MaxDT as Date
  From 
   (
    Select username, Max(dt) as MaxDT
      From testtable
     Group By username
   ) a INNER JOIN testtable b ON a.username=b.username AND a.MaxDT = b.dt

select ID, M_ID, S_ID, min(Date)
from t
group by ID, M_ID, S_ID

select tt.userid, tt.domain, tt.date
  from ( select m.userid, max(m.domain)
           from testtable m
          group by m.userid
       ) tmp
      , testtable tt
 where tt.userid = tmp.userid
   and tt.domain = tmp.domain
;