RE: [sqr-users] Subselect

[Peter Burton <Peter_Burton@Hyperion.com>]

Christopher,

What is the error message?

What database?

What version of SQR?

Peter

> -----Original Message-----
> From: sqr-users-bounces+peter_burton=hyperion.com@sqrug.org
> [mailto:sqr-users-bounces+peter_burton=hyperion.com@sqrug.org]
> On Behalf
> Of CAllo@hinda.com
> Sent: Wednesday, July 07, 2004 5:18 PM
> To: This list is for discussion about the SQR database reporting
> language from Hyperion Solutions.
> Subject: Re: [sqr-users] Subselect
> 
> 
> 
> 
> 
> 
> 
> Thanks a bunch.  I have tried it and it works as shown, however, the
> subselect I am trying to do is a "sum" and it looks like SQR 
> doesn't like
> that.
> i.e.
> begin-select
> A.DATE
> (select sum(amount) from TABLE_X where NAME = 'FRED') &ID
> 
> By the way, the reason I'm trying to do this is so that I can ORDER BY
> A.DATE, &ID.
> 
> I know I could call separate procedures to go and get this 
> information, but
> then I am not able to sort the data unless I build some sort 
> of temp table
> or views.  I  wanted to be able to just return everything I 
> need in this
> one select and sort accordingly and then print.
> 
> Any further thoughts?
> 
> Christopher Allo
> PeopleSoft Specialist
> x-3348
> 
> 
>                                                               
>              
>              "Larry Roux"                                     
>              
>              <lroux@syr.edu>                                  
>              
>              Sent by:                                         
>           To 
>              sqr-users-bounces         <sqr-users@sqrug.org>  
>              
>              +callo=hinda.com@                                
>           cc 
>              sqrug.org                                        
>              
>                                                               
>      Subject 
>                                        Re: [sqr-users] 
> Subselect           
>              07/07/2004 03:45                                 
>              
>              PM                                               
>              
>                                                               
>              
>                                                               
>              
>              Please respond to                                
>              
>              "This list is for                                
>              
>              discussion about                                 
>              
>              the SQR database                                 
>              
>                  reporting                                    
>              
>                language from                                  
>              
>                  Hyperion                                     
>              
>                 Solutions."                                   
>              
>              <sqr-users@sqrug.                                
>              
>                    org>                                       
>              
>                                                               
>              
>                                                               
>              
> 
> 
> 
> 
> Yes, just put a variable at the end of the subselect - ie
> 
> begin-select
> A.DATE
> (select ID from TABLE_X where NAME = 'FRED') &ID
> A.ADDRESS_LINE1
>    show ' Date = ' &A.DATE  ' ID = ' &ID
> from ADDRESSES A
> where A.ADDRESS_TYPE = 'HOME'
> end-select
> 
> 
> 
> 
> 
> 
> 
> 
> Larry Roux
> Syracuse University
> lroux@syr.edu
> 
> >>> CAllo@hinda.com 07/07/04 16:28 PM >>>
> 
> 
> 
> 
> I don't have very detailed information on the begin-select 
> construct and my
> question is as follows:  In SQL, you can do "subselects" like
> 
> SELECT
> Date,
> (Select total From Acct Where...),
> Name,
> ......
> FROM
> ......
> 
> 
> I am wondering if it is possible to accomplish something of 
> the sort in a
> begin-select paragraph?
> 
> Christopher Allo
> PeopleSoft Specialist
> x-3348
> This communication is for the exclusive use of addressee and 
> may contain
> confidential, proprietary or privileged information which may be used
> exclusively for its intended purpose. If you are not the intended
> recipient, any use, copying, disclosure, dissemination or 
> distribution is
> strictly prohibited.  If you are not the intended recipient, 
> please notify
> the sender immediately by return e-mail, delete this 
> communication, and
> destroy all copies.
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 
> This communication is for the exclusive use of addressee and 
> may contain
> confidential, proprietary or privileged information which may be used
> exclusively for its intended purpose. If you are not the intended
> recipient, any use, copying, disclosure, dissemination or 
> distribution is
> strictly prohibited.  If you are not the intended recipient, 
> please notify
> the sender immediately by return e-mail, delete this 
> communication, and
> destroy all copies.
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 
> 


************************************************************************

If you have received this e-mail in error, please delete it and notify the 
sender as soon as possible. The contents of this e-mail may be confidential and 
the unauthorized use, copying, or dissemination of it and any attachments to 
it, is prohibited. 

Internet communications are not secure and Hyperion does not, therefore, accept 
legal responsibility for the contents of this message nor for any damage caused 
by viruses.  The views expressed here do not necessarily represent those of 
Hyperion.

For more information about Hyperion, please visit our Web site at 
www.hyperion.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users