query

[Former Member]

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

[Former Member]

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.

[Former Member]

hi

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 01.09.2007 MURUGU

2007 03.09.2007 MURUGU

2007 03.09.2007 MURUGU

2007 03.09.2007 SURESH

2007 05.09.2007 MURUGU

2007 16.10.2007 PURCHASE

2007 16.10.2007 PURCHASE

2007 16.10.2007 PURCHASE

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

[Former Member]

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.

[Former Member]

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

[Former Member]

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 .

[Former Member]

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