Position of Table Columns

#1

Dear All,

I want to get more than one table columns as a single column by
alternative.

For eg,

Table name = employee

columns = empid, empname, address1,address2

Here, I want to interpolate the address2 column on address1 as
mentioned below,

empid empname address1
address2

1 aaa First Layout,
CA, US.

Thanks in advance.

Thanks and Regards,
Ganapathi sundaram.G

#2

On Wed, 2 Jan 2008 01:31:21 -0800 (PST), Ganapathi sundaram
<ganapathysundarum (AT) gmail (DOT) com> wrote:

How about this:
select empid, empname, address1 + CHAR(13) + CHAR(10) + address2
from employee

-Tom.

Quote:

Dear All,

I want to get more than one table columns as a single column by
alternative.

For eg,

Table name = employee

columns = empid, empname, address1,address2

Here, I want to interpolate the address2 column on address1 as
mentioned below,

empid empname address1
address2

1 aaa First Layout,
CA, US.

Thanks in advance.

Thanks and Regards,
Ganapathi sundaram.G

#3

Quote:

I want to get more than one table columns as a single column by alternative.

Formatting is done in the front end in a tiered architecture, never in
the database. This is a basic programming concept and applies to more
than just SQL.

#4

On Jan 2, 2:31*pm, Ganapathi sundaram <ganapathysunda... (AT) gmail (DOT) com>
wrote:

Quote:

Dear All,

I want to get more than one table columns as a single column by
alternative.

For eg,

Table name = employee

columns = empid, empname, address1,address2

Here, I want to interpolate the address2 column on address1 as
mentioned below,

empid empname address1
* * * * * * * * * * * * * * *address2

1 * * * *aaa * * * * * *First Layout,
* * * * * * * * * * * * * * CA, US.

Thanks in advance.

Thanks and Regards,
Ganapathi sundaram.G

Where do you want to show data?
It seems you should use Reports

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Position of Table Columns

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Position of Table Columns - 01-02-2008 , 03:31 AM

Re: Position of Table Columns - 01-02-2008 , 08:32 AM

Re: Position of Table Columns - 01-02-2008 , 03:15 PM

Re: Position of Table Columns - 01-03-2008 , 07:36 AM