RE: [sqr-users] Subselect

["Knapp, Richard" <KnappR@umsystem.edu>]

Just write your sql and enclose the entire paragraph in
begin-(select)/end-select and that in begin-procedure/end-procedure.
Call this procedure from a begin-program procedure.

If it's bonafide SQL, it should work in SQR.  Sometimes it is simpler to
do the work of a subquery in another paragraph that you call from within
the original select:

Begin-select
A    &a_var
B    &b_var
C    &c_var

    do the_other_procedure

From some_table
Where something = somethingelse and
      etc....
End-select

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu
 

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
CAllo@hinda.com
Sent: Wednesday, July 07, 2004 3:56 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: RE: [sqr-users] Subselect






Do you have an example of how this would be accomplished?  I greatly
appreciate your help.




 

             "Knapp, Richard"

             <KnappR@umsystem.

             edu>
To 
             Sent by:                  "This list is for discussion
about  
             sqr-users-bounces         the SQR database
reportinglanguage  
             +callo=hinda.com@         from   Hyperion Solutions."

             sqrug.org                 <sqr-users@sqrug.org>

 
cc 
 

             07/07/2004 03:34
Subject 
             PM                        RE: [sqr-users] Subselect

 

 

             Please respond to

             "This list is for

             discussion about

             the SQR database

                 reporting

               language from

                 Hyperion

                Solutions."

             <sqr-users@sqrug.

                   org>

 

 






Yup.

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
CAllo@hinda.com
Sent: Wednesday, July 07, 2004 3:25 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Subselect





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

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