display one field below other in sqlserver

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

Latest Posts