Thank you. Let me explain.

I have three tables, purchase_orders, attachments, blobs.

Purchase Orders table is the parent and attachments is a child of it.

Blobs is also a child table.

The attachment...

Thank you for your response. The execution plan is not very clear. Could you please explain the above queries to me. For the second query, when I put distinct, I...

Thank you for the reply.

We have executed the DBCC command too.

Thank you. I was able to achieve the result i wanted with this clue

Whatever month number is given it always returns only january