Thanks for the insight you have given. I ran the s.procedure on Person.Person against Adventureworks2008 database. My query was like this:

CREATE PROCEDURE dbo.sp_select

@Person NVARCHAR(200)

AS

DECLARE @cmd NVARCHAR (255)

SET @cmd...