>If say, you would be using an SP to update all 3 tables at once, you would not have this problem, but the question is how to pass parameters?
>
>In SQL Server 2005 you may pass XML as a parameter, but I don't think it would ease the process.
>
>E.g. if you somehow pass curUpdateTable1.XML (all updated fields for 1 table), same for the second and the third - I'm not sure how can you now handle it in SQL Server.
>
>How can we pass updated values for the fields in this SP?
>
I am not using SP for the updates. And I would like to keep updates of each module done via the module Business/DA class. So passing XML or doing anything in SP is not applicable for me here.
Thank you for your suggestion.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham