Hello,

This is my final query --

ALTER PROC STP_FILTER_TR_ACTIVITY

(

@JOBNAME NVARCHAR(4000) = NULL,

@PROJECTNUM NVARCHAR(200) = NULL,

@POSSTART INT = 0,

@COUNT INT = 50,

@TOTCOUNT INT OUT

)

AS

BEGIN

SET NOCOUNT ON;

...

Kingston Dhasian (5/7/2012)

---

Do you have any indexes on the "TR_Activity" table?

A clustered index on "ActivityId" will be helpfull

Also, you can try creating a clustered index in column "ROWNUM" in table...

thanx @Lowell problem is solved....

yes everything is ok from front end, does OUTPUT parameter works with Select statement?

my front end code:

SqlParameter param = new SqlParameter("@TOTALCOUNT", DbType.Int32);

...

No no I need total rowcount of Prodtable, not the selected one. But it's value is showing NULL from front end.