Select statement with complex where clause

Can you be more clear.

Thanks saurabh for started using Codeproject . My request you to format your question in below format
1) {I have this data stucture}
2) {I have this data}
3) {I want this logic to be implemented in my solutions}
4) {so I will get this result as per data which is described above}

That would be better to understand your question and you will get helpful response quickly.

This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.