Thanks for your suggestions. I think the procedure is not my main problem, because it allows to update records , for the whole company for one year, for a cost...

thanks for your answer. I googled batch mode and I guess I need some more experience and knowledge before I'd be able to transform my code into batch mode.

Thanks for your answer. I just thought, maybe there is more elegant way to do something like this, I started writing T-SQL only a year ago and am eager to...

Probably the wrong word (I am not a native speaker). What I wanted to say was that there is the danger of creating (and using) the same table under two...

thank you  for your good and quick answer. I just checked signing procedures and I think it is challenging ...

To make point two clearer (I hope):

To structure a single db...

thanks scott, I had the suspicion about the 4000 characters length.

mistery solved about missing linebreaks/-feeds:
in default linefeeds are not copied. so I had to go to...