This is what i did, that is i called the stored proc using the following syntax. (You should know the ADO.NET in order to understand the following code.)

Command.CommandText =...

The statement which was giving error was actually generated by the SQLClient of the .NET Framework when i tried to call this stored proc from a windows form.

Thanks stefano and steve for your inputs.

Ishwar

There is a small update.

Please consider the data type of @FindExact is bit in stored procedure definition.

By mistake i typed it as int.

Thanks

Thanks steve for your earlier reply.

I have one more query. I have a doubt regarding the INSTEAD OF trigger on partitioned view. Actually the doubt come when i saw the following...

Hi Frank Kalis

The query plan shows that it uses second approach that is select the data using indexes and then take a intersection of the results based on the primary...

No i haven't seen its query plan.

Actually i want to know what is the approach of SQL server.?

No problem i will check the execution plan

thanks pmbrown for the reply