Dawn/Dennis, Thanks. I will get to work. Have a great weekend.
Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Fri, 19 Jun 2009 16:17:55 -0400 Subject: [RBASE-L] - Re: View Construct Nevermind...you need a view. I don't think you can CREATE VIEW.....CROSSTAB. Dennis' method works. Here's an example where I've used it to create a temporary view of some data by month.... CREATE TEMP VIEW vrawstock (jdecmpcd,boardname,jantons,febtons,+ martons,aprtons,maytons,juntons,jultons,augtons,septons,octtons,+ novtons,dectons) + AS SELECT T1.jdecmpcd,T2.wvtrim + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'01',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'02',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'03',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'04',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'05',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'06',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'07',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'08',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'09',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'10',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'11',T1.plantons,0)))), + (SUM((IFEQ((SGET(CTXT(T1.yyyymm),2,5)),'12',T1.plantons,0)))) + FROM dpplan T1, wvtrim T2 + WHERE (SGET(CTXT(T1.yyyymm),4,1)) = (CTXT(.vcurryr)) AND + T2.nomadpc = T1.nomadpc + GROUP BY T1.jdecmpcd,T2.wvtrim Dawn Hast [email protected] wrote on 06/19/2009 03:45:46 PM: > Group, > > I need to construct a view that compares actions by an employee > made last week to this week. So it's a single table view and > would look something like > > EmpName 06/09/2009 06/16/2009 Result > Joe Shmoe 1 1 > Snuffy Smith 1 1 2 > > I'm drawing a blank. > > Jan DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Evergreen Packaging is not responsible for any changes made to this message and / or any attachments after sending by Evergreen Packaging. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment.
