Compid = 159667Number Of Rows Found :1<BR>Compid Found :159667 Tic Found :CNPF<BR>FINALCNPF | 159667<BR><BR>Split info : 1<BR><BR><BR><BR>START<BR>ratioBigStringPieces :<BR>reportDateBigStringPieces :<BR>  SELECT  current13Fpositions. *  
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =159667 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes'  AND reportDate >= '2024-03-31' <BR><BR>Number Of Rows Found :0<BR>virgina 0<BR><BR>virgina2 0<BR>SELECT * from sectors where level3num = '999999'Number Of Rows Found :1<BR>The Sector is N/A<BR><BR>CRAIG TOTAL SHARES VALE : 0<BR><BR>MKCAP0/n/ninsert into institSumNewHoldings values(
								 Null,
								'9000004133',
								'159667',
								'Global Canada Preferred',
								'CNPF',
								'',
								'37950E481',
								'3540000',
								'0',
								'999999',
								'N/A',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '0',
								 '', 
 								 '', 
 								 '', 
 								 '0', 


								  NULL,  NULL,NULL)

OKbye