Thank you for your advices, you've all been very helpfull. Now I have clearer picture of what to do and which way to go. I'll let you know about the...

Charles.Otten (12/16/2010)

---

i agree with the scalar functionality that you are describing being bad. Virtually any scalar using a SELECT is just going to be awful. The scalars i'm...

Dave Ballantyne (12/16/2010)

After you've done that to all the smaller bits of code ,you should be in a better situation to remove the looping altogether.

BTW Notice how ive used an...

Unfortunatelly, I'm not allowed to post full code:(

But I have a bunch of similar code for determining the value of each field in output record

/* FIELD 2 */

if @Field_1='F5'

select...