okay thanks everyone

good karma to you all thanks for taking the time top answer..

I'm having trouble with the syntax when I try to add this to my query:

SELECT Count('x') FROM PayeeMaster PM

INNER JOIN PayeeLink PL ON...

anway to get the count in the above query without using 'count'?

thank you

cool..thanks

That worked as far as accepting the altered proc...but when I go to run I get an error-

this is what...

We are having trouble with the syntax -

When I change it to what you suggested I get an error:

Msg 102, Level 15, State 1, Procedure spPaymentViewGetPagedByUserId, Line 79

Incorrect syntax near...

sure..

exec spPaymentViewGetPagedByUserId @PageIndex=0, @PageSize=25, @PaymentStatus='P, VR, AM'

USE [dbVBank]

GO

/****** Object: StoredProcedure [dbo].[spPaymentViewGetPagedByUserId] Script Date: 07/14/2011 10:55:23 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spPaymentViewGetPagedByUserId]

@PageIndex int,

@PageSize int,

@PaymentStatus varchar(100),

@UserId varchar(25)...

yep I talked to the dev again and he said it was a dynamic parameter..so they have...

lutz - it is a table valued function

here's the function - -- ==========================================================================================

-- Author: Jeremy Truitt (as taken from Erland Sommarskog, SQL Server MVP. Located at:

-- http://www.sommarskog.se/arrays-in-sql-2000.html#iterative

--

-- Create...

it does run faster (3 sec) if I take out the last join

I talked to the dev and he says he must use that function -

check the cert on the server

true.. I was assuming all variables where the same..

also if the proc runs fine in ssms ..then it's prob not parameter sniffing

Is this correct? You are seeing this on everyproc?