Re: getting values from inserted table

From: Brian Henry (brianiup[nospam)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 11:21:26 -0500

its a very complex mathamaticl process used to calculate rates for bills,
when a row or rows are inserted we need to automaticly figure out the new
rates and apply them to existing bills

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:6LadnQ99gqN2RszdRVn-iQ@giganews.com...
> But what is it that you are doing "one by one"? What happens to these
> variables once they are assigned. Row by row processing should be avoided
> wherever possible and if you explain what you are doing maybe someone can
> show you a set-based alternative.
>
> --
> David Portas
> SQL Server MVP
> --
>
>