Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Repeat same row n times

3 posts in General Discussion Last posting was on 2009-02-23 01:24:49.0Z
Vladislav Posted on 2009-02-22 23:27:26.0Z
Reply-To: "Vladislav" <jitex@jitex.co.yu>
From: "Vladislav" <jitex@jitex.co.yu>
Newsgroups: ianywhere.public.general
Subject: Repeat same row n times
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-Rfc2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49a1df5e@forums-1-dub>
Date: 22 Feb 2009 15:27:26 -0800
X-Trace: forums-1-dub 1235345246 10.22.241.152 (22 Feb 2009 15:27:26 -0800)
X-Original-Trace: 22 Feb 2009 15:27:26 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7373
Article PK: 5790

How to repeat same row n times

Example:

Data:

2
3

Results:

2
2
3
3
3

Tnx


anil k goel [Sybase] Posted on 2009-02-23 00:37:04.0Z
From: "anil k goel [Sybase]" <anilgoel@nowhere.com>
Newsgroups: ianywhere.public.general
References: <49a1df5e@forums-1-dub>
Subject: Re: Repeat same row n times
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49a1efb0$1@forums-1-dub>
Date: 22 Feb 2009 16:37:04 -0800
X-Trace: forums-1-dub 1235349424 10.22.241.152 (22 Feb 2009 16:37:04 -0800)
X-Original-Trace: 22 Feb 2009 16:37:04 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7374
Article PK: 5791

select t1.* from t1,
lateral( select * from sa_rowgenerator( 1, t1.c1 ) ) as dt

-anil

"Vladislav" <jitex@jitex.co.yu> wrote in message
news:49a1df5e@forums-1-dub...
> How to repeat same row n times
>
> Example:
>
> Data:
>
> 2
> 3
>
> Results:
>
> 2
> 2
> 3
> 3
> 3
>
> Tnx
>
>


Vladislav Posted on 2009-02-23 01:24:49.0Z
Reply-To: "Vladislav" <jitex@jitex.co.yu>
From: "Vladislav" <jitex@jitex.co.yu>
Newsgroups: ianywhere.public.general
References: <49a1df5e@forums-1-dub> <49a1efb0$1@forums-1-dub>
Subject: Re: Repeat same row n times
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5512
X-Rfc2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49a1fae1$1@forums-1-dub>
Date: 22 Feb 2009 17:24:49 -0800
X-Trace: forums-1-dub 1235352289 10.22.241.152 (22 Feb 2009 17:24:49 -0800)
X-Original-Trace: 22 Feb 2009 17:24:49 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7375
Article PK: 5789

Thank you

"anil k goel [Sybase]" <anilgoel@nowhere.com> wrote in message
news:49a1efb0$1@forums-1-dub...
> select t1.* from t1,
> lateral( select * from sa_rowgenerator( 1, t1.c1 ) ) as dt
>
> -anil
>
> "Vladislav" <jitex@jitex.co.yu> wrote in message
> news:49a1df5e@forums-1-dub...
>> How to repeat same row n times
>>
>> Example:
>>
>> Data:
>>
>> 2
>> 3
>>
>> Results:
>>
>> 2
>> 2
>> 3
>> 3
>> 3
>>
>> Tnx
>>
>>
>
>
>