topic Re: query in Application Development and Automation Discussions

query

Former Member — Wed, 12 Mar 2008 09:48:19 GMT

Dear All

Select Count ( * ) CREATEDBY into (cstyle-count, cstyle-CREATEDBY) from ZMM_STYLE_MAST

where

ZMM_STYLE_MAST~CREATEDBY in u_uname and

ZMM_STYLE_MAST_{CREATIONDATE in u_date GROUP BY ZMM_STYLE_MAST}CREATEDBY .

The above query not working

Pls any one help he

Thanks and regards

Suresh

Re: query

Former Member — Wed, 12 Mar 2008 09:51:40 GMT

Hi,

count * will give u the number of record that satisfy the condition in where clause.

for count:


Select Count ( * ) into cstyle-count from ZMM_STYLE_MAST
where
ZMM_STYLE_MAST~CREATEDBY in u_uname and
ZMM_STYLE_MAST~CREATIONDATE in u_date GROUP BY ZMM_STYLE_MAST~CREATEDBY .

for createdby value:


Select single CREATEDBY into cstyle-CREATEDBY from ZMM_STYLE_MAST
where
ZMM_STYLE_MAST~CREATEDBY in u_uname and
ZMM_STYLE_MAST~CREATIONDATE in u_date GROUP BY ZMM_STYLE_MAST~CREATEDBY .

rgds,

bharat.

Re: query

Former Member — Wed, 12 Mar 2008 09:58:20 GMT

Thanks for your reply

2007 27.08.2007 SEETHA

2007 28.08.2007 SEETHA

2007 31.08.2007 SEETHA

2007 31.08.2007 MURUGU

2007 01.09.2007 MURUGU

2007 03.09.2007 MURUGU

2007 03.09.2007 SURESH

2007 05.09.2007 MURUGU

2007 16.10.2007 PURCHASE

The above is output now i want how many records each user performed

Re: query

Former Member — Wed, 12 Mar 2008 10:00:08 GMT

Hi ,

Select Count ( * ) CREATEDBY

into table cstyle from ZMM_STYLE_MAST*

where

ZMM_STYLE_MAST~CREATEDBY in u_uname and

ZMM_STYLE_MAST~CREATIONDATE in u_date GROUP BY ZMM_STYLE_MAST~CREATEDBY .

( or )

Select Count ( * ) CREATEDBY

into (cstyle-count, cstyle-CREATEDBY) from ZMM_STYLE_MAST

where

ZMM_STYLE_MAST~CREATEDBY

= * u_uname and

ZMM_STYLE_MAST~CREATIONDATE

= * u_date.

awrd points if useful

Bhupal

Re: query

Former Member — Wed, 12 Mar 2008 10:02:34 GMT

Hi,

select all the values first into an internal table say itab.

then do like this.


data:counter(3).

sort itab by createdby.

loop at itab.
at new createdby.
clear counter.
endat.
counter = counter + 1.
at end of createdby.
  write:/ counter,itab-createdby.
endat.
endloop.

rgds,

bharat.

Re: query

Former Member — Wed, 12 Mar 2008 10:05:48 GMT

Hi,

Now check by keeping space at *

Select Count ( * ) CREATEDBY into (cstyle-count, cstyle-CREATEDBY)

from ZMM_STYLE_MAST

where ZMM_STYLE_MAST~CREATEDBY in u_uname and

ZMM_STYLE_MAST~CREATIONDATE in u_date

GROUP BY ZMM_STYLE_MAST~CREATEDBY .

Re: query

Former Member — Wed, 12 Mar 2008 10:43:37 GMT

Hi ,

Select Count ( * ) CREATEDBY

into table cstyle from ZMM_STYLE_MAST

where

ZMM_STYLE_MAST~CREATEDBY in u_uname and

ZMM_STYLE_MAST~CREATIONDATE in u_date GROUP BY ZMM_STYLE_MAST~CREATEDBY .

( or )

Select Count ( * ) CREATEDBY

into (cstyle-count, cstyle-CREATEDBY) from ZMM_STYLE_MAST

where

ZMM_STYLE_MAST~CREATEDBY

= u_uname and

ZMM_STYLE_MAST~CREATIONDATE

= u_date.

awrd points if useful

Bhupal