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.

How to simulate cross apply in ASE

3 posts in General Discussion Last posting was on 2012-01-05 08:44:22.0Z
kennedyc Posted on 2011-04-16 16:32:23.0Z
Sender: 4b5f.4da9c40e.1804289383@sybase.com
From: kennedyc
Newsgroups: sybase.public.ase.general
Subject: How to simulate cross apply in ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4da9c497.4b6c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Apr 2011 09:32:23 -0700
X-Trace: forums-1-dub 1302971543 10.22.241.41 (16 Apr 2011 09:32:23 -0700)
X-Original-Trace: 16 Apr 2011 09:32:23 -0700, 10.22.241.41
Lines: 4
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30113
Article PK: 79342

Hello,

Is anyone know how to simulate the SQL Anywhere cross apply
in ASE? Thanks.


"Paul Horan[Sybase]" Posted on 2011-04-20 12:11:46.0Z
From: "Paul Horan[Sybase]" <phoran AT sybase DOT com>
Newsgroups: sybase.public.ase.general
References: <4da9c497.4b6c.1681692777@sybase.com>
Subject: Re: How to simulate cross apply in ASE
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4daecd82$1@forums-1-dub>
Date: 20 Apr 2011 05:11:46 -0700
X-Trace: forums-1-dub 1303301506 10.22.241.152 (20 Apr 2011 05:11:46 -0700)
X-Original-Trace: 20 Apr 2011 05:11:46 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30129
Article PK: 79358

I've been a SQL Anywhere guy for almost 15 years, and I'd never heard of
that enhancement...
http://iablog.sybase.com/paulley/2008/07/cross-and-outer-apply/

I suppose this could be done with derived tables...

--
Paul Horan[Sybase]
http://paulhoran.ulitzer.com

<kennedyc> wrote in message news:4da9c497.4b6c.1681692777@sybase.com...
> Hello,
>
> Is anyone know how to simulate the SQL Anywhere cross apply
> in ASE? Thanks.