James Create a temorary view and use it. CREATE TEMPORARY VIEW myview (ch1_date,HowMany) AS SELECT + ch1_date, COUNT(*) FROM change1 + WHE CH1_SCHEDULE = 185 GROUP BY ch1_date
CHOOSE var_date FROM #VALUES FOR + (CTXT(ch1_date)) & (CTXT(HowMany))),ch1_date + FROM myview Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Hageman Sent: Friday, September 30, 2005 2:37 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Show a count(*) in a CHOOSE I would like to use a CHOOSE to get distinct dates from a dataset and tell me how many events are for a date in the CHOOSE is this possible. I want to take this select and put it in a CHOOSE command. SELECT ch1_date, COUNT(*) FROM CHANGE1 WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE ch1_date COUNT (*) ---------- ---------- 05/03/1993 11 05/10/1994 6 05/04/1995 5 05/07/1996 2 01/31/1997 1 05/12/1997 6 01/06/1999 1 05/07/1999 6 02/24/2000 1 04/13/2000 12 07/10/2001 3 04/29/2002 1 04/21/2003 2 05/25/2005 1 Something like : CHOOSE var_date FROM #VALUES FOR ch1_date, COUNT(*) FROM CHANGE1 + WHERE CH1_SCHEDULE = 185 GROUP BY CH1_DATE ???
