quote:

---

Originally posted by sharathkatpally

use RMB07500_STG_DB

declare @LOOP_FLG char(1);
set @LOOP_FLG = 'Y';

declare @FORCE_CHECKPOINT int;
set @FORCE_CHECKPOINT = 0;

while (@LOOP_FLG = 'Y')
BEGIN
SELECT top 1000000
DDATBAT.[INTGRT_CTL_AFF]
,DDATBAT.[DISTB_NBR]
,DDATBAT.[AUDIT_TYPE_CD]
,DDATBAT.[DB_DT_KEY_NO]
,DDATBAT.[DB_SEQ]
,DDATBAT.[DB_BATCH]
,DDATBAT.[AUDIT_REAS_CD]
,LKP.[IMC_KEY_NO]
into #DV_DDATBAT
FROM [RMB07500_STG_DB].[dbo].[DV_DDATBAT_INITIAL_LOADS_ODS] DDATBAT
inner join [DWB01002_GLOBAL_DW_EXTRACT].[dbo].[DWT20280_IMC_KEY_LKP] LKP on
DDATBAT.[INTGRT_CTL_AFF] = LKP.[IMC_AFF_ID]
and DDATBAT.[DISTB_NBR] = LKP.[IMC_NO]
left join [RMB07500_STG_DB].dbo.DV_DDATBAT_MST ODS on
DDATBAT.[INTGRT_CTL_AFF] = ODS.[INTGRT_CTL_AFF]
and DDATBAT.[DISTB_NBR] = ODS.[DISTB_NBR]
and DDATBAT.[AUDIT_TYPE_CD] = ODS.[AUDIT_TYPE_CD]
and DDATBAT.[DB_DT_KEY_NO] = ODS.[DB_DT_KEY_NO]
and DDATBAT.[DB_SEQ] = ODS.[DB_SEQ]
where not DDATBAT.[AUDIT_TYPE_CD] is not null
and ODS.[INTGRT_CTL_AFF] is null

This is giving an error Msg 102, Level 15, State 1, Line 42
Incorrect syntax near 'null'. But when i only run the select statement it runs fine. so there is not issue with the null syntax. Unable to find what is the issue. please help

thanks

---