USE [FACILITIES]

GO

/****** Object: StoredProcedure [dbo].[FDIT_Transform_SAP_AUC_IMPORT] Script Date: 04/22/2008 15:08:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[FDIT_Transform_SAP_AUC_IMPORT]

AS

UPDATE FDIT_SAP_AUC_IMPORT

SET AUC=AssetNumber+'-'+SNo;

/****** update FDIT_SAP_IMPORT

set FDIT_SAP_IMPORT.auc=FDIT_SAP_AUC_IMPORT.auc

from FDIT_SAP_IMPORT

where FDIT_SAP_AUC_IMPORT.wbsnumber=FDIT_SAP_IMPORT.wbsnumber;****/

update FDIT_SAP_IMPORT

set AUC=FDIT_SAP_AUC_IMPORT.auc

from FDIT_SAP_IMPORT

where...

Gail,

I'm new to TSQL and have similar nonfunctional update statement:

set FDIT_SAP_IMPORT.auc=FDIT_SAP_AUC_IMPORT.auc

from FDIT_SAP_IMPORT

where FDIT_SAP_AUC_IMPORT.wbsnumber=FDIT_SAP_IMPORT.wbsnumber;

Any Ideas?