Recent content by R1972

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

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

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

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(+) =...

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

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

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

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

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

Thanks for your useful hints. Raj

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

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

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

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)

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