468,540 Members | 1,722 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,540 developers. It's quick & easy.

To get the column names based on value

I have Employee table
Eg:
Fn Ln Eid EmpOrgStr MngrOrgStr
a a a1 a1 b1
b b b1 b1
c c c1 c1 b1
d d d1 d1 b1

when i use select query i should get the result as below
Fn Ln Eid EmpOrgStr MngrOrgStr MnFn MnLn
a a a1 a1 b1 a a
b b b1 b1
c c c1 c1 b1 a a
d d d1 d1 b1 a a
Nov 18 '11 #1
1 1474
Rabbit
12,513 Expert Mod 8TB
I have no idea how you derived those two columns.
Nov 18 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Joe Gazda | last post: by
3 posts views Thread by Michael Gruner | last post: by
1 post views Thread by christianlott1 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.