Even if there are duplicates in the select, will it not get caught in the if exists for the second insertion/ duplicate insertion ??

The Primary key for TableA is mentioned...

I was inserting some test data before executing the SP all in one transaction.

I tried it without using a rollback and it worked fine!

Why should an email be queued if...

I have a weird problem here.

In my first two attempts, the email was delivered successfully, however now it gives me the message

'Mail queued'

Any reason, why this should happen?

I checked...

It is better to try both(temp tables and table variable) before deciding. A stored procedure I am working on requires two temporary structures. However, one of them needs rows to...