• Sachin Nandanwar (7/29/2012)


    Does this work ?

    ....FROM #ddb_temp_DDB tdb

    where not exists (select 1 from deposits_daily_balance ddb_t

    where ddb_t.num_cue_s =tdb.num_cue_s and ddb_t.val_date_d = @t_date_d and ddb_t.reg_date_d = @t_date_d)

    COLLATE 'SQL_Latin1_General_CP1_CI_AS'

    Unfortunately not.

    Kind regards

    IgorMi

    Igor Micev,My blog: www.igormicev.com