I do not know what would be the better way to present a simple table with 7K+ records (Excel file). The table has 2 columns, ID and Arrival DateTime. Sorted...

Sorry, I thought that info I provided was straightforward.

Thanks

Thank you Lynn. What does it mean not to use TEXT in new developments? In new queries?

SoHelpMeCodd ==>

In my codes i'm using ado - the sql code runs on the server

The bottomline is: Access memo truncates varchar(max) to 255 but fully accepts cast(fieldVarcharMax as Text)

Toby: I've the same experience - SUM(Case ... works faster than PIVOT

From memory (I did not work with Cachè much), the document database has lots of metadata but the data is a PAIN to get to and querying is slow. ...

Thank you.

Currently we place queries into vb code (or use vb code to call stored proc from the source database) and get the resultsets (using ADO) that are inserted into...

Thank you. I'll work on it

Luis proc works great yelding 14431 rows within 3 sec (both versions)

Thank you, guys!

Thanks a lot. I used 2 CTE with ROW_NUMBER. It takes 2 sec to create 5743 resulting rows out of 14431 rows in _Diagnosis2015 table but after that the code...

Solved. Thanks a lot.

Yes silly or yes I can?

Ha ... Thanks!