how to do complex validation on huge volume of records before inserting into table..please see the explained scenario and suggest ideas

I am totally aware of this..but i want to how to build such logic in sql query...Please help...