I have a stored procedure where I am inserting data form stage table to main table. There I have a data in the column where has very huge data.
when i run stored procedure for first time it shows message invalid length parameter passed to left or substring function and when i ran second time the same stored procedure it showing error as stirng or binary data would be truncated..
both column sizes and data type is same for both source and destination..we are ok if we get invalid length error but why the second time its shows as truncation error?