I have this query:

```
declare @tab1 table (
    descrizione varchar(50),
    c_prodotto char(5),
)

insert into @tabRiepilogoProvvigioniBanca (descrizione, c_prodotto)
select c_prodotto, descrizione
from Maintable

```

The result of this query return 2 records.

Then i want to print them :

```
select  @riga   = ''

select  @riga   = @riga + substring( ltrim(rtrim( c_prodotto)) + space(10), 1, 10)
from @tab1
select  @riga   = @riga + ' ' + substring(ltrim(rtrim(ISNULL( descrizione,0))) + space(50), 1, 15) 
from @tab1

select @riga

```

The result is :

```
PVDTR PVTDC    0 0

```

I want to know if is it possible to have a result like this :

```
PVDTR   0
PVTDC   0

```