Thanks for the clarification.

Thanks for the quick reply.

But all the variables declared in the SP are varchar(max)

Below is the code like which i m using. This may help you to understand my problem

Cursor...

Thanks for the quick response.

That solved my issue.

In this case inner join will not give all the rows from master table.

We should use left join only. But if left join is used, date clause in not giving...

Thanks for your quick response. But

Sorry it is actuall my mistake. I given the sample output wrongly.

The output should be: (All the rows from master even if rows are not...