I have problem to retrieve the data when using the following SQL statement. I cannot figure out which part went wrong.
select distinct(b.USR_ACCT_NO) from docsadm.profile b where (b.USR_ACCT_NO is not NULL and b.USR_ACCT_NO<>'') and b.USR_CUST_STATUS='C' and b.USR_ACCT_NO not in (select a.accountcode from USR_EDMS_DOC_SCAN_STATUS a where a.accountcode=b.USR_ACCT_NO and a.status = 'C' and a.updateStatus = '0') and convert(varchar(10),b.CREATION_DATE,120)=(select convert(varchar(10),getDate(),120))
This statement been used in asp code. Please help.