RE: [sqr-users] distinct and oracle hint is sqr

["Kent Schaetzly" <KSchaetzly@eprod.com>]

Specify the distinct on the BEGIN-SELECT line

BEGIN-SELECT DISTINCT

-----Original Message-----
From: sqr-users-bounces+kschaetzly=eprod.com@sqrug.org
[mailto:sqr-users-bounces+kschaetzly=eprod.com@sqrug.org]On Behalf Of
RHudgins@genencor.com
Sent: Monday, June 28, 2004 3:48 PM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: [sqr-users] distinct and oracle hint is sqr


I would like to do the following

begin-SELECT 
/*+ RULE */  distinct
p.company
p.paygroup

from ...

But sqr  formats it  like this and gives me an error -- invalid column -- 
because it concatenates the distinct and the first field.

SELECT /*+ RULE */  distinctp.company, p.paygroup, 


I get a error when i move the hint to the same line as the begin-select. 
Does anyone know how to make this work?  Or if it is possible.


  Thanks!

Rhonda Hudgins
@}---'----,----
Genencor International, Inc
office - 585/256-5266
rhudgins@genencor.com

--------------------------------------------------------------------------
This message (including any attachments) may contain information
which is confidential or privileged. Use, dissemination, distribution, 
or reproduction of this message by unintended recipients is not 
authorized and may be unlawful. If you are not the intended 
recipient, please advise the sender immediately by reply e-mail and 
delete this message and any attachments without retaining a copy.
--------------------------------------------------------------------------

_______________________________________________
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