MS SQL Server MSEQ - how to write query

Author

how to write query

Yoshitha

2005-08-19, 3:23 am

I have a table with the fileds empid,empname,design
ation,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

Hugo Kornelis

2005-08-19, 8:24 pm

On Fri, 19 Aug 2005 13:04:04 +0530, Yoshitha wrote:

>I have a table with the fileds empid,empname,design
ation,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

Hi Krishna,

I would, if I understood what exactly you want.

Narrative is often not the best way to describe a problem. Especially if
neither the one describing, nor the one trying to understand, has
English as native language. :-)

A much better way to describe a problem in these group is to post:
* CREATE TABLE statements to describe exactly how your tables look. If
there are many irrelevant columns, just omit them. But do include all
constraints and properies for remaining columns!
* INSERT statements to load the tables with a few chosen rows of sample
data that accurately describe your problem.
* Expected output.
* And a short description of the business problem you're trying to
solve.

Check out www.aspfaq.com/5006 - it has some useful tools that might help
you assemble the information needed faster.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)

Sponsored Links