Re: ON-BREAK questions

[Bryan Richey <brichey@MEDIAONE.NET>]

Could anybody tell me how to unsubscribe?

Jennifer Wagner 301-827-5467 FAX 301-594-6463 wrote:

> It's not like we've ever been trained.  They only have the users manual.
>  They've been doing this for years and started training me.  They
> weren't "trained" either.
>
> BTW, we've ordered a copy of that SQR for Peoplesoft and other Apps, so
> hopefully that will help us.
>
> I'm basically learning by reading old SQR programs.  Not the greatest
> way.  Does anyone know of other options for learning SQR?  Classes or
> anything?  I've looked on the net, but can't find any classes offered in
> it.
>
> jenny
>
> >That's pretty scary if the folks training you do that.  Perhaps you
> need to find better trainers!!
> >
> >-----Original Message-----
> >From: Jennifer Wagner 301-827-5467 FAX 301-594-6463
> >[mailto:WAGNERJ@CDER.FDA.GOV]
> >Sent: Friday, 13 August 1999 10:51 PM
> >To: Multiple recipients of list SQR-USERS
> >Subject: Re: ON-BREAK questions
> >Sensitivity: Confidential
> >
> >
> >Hey, I'm still learning!  That is what the folks training me always do
> >first...add distinct.  So, I assumed it was the thing to do.
> >
> >
> >>Adding distinct without considering why is definately NOT a good rule
> >of thumb!!
> >>More often than not it indicates a problem with your query if you are
> >getting duplicate rows where not expected.
> >>
> >>-----Original Message-----
> >>From: Jennifer Wagner 301-827-5467 FAX 301-594-6463
> >>[mailto:WAGNERJ@CDER.FDA.GOV]
> >>Sent: Friday, 13 August 1999 1:20 AM
> >>To: Multiple recipients of list SQR-USERS
> >>Subject: Re: ON-BREAK questions
> >>Sensitivity: Confidential
> >>
> >>
> >>Off the top of my head, the first thing I always do is add "distinct".
> >>That's probably not it, but it's a good rule of thumb.  :)
> >>
> >>>Good morning, SQRUG!
> >>>
> >>>I inherited an SQR to which I had to add a date variable.  The output
> >>is listing the date twice, and I'm sure it has something to do with
> >>ON-BREAK.
> >>>
> >>>Here's what I have:
> >>>
> >>>begin-select
> >>>Z_PROC_WE_DT        &Z_PROC_WE_DT2 () ON-BREAK Level=1
> >>!This is the line I added
> >>>Z_OFFICE_NBR        &NBR2       () ON-BREAK   Level=2 Print = Never
> >>After = Print-Payroll
> >>>Z_OFFICE_NBR        &OFFICE2
> >>>Z_PR_PROC_STATUS    &STATUS2
> >>>COUNT(*)            &COUNT2
> >>>FROM [$PS_TABLE]
> >>[$dyn_where]
> >>>[$dyn_where_dt]
> !I
> >>added this dynamic statement
> >>>GROUP BY  Z_OFFICE_NBR, Z_PR_PROC_STATUS, Z_PROC_WE_DT
> >>>end-select
> >>>
> >>>The report output:
> >>>
> >>>WE Date      Office       Ignore           Ready         Error
> >>Completed     Total
> >>>
> >>                 26-DEC-1997
> >>>26-DEC-1997   C0021            0               0             0
> >>     1          120-FEB-1998
> >>>20-FEB-1998   C0024            0               0             0
> >>     1          106-MAR-1998
> >>>06-MAR-1998   M0222            0               0             0
> >>     2          228-NOV-1997
> >>>28-NOV-1997   M8017            0               0             0
> >>     1          122-AUG-1997
> >>>22-AUG-1997   S0029            0               0             0
> >>     2          226-DEC-1997
> >>>26-DEC-1997   S0029            0               0             0
> >>     2          2
> >>>
> >>>              Table Totals     0               0             0
> >>     9          9
> >>>
> >>>Why am I getting the dates twice? and why is the first occurence of
> >the
> >>date pushing into the total column? is this a problem with my ON-BREAK
> >>logic, or column spacing, or.........?
> >>>
> >>>Thanks Much In Advance.
> >>>
> >>>~~ JEJ ~~   ;{)
> >>>
> >>>__________________________________________
> >>>$14.95 a month Unlimited Internet Access.
> >>>Get your first month for $1.00.
> >>>http://www.surfree.com/promo