Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by nmair

  1. nmair

    Filtering on Time field in pass-through SQL

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

    Filtering on Time field in pass-through SQL

    The DB is an SQL Server 2008, I believe.
  3. nmair

    Filtering on Time field in pass-through SQL

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

    Variables is Pass-Through SQL

    That was great!!! Thanks all for you help!
  5. nmair

    Variables is Pass-Through SQL

    Sorry for the confusion. I'm wondering if 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...
  6. nmair

    Variables is Pass-Through SQL

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

    Variables is Pass-Through SQL

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

    iSeries Access ODBC Drivers

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

    Group Sort by Min Date

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

    Group Sort by Min Date

    These are DateTime fields. No conversions.
  11. nmair

    Group Sort by Min Date

    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?
  12. nmair

    SQL command query taking a long time

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

    SQL command query taking a long time

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

    'Out of Memory'

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

    'Out of Memory'

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

Part and Inventory Search

Back
Top