ok ,lets i explain my requirement....

ALTER PROC Multiple_Instance_Value

(

@compnay_ID INT,

@Instance_ID NVARCHAR(MAX)

)

AS

BEGIN

SELECT instance_id,address,company_name,status FROM cmytbl

WHERE company_ID =@company_ID AND instance_id = @instance_id

END

for exemple we passing the input parameter as

EXEC Multiple_Instance_Value @company_id =...