both views are in the same schema.

I didnt get you. Can u explain me in detail by taking an example.

Thanks.

Hi Matrix,

Thanks for the reply. Everything is installed alone in XP stand alone system. .net is working fine. IIS is working fine. I am able to run the reports...

i installed everything perfectly. My iis is working fine.

Thanks John and Ashok

Hi

Thanks for all the replies and suggestions. here is the query to get the required reuslt

SELECT c.customer

FROM #customer_master c

INNER JOIN

(

SELECT cl.customerid,COUNT(DISTINCT l.languagename) AS langcnt

FROM #customer_language cl

INNER JOIN #language_master...

Thanks for ur reply. is there any other better way to do this?

Hi,

I got the solution. create sp like

create PROCEDURE COMPLIANCE_TASK_DETAILS(@USR_ID INT, @OPERATION VARCHAR(10), @GET_ID INT = null,

@GET_TASK_NAME VARCHAR(300) = null, @GET_STATUS VARCHAR(100) = null,

@ASSIGNED_TO INT = null, @GET_COMMENTS VARCHAR(500) =...

I am facing the same problem every now and then. Did u find any solution for this? I just restarted my server then its all fine. Pls let me know...