Where

[smilingjohn]

Hi All,

Iam using the below condition in the script  using where condition ..

Where (Pass_Year= Year(Today()) and Passmonth <= 12) AND (Pass_Year = Year(Today())-1 and Passmonth > 12);

This is giving me error..Please let me know if this is correct or needs to be changed ..

Thanks

[vineetadahiya12]

This again seems working fine. John, Can you please share the sample file with us or the complete load stmt.