Thank u very much wz700 and Jeff for ur posts.

i finally decided to use Jeff's suggestion.

You guys r very helpful

Thank u very much for ur posts.

I finally did backup of develop server and i created a database in production server with same name as  develop server.

and did restore on...

Thank u very much friends

i'll change my query

Rajani

Thanks Jeff

i finally did like

SELECT * FROM DBO.pt_vCheckSupport

 WHERE CAST(CONVERT(VARCHAR(11), DBO.pt_vCheckSupport.supp_startdt, 101) AS DATETIME)>= '07-MAR-2004'

 AND CAST(CONVERT(VARCHAR(11), supp_startdt, 101) AS DATETIME)<='19-MAR-2004'

Hi friend

Just to add to abv

the abv query returns something like

Micrsosft,bugs,10,8,2

IBM,finance,22,0,22

IBM,fixes,1,1,0

now how do i get total no of tasks of a client in another col

i mean if u take...

Hi guys

i've added few conditions to abv query and have small doubt

i have some data like

Master     Type Starttime            

AWrPsfQDm7 CS   18/02/2003 11:00:00 AM

AWrPsfQDm7 IC   20/03/2003 12:00:00 PM

when i run following...

small correction.

sele master,sum(iif(upper(type)="AVAIL",1,0)) as AvailN,;

 sum(iif(upper(type)="OPER",1,0)) as OperN ;

 group by 1 from booking ;

 where upper(type)="AVAIL" or upper(type)="OPER" ;

 having AvailN>0 and OperN>0 into cursor curTemp

sele master,type from booking where (upper(type)="AVAIL" or...

Thank u so much for ur posts

Hi friends

i got it.i tried like

sele master,sum(iif(upper(type)="AVAIL",1,0)) as AvailN,;

 sum(iif(upper(type)="OPER",1,0)) as OperN ;

 group by 1 from booking ;

 where upper(type)="AVAIL" or upper(type)="OPER" ;

 having AvailN>0 and AvailN=OperN into cursor curTemp nowait

sele master,type from...

Hi Antares686

i tried like following .here ; is line continuation

SELECT x1.master, x1.type FROM BOOKING x1 ;

INNER JOIN (SELECT x2.master,x2.type t1,x3.type t2 FROM ...

i cannot use following query bcoz

select a.* from test a  where exists(select * from test b where type = 'Avail' and a.master=b.master)  and exists(select * from test c where type='oper'and...

Hi friend

I tried ur query in foxpro 8 it return syntax error

Thanks for query Antares686

can u explain me what's u r doing query plz.

Thanks

sorry abv 1210 has type "Oper" only

i wrongly typed two different values.

now 1210 should not b listed.

i want only master records that r type "Avail" and "Oper"

Thanks