Recent content by sivaksekar

Hi, Currently I'm having 5 Million records and trying to get the result from below query SELECT * FROM AT_OUTBOUND_062017 WHERE CALLING_NBR LIKE in (201009, 201025, 207259, 2610012, 2611125, 2611914, 2613188, 2615500) Getting Syntax error (missing operator) in query expression 'CALLING_NBR...

Hi, I'm facing format issue on access, For instance: I have a table like this (around 9 million records) Column "F3" considered as long text as raw data itself in same format. F1 F2 F3 F4 708807945...

Hi, Thanks. I have read the data record by record found some unknown formats inside the data set and cause for this getting overflow error. ࠷475ऱ5440栉70еస62䀸ȴ 5/3/20 6 18Ⱥ3Ĺ 1䀍耂747д0944쀸ࡋ70°94 519䀉%/3įİ0‱6` 8:39耉2* *74860¶508 700Ȥ3ᠲ̱85 µ)ұ/20 6̠98к3= ࠸5 7耴 е69₱18...

Hi, Currently I'm having 5 Million records and trying to get the result from below query SELECT FORMAT (START_TIME, "MM/DD/YYYY") AS CALLDATE, COUNT(CALLING_NBR) AS TOTAL_CALLINGNUMBER, COUNT(CALLED_NBR) AS TOTAL_CALLEDNUMBER, SUM(DURATION) AS TOTAL_DURATION FROM [Salaam to AWCC outgoing May...