SQL Queries - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL Queries

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-18 : 18:33:30

Sanjeev Shrestha writes "Table EmpRecords

------------------------------------- 
select TranId,EmpId,[20],[25],[24],[31] from EmpRecords
--------------------------------------
TranId               EmpId                20    25    24    31
-------------------- -------------------- ----- ----- ----- ----- 
1                    0301                 LO    NULL  NULL  NULL
2                    0301                 NULL  SL    NULL  NULL
3                    0301                 NULL  NULL  LO    NULL
4                    0301                 NULL  NULL  NULL  LI

(4 row(s) affected)
I want the following result :
EmpId                  20    25   24    30
--------------------  ----   ---  ----  ------
0301                   LO    SL   LO    LI

How to do this ? Pls help me
Sanjeev"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources