am sorry.....

i misspelled...

procedure is working now....

Thanq...

that helped me...procedure is working not.

DECLARE@return_value int

EXEC@return_value = [dbo].[GetCompliances]

@WHERE_CLAUSE = N'RelatedToTypeName LIKE 'Mem%'',

@IssueNumber = NULL

SELECT'Return Value' = @return_value

Exception:

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

Error Message is

Msg 214, Level 16, State 2, Procedure sp_executesql, Line 1

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.