Tagged with SQL - Visokio Forums http://forums.visokio.com/discussions/tagged/SQL/feed.rss Mon, 30 Oct 17 19:33:18 -0400 Tagged with SQL - Visokio Forums en-CA Performance: Custom SQL - Data retrieval time? http://forums.visokio.com/discussion/1897/performance-custom-sql-data-retrieval-times Wed, 14 Nov 2012 07:50:37 -0500 kattasureshkumar 1897@/discussions
System used to check this performance : 16 GB RAM, i3 3.3 GHz Processor, 64 Bit.

Thanks, Suresh.]]>
Filtering data automatically every month http://forums.visokio.com/discussion/1271/filtering-data-automatically-every-month Wed, 01 Feb 2012 11:01:51 -0500 JorgenP 1271@/discussions
I have been struggling to find a way to filter my data, so I hope you have some good ideas.

Every single month I am getting data for the entire month. I would like to have a sql filter or insert a command in sql, that only would give me only the last 4 weeks of data.

I am getting all my data from Access which is send to visokio through a pass through ODBC method.

At the moment I have a lot of data that is been passed through and this is slowing down the process when moving from one tab to another.

Do any of you have an idea of how can get this to work? I have week, month, quarter and year to use as a filter.
I would like the filter or command to be self providing regarding what data to use.
For instant - i dont want to have to change any dates every month, but instead just send all my data from access to visokio, and with doing anything, except for pressing "load", and it will automatically filter my latest data out.

Cheers
Jørgen]]>