>Could you elaborate more on UDF statement?

Well, theoretically, this could be like this:

select *, ProgBar() as MyProgress from myTable where .. into ...

,

where ProgBar will update your ProgressBar. However, I've never used this technique and definitely would not recommend it.