EXPORT TO 'E:\Mahavikas_Tin.csv' OF DEL

select substr(C.DIS_RCNO,1,11) as tin_no,B.desk_desc as loc,date(timestamp(C.RC_ISS_DATE)) as generated_date 
FROM desk_master_tb B,DIS_RC_CIN_TB c
WHERE smallint(C.CREATED_BY_USER_ID) =B.DESK_ID 
and smallint(C.CREATED_BY_USER_ID) not in (32293,32058)
and C.act_id in (1,17)
and date(timestamp(C.RC_ISS_DATE)) > '2007-09-30'
group by C.DIS_RCNO,desk_desc,C.RC_ISS_DATE
having substr(C.dis_rcno,6,11) > '570000';

#SYNC 10;









------------------------------------------------------------------------------------------




EXPORT TO 'E:\Mahavikas_Scrolls.csv' OF DEL

select A.ret_mscrl_no,B.BANK_NAME as bank,date(timestamp(A.created_date)) as generated_date
from RET_MAIN_SCROLL_TB A,BANK_MASTER_TB B
where A.BANK_ID =B.BANK_ID
and smallint(A.CREATED_BY_USER_ID) not in 32294
and A.ret_mscrl_no > 200000
and date(timestamp(A.created_date)) > '2007-09-30'
and status_id = 1
group by A.ret_mscrl_no,B.BANK_NAME,A.created_date;


#SYNC 10;







-------------------------------------------------------------------------------------------

=CONCATENATE("update mahavikas_gen_tin set generated_date = '",C1,"' where tin_no='",A1,"';")
=CONCATENATE("update mahavikas_gen_scrolls set generated_date = '",C1,"' where scroll_number = '",A1,"';")
=CONCATENATE("insert into mahavikas_gen_tin(tin_no,location_name,generated_date) values('",A1,"','",B1,"','",C1,"');")
=CONCATENATE("insert into mahavikas_gen_scrolls(scroll_number,location_name,generated_date) values('",A1,"','",B1,"','",C1,"');")