Select Row with column name

[User 4005525]

Hi I've a Table Table1.And it's structure is RoleID RoleDescription Department 1 Manager Accounts 2 Senior Manager Finance and I want to have a Table like Columnname Columnvalue Date RoleID 1 2/5/2008 RoleDescription Manager 2/5/2008 Department Accounts 2/5/2008 RoleID 2 2/5/2008 RoleDescription Senior Manager 2/5/2008 Department Finance 2/5/2008 Can anyone tell how? thanks in advance Sri

[Vimalsoft Pty Ltd]

I realy dont understand what you just asked

Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za