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)

Queries

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-11 : 09:23:45

Thirumal writes "Dear Guru,
I have a employee table which will contain the address of the employee like per, res and com so for 1 employee there will be 3 records.when i write queries and copy it to excel it will look like this.

ecode  Name    Type   Add   Add1  city
1111    Mal     res    ddd   ddd  ddd
1111    Mal     per   eee   eee   eee
1111    Mal     com    fff   fff  fff

but my boss wants output as

ecode  Name    Type   Add   Add1  city
1111    Mal     res    ddd   ddd  ddd
                per   eee   eee   eee
                com    fff   fff  fff

can you please tell what we can we do?"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources