thnks a lot.

thnks it works.

thanks a lot. its working now.

i am just passing null to @WhereConditions.

i am executing the Sp just right-clicking the procedure and execute inside VS2005.

yes u r right its working but when i add @WhereConditions then it does not work.

.............................

declare @sql nvarchar(400);

declare @test-2 int;

set @sql = 'Select @count = Count(*) From classifieds_Ads

Where AdStatus=100 '...

still not working. return @NewClassifiedsCount = 0

Still not working. @NewClassifiedsCount is 0 always

..............................................................

ALTER PROCEDURE dbo.SP_NewClassifiedsMain

@PageIndex INT,

@NumRows INT,

@NewClassifiedsCount INT OUTPUT,

@WhereConditions varchar(200)

AS

BEGIN

declare @sql nvarchar(400);

declare @test-2 int;

set @sql = 'Select @test-2 = Count(*) From classifieds_Ads

Where AdStatus=100 ' + @WhereConditions

exec...