Search results for query: *

Hello all, I know how to filter on records based on a datetime field, such as in the following query: SELECT ORDERS.ORDER_NO, ORDERS.ORDERDATETIME FROM ORDERS WHERE ORDERS.ORDERDATETIME >= {ts '2011-12-31 00:00:00'} But, i'm unsure of the syntax when filtering records based on a time field...

Hello all, I'm new to using pass-through queries from Access to SQL Server but I do have some background in writing SQL statements and programming. I was just wondering if it's possible to write a pass-through query and also use variables? For example...

Anyone use this driver by IBM? Anyone know what kind of a database (DB2 maybe?) this driver would be connecting to? I'm looking to find out if there are other drivers that might offer more functions that can be used with SQL Expressions. The ones used by the iSeries seem limited.

Hello all, I have 1 group in my report. I sort these gropus in ascending order by min(somedate). However the groups are showing up on my report in descending order, for example, (mar 07 appears before feb 07 and so on) What am I missing here?

Hello there. The below query is running very slow. Is there anyway I can change it to make it run quicker? SELECT ({fn MONTHNAME(transactiondate)}), acctno, COUNT(DISTINCT mcc) AS DISTINCTMCC FROM transactions WHERE (response='50' OR response='01') AND fraud='F' AND channel='02' AND...

I receive this notification message everytime I run a report that extracts data from only 1 table but has possibly over 100 million records. Anyway to work around this? Does increasing Virtual Memory on the PC help? Would reducing the records returned (through filtering in select expert) work...

Hello there, I have the following small table (CardTransactions), given below which is sorted by card and then by date: CardNum ActivityDate ---------- ------------- 1 2011/12/17 1 2011/12/18 1 2011/12/20 1 2011/12/22 2 2011/12/13...