how to write query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yoshitha - 19 Aug 2005 08:34 GMT

I have a table with the fileds empid,empname,designation,branch.. etc I
have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches
those are Hyderabad and Visakhapatnam i need the query like
first CEO name next Hyderabad BM Name next Hyderabad PL name next Hyderabad
Testername next Hyderabad Prg Names next Visakhapatnam BM name next
visakhapatnam PL name next Visakhapatnam TesterNames and Visakhapatnam Prg
Names......

Please help...me

Regards,
Krishna Murthy.K

Reply to this Message

Hilary Cotter - 19 Aug 2005 12:32 GMT

Please post this to microsoft.public.sqlserver.programming.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> I have a table with the fileds empid,empname,designation,branch.. etc I
> have 5 types of designations CEO,BM,PL,Tester,and PRG and the two branches
[quoted text clipped - 8 lines]
> Regards,
> Krishna Murthy.K

Reply to this Message