> Hi Adam,
>
> Thanks for yours very fast reply!
>
> But I need this function for a printing a stickers, sometime a qty
> number can be very very large and this is a main reaso why I would
> like to just pass some SQL script and get a resultset that I need!
> Yours idea is a great, but how can I do this on client to spare
> network traffic and to be more eficient in n-tier setup?
>

That really depends on your development language and probably your
reporting engine. Some reporting engines are probably clever enough
to do this sort of transformation.

For example, if you had the record

1, 'Article 1', 10

Then that is significantly less traffic then

1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'
1, 'Article 1'

(and that is just 10, image a big number).

It is not really rocket science.

Of course most transport mechanisms do on the fly compression and
highly repetitive streams tend to compress quite well, but still it
is a silly idea to expand on the database server then send it to a
remote box.

If you use Delphi, then you could use a ClientDataset and parse the
resultset as you receive it (also assuming the reporting engine is
dataset driven).

You need to analyse whether it is worth your while to do this,
perhaps do some performance tests on having the database server
expanding it under different scenarios and work out whether the
difference is important enough.

Adam