"Alejandro Mesa" <AlejandroMesa@discussions.microsoft.com> wrote in message
news:0F85CA46-881D-428A-88EB-47797706F3CB@microsoft.com...
> Peri,
>
> SHAPE is not part of t-sql.
>
>
> AMB
>
>
> "Peri" wrote:
>
> > Dear All,
> >
> > There is a shape command in sql server with the following example
> >
> > SHAPE {SELECT au_id, au_lname, au_fname FROM authors}
> > APPEND ({SELECT au_id, title FROM titleauthor TA, titles TS
> > WHERE TA.title_id = TS.title_id}
> > AS title_chap RELATE au_id TO au_id)
> >
> > Can you please help me to add one more child set to this ?
> >
> > Say:
> >
> > strSh = " SHAPE {SELECT CurrencyCode FROM VDCurrency} AS VDCurrency " &
_
> > " APPEND ({SELECT CurrencyCode, ZoneCode FROM VDCurrencyZone} AS
> > VDCurrencyZone " & _
> > " RELATE CurrencyCode TO CurrencyCode) AS VDCurrencyZone " & _
> > " APPEND ({SELECT CurrencyCode, ZoneCode, BucketCode FROM
> > VDCurrencyBucket} AS VDCurrencyBucket " & _
> > " RELATE ZoneCode TO ZoneCode) AS VDCurrencyBucket "
> >
> > Table VDCurrency has CurrencyCode, Table VDCurrencyZone has CurrencyCode
and
> > Zone Code and Table VDCurrencyBucket has CurrencyCode, Zone Code and
Bucket
> > Code.
> >
> > The code is working for (one child set only) :
> >
> > strSh = " SHAPE {SELECT CurrencyCode FROM VDCurrency} AS VDCurrency " &
_
> > " APPEND ({SELECT CurrencyCode, ZoneCode FROM VDCurrencyZone} AS
> > VDCurrencyZone " & _
> > " RELATE CurrencyCode TO CurrencyCode) AS VDCurrencyZone "
> >
> > can anyone please help me out ?
> >
> > Regards,
> >
> > Peri
> >
> >
> >
> >