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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: R1972
  • Content: Threads
  • Order by date
  1. R1972

    Help in query

    Hi, Sample data Table - tbilldate tbilldate.dt_bill 01/03/04 02/03/04 .... ... 12/03/04 table - tbill tbill.nmi tbill.dt_bill 1 01/03/04 1 02/03/04 1 05/03/04 1 06/03/04 2 03/03/04 2 ..... 2 6/03/04 2 08/03/04 2...
  2. R1972

    help in using query in SQL Server2000

    Hi, I'm new to sqlserver. The following query using in oracle db. I would like to convert the query according to SQL Server2000 DB. Any help would be appreciated. Query : -------- SELECT DISTINCT a.nmi, (SELECT COUNT (*) FROM tbill, tbilldate WHERE tbill.dt_bill(+) =...
  3. R1972

    Query performance issue

    Hi, select * from tableA a where 1 >= (select count(distinct edate) from tableA b where b.no_property = a.no_property and b.company = a.company and b.edate > a.edate ) The above query table have around 10million rows. I need to get info of last 2 max edate for...
  4. R1972

    Store XML Data into Access DB

    Hi, We are having around 2000 XML files, which contains full of valid information. We want to extract the data from XML file to Excel sheet or store into Access database. Your suggesstions would be appreciated. Thanks, Raj

Part and Inventory Search

Back
Top