I'm trying to update an empty field in a table using the update statment. The table has a number of joins and the update statement comes up with an error when I enter the main table to update. should i be including the joins here as well? I get the following error:
Server: Msg 208, Level 16, State 1, Line 178
Invalid object name 'TD_EXTRACT'.
Server: Msg 208, Level 16, State 1, Line 178
Invalid object name '#Neil.Mortgage'.
The code im using...
DECLARE Alpen_Cursor CURSOR FOR
SELECT TDE.Merged_Fund_Desc,
TDE.MORTGAGE,
TDE.Client_Main_Surname,
HAT.[Last_Delq_Bucket],
HAT.[Current_Balance],
HAT.[Possession_Date],
M56.ASSNAM AS [Possession Agent],
TDP.REGION,
HAT.Litigation_Status,
HAT.MORTGAGE_STATUS,
A34SC.PROGCLOSE,
Cast('space' AS VARCHAR(100)) AS Prog_Point_list
FROM REPT_SOURCE_ME_01.dbo.TD_EXTRACT TDE
INNER JOIN REPT_SOURCE_ME_01.dbo.TD_ARREARS HAT
ON TDE.MORTGAGE = HAT.MORTGAGE
INNER JOIN REPT_SOURCE_ME_01.dbo.[ACM41] ACM
ON TDE.MORTGAGE = ACM.MORTGAGE
INNER JOIN REPT_SOURCE_ME_01.dbo.[MAM56] M56
ON ACM.LITPOSSAGENT = M56.ASSCDE
INNER JOIN REPT_SOURCE.dbo.[ACT34StageC] A34SC
ON ACM.MORTGAGE = A34SC.MORTGAGE
INNER JOIN REPT_SOURCE.dbo.[MAM16] M16
ON ACM.LITSOLICITOR = M16.SOLCDE
INNER JOIN REPT_SOURCE_ME_01.dbo.TD_PROPERTY TDP
ON TDE.MORTGAGE_NO = TDP.MORTGAGE_NO
WHERE A34SC.PROGPNT IN ('AUC','AUO','MPS','NRC','OLP','ORC','POS','RAR',' RCO','REC','RMP','ROF','ROS','ROW','RPO','TIC','VP O')
AND HAT.Litigation_Status = 'possession'
AND HAT.MORTGAGE_STATUS = 'live'
AND A34SC.PROGCLOSE IS Null
GROUP BY TDE.Merged_fund_Desc,
TDE.MORTGAGE,
TDE.Client_Main_Surname,
HAT.[Last_Delq_Bucket],
HAT.[Current_Balance],
HAT.[Possession_Date],
M56.ASSNAM,
TDP.REGION,
M16.SOLNAME,
HAT.Litigation_Status,
HAT.Mortgage_Status,
A34SC.PROGCLOSE,
ACM.LITSOLICITOR
HAVING (((HAT.Litigation_Status) = 'Possession') AND ((HAT.MORTGAGE_STATUS) = 'Live') AND ((A34SC.PROGCLOSE) IS Null));
OPEN Alpen_Cursor
FETCH NEXT FROM Alpen_Cursor
CLOSE Alpen_cursor
DEALLOCATE alpen_cursor
UPDATE
SET TD_EXTRACT.Prog_Point_list = #neil.PROGPNT + ','
FROM TD_Extract
INNER JOIN #Neil.Mortgage
ON TD_Extract.Mortgage = #Neil.Mortgage
AND #Neil.PROGPNT = Alpen_Cursor.PROGPNT