display one field below other in sqlserver

Posted by Klbaiju under Sql Server on 10/17/2013 | Points: 10 | Views : 669 | Status : [Member] | Replies : 1
Hi,

I want to display 2 fields below other

I tried this query

select city +'\n'+ region as details from employee.but this is not working

the out put should be like this

1 New York

W
2 Vancouver

N

Regards

B?aiju




Responses

Posted by: Nismeh on: 10/18/2013 [Member] Starter | Points: 25

Up
0
Down
Hey,

I am not getting exact requirement. But as per my understanding you want output in non-tabular format. For this kind of this you can use StoredProcedures. This is best option for this.

If I am wrong in my understanding than plz suggest your exact requirement which could lead me to show you exact path.

IT KNOWLEDGE IS APPLIED KNOWLEDGE
So Just Do It

Klbaiju, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response