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 Chriss Miller 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
  • Order by date
  1. R1972

    Help in query

    Hi djbr, yeah...It's wonderful...Its working.... Can you please explain how it works bcoz I'm not aware of Rank and lead function ? Thanks, Raj
  2. 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...
  3. R1972

    help in using query in SQL Server2000

    eg:- Sample data tbilldate.dt_bill 01/03/04 02/03/04 .... ... 12/03/04 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 10/03/04 3 05/03/04...
  4. 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(+) =...
  5. R1972

    Query performance issue

    HI, There is an index on cd_company_system and no_property and also created functional index on dt_end and normal index on dt_start... There are around million rows in that table...and around 900,000 rows using the where clause This query not taking much time like the other query that you...
  6. R1972

    Query performance issue

    Hi parbhani, Thanks, actually your query took only around 30 min. The table contains more than 30 million rows... Much more better than b4. Thanks again, I've another set of query...hope you can help in this... The following query gets the recent one eg.. No. dt_start dt_end 1...
  7. 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...
  8. R1972

    table export sql*loader

    Sorry guys!! I didn't read the requirement properly...
  9. R1972

    table export sql*loader

    Hi, create DB links between 2 servers and transfers the data from table a to table b but fast depends upon the lan speed.
  10. R1972

    Store XML Data into Access DB

    Thanks for your useful hints. Raj
  11. 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
  12. R1972

    Duplicate data

    Try this select a,b,c,d,e from tableA group by a,b,c,d,e having count(*) > 1
  13. R1972

    SQL - selecting items NOT IN tables

    how abt this Select id from reports where id not in(select report_id from keyword where keyword_id not in(1707, 13, 15))
  14. R1972

    duplicate records

    how abt the following statement delete tab a where a.rowid not in ( select max(b.rowid ) from tab group by id, dept, name, location)
  15. R1972

    how to insert values from multiple tables?

    insert into table3(studentid, instructorid, mathmarks, physicsmarks) (select a.studentid, a.instructorid, b.mathmarks, b.physicsmarks from table2 b, table1 a where b.studentid = a.studentid) Or create table3 with rows... eg. create table table3(studentid, instructorid, mathmarks...
  16. R1972

    How to describe all tables in a schema

    SELECT TABLE_NAME, COLUMN_NAME FROM USER_TAB_COLUMNS IF U WANT TO KNOW ABT THE CONSTRAINTS USE COMBINATION OF THE dictionary tables like user_tables, user_tab_columns, user_constraints, user_cons_columns
  17. R1972

    end-of-file on communication channel

    Its disconnected. connect & execute ur sql statements
  18. R1972

    Export tables from personal edition to enterprise edition

    export from local database & import into server side
  19. R1972

    DB_BLOCK_SIZE

    I think u can't change the parameter db_block_size in init.ora. Only way u can drop the database and recreate the database with the changes.
  20. R1972

    How to write a stored procedure in Oracle

    CREATE OR REPLACE PROCEDURE <proc_name> IS i NUMBER := 1; BEGIN WHILE ( i <= 5000) LOOP INSERT INTO t00 values(i); INSERT INTO t50 values(i); i := i + 1; END LOOP; COMMIT; END; / executing the procedure from sqlplus--- SQL> exec <proc_name> or using pl/sql begin...

Part and Inventory Search

Back
Top