<rant>
Spent an hour yesterday figuring that one out in my sp, on an insert
statement that used a join for the source. Even rebooted the server in
desperation. It wasn't until I took that join and made a view and used
that as a source it pointed out the real error, mismatched number of
columns between insert into and select statements. D'OH!
</rant>
--
A)bort, R)etry, I)nfluence with large hammer.
Spent an hour yesterday figuring that one out in my sp, on an insert
statement that used a join for the source. Even rebooted the server in
desperation. It wasn't until I took that join and made a view and used
that as a source it pointed out the real error, mismatched number of
columns between insert into and select statements. D'OH!
</rant>
--
A)bort, R)etry, I)nfluence with large hammer.