"obelix" <u24035@uwe> wrote in message news:66fa8992a6eca@uwe...
>I have three tables: Process_Log, Process_A AND Process_B . The log table
>is
> used to create logs for data inserted in the other two tbls. The two tbls
> have the Process_Log ID as an FK and for each of the two a unique process
> file ID exists in the Log . I am using these update statements to update
> the
> log with the record count. I want to do this in one statement and
> possibly
> derive wc of the two tbls to use based on the Process_File_ID wc is unique
> for each of the two tbls. (I've left out the declarations for convinience
> sake)
>
> stmt:
> UPDATE Process_Log
> SET Imported_Records_Count = (SELECT COUNT(A.iID)
> FROM Process_A A
> WHERE A.Process_Log_ID = P.iID )
> FROM Process_Log P
> WHERE P.Process_File_ID = @plFile_ID
> ------------->
> UPDATE Process_Log
> SET Imported_Records_Count = (SELECT COUNT(B.iID)
> FROM Process_B B
> WHERE B.Process_Log_ID = P.iID )
> FROM Process_Log P
> WHERE P.Process_File_ID = @plFile_ID
>
>
> Any ideas?
>
> --
> obelix
>
> Message posted via http://www.sqlmonster.com
>

On Thu, 28 Sep 2006 19:13:58 GMT, obelix wrote:

>I have three tables: Process_Log, Process_A AND Process_B . The log table is
>used to create logs for data inserted in the other two tbls. The two tbls
>have the Process_Log ID as an FK and for each of the two a unique process
>file ID exists in the Log . I am using these update statements to update the
>log with the record count. I want to do this in one statement and possibly
>derive wc of the two tbls to use based on the Process_File_ID wc is unique
>for each of the two tbls. (I've left out the declarations for convinience
>sake)

>stmt:
>UPDATE Process_Log
> SET Imported_Records_Count = (SELECT COUNT(A.iID)
> FROM Process_A A
> WHERE A.Process_Log_ID = P.iID )
> FROM Process_Log P
> WHERE P.Process_File_ID = @plFile_ID
>------------->
> UPDATE Process_Log
> SET Imported_Records_Count = (SELECT COUNT(B.iID)
> FROM Process_B B
> WHERE B.Process_Log_ID = P.iID )
> FROM Process_Log P
> WHERE P.Process_File_ID = @plFile_ID
>
>Any ideas?