Search results for query: *

Is there anyway to tell for certain what kinda of a DB it is without having to contact the DBA?

The DB is an SQL Server 2008, I believe.

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...

That was great!!! Thanks all for you help!

...a pass-through query can have variables within it. If I enter this query as a pass-through query, I receive no errors and the query runs. SELECT * FROM Customers WHERE Customers.CustomerID = '1' But when I try to use the following pass-through query with a variable inside of it, I receive...

Hi Andy, thanks so far. This may be a silly question but where would I insert this code in MS Access?

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.

That works but just wondering if I'm logically correct! Thanks for the help.

These are DateTime fields. No conversions.

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?

Sorry folks, I forgot to mention that there is 120 million records returned before grouping begins.

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...

the table stores 3 months of transactions only, which is what is required.

We have version 11 here. the records are card transactions and field4 is a specific merchant type. Neill

I'm just doing summaries, with no grouping, on the whole table. The SQL query placed in the command object is: Select count("table"."field1"), sum("table"."field2"), avg("table"."field2") From "table" Where "table"."field4" = "some string1" "table"."field4" = "some string2"...

I chose 1 table from my datasource. When using the command object would that be considered to be revising your selection criteria so that it is all gets passed to the server for processing consequently avoiding much of CR's memory usage? Please advise. Much appreciated. Neill

Hi Turkbear, how do I revise my select criteria? Do I do it by writing an SQL query and then adding it as a command where I select my datasource when creating a report? I know sql. Unfortunately I don't know which type of Database I connect to. Thanks for your help. Neill

Thanks for the help so far. I did try increasing my VM from 2GB to 20GB, but no-go. I'm simply just using the records from this table to do 4 Grand Totals(inside Report Footer). And a filter is placed on 2 fields (in Select Expert) Other suggestions maybe? Regards, Neill

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...