We can use below command for bcp out a table to *.dat file, $SYB_BIN/bcp hnwreport.dbo.TblHNWCustomer out ${SYB_DATA}/${TABLE}.prod.dat -I/opt/muni/HNWEnv/HNW_interfaces.txt -U hnwuser -P Lip0v123 -S

(select cast(round(sum(port1.market/1000*secr1.moody_rating_no)/ (select sum(port2.market/1000) from TblHNWPort port2,TblHNWSecr secr2 where port2.cusip = secr2.cusip and port2.key_date = secr2.ke

当需要基于不同条件产生的结果集上运算时，我们可以采用对单一结果集运算后，保持原有结果集，然后统一根据某个字段聚合后来求一些字段的和。 select A.port_no as port_no, (select max(key_date) from dbo.TblHNWDate) as key_date, sum(A.pfd_shares) as tot_pfd_shares, sum(

Create Table DDL sample(TSQL)