One curious error we are getting in the procedure 3,its in an insert statement which is includes a select statement date time out of range.

The interesting thing is there is only one date filed in the table and the corresponding field in the select also belongs to same type ! .

As per the advice of my friend we gave a set datefotmat ‘mm/dd/yyyy’ before the statement and now its working fine.

But my doubts are remaining,

i) How an error in a statement will step over the following steps

ii) In an insert statement why it is rejecting the data in with same datetime type