Hi.. Im not going to insert a single value into that tables. All that i want to do is to eliminate duplicate records from other tables.A value(in...
Hi.. In the above query if i want to delete the duplicated mobileno from other table,can i give delete instead of select? Which join should i...
Thanks a lot...[:)] Just one more doubt.If i have the same mobileno in another table in the same databse.Which query can i give?? Thanks Jeen
The above i had given is a sample data. I have 14 colums. 2009489 E NULL 0 NULL NULL NULL NULL 5/15/2007 2007 6051 NULL NULL NULL 2009489 E...
Hi, The duplication is for my mobileno.Some times date and year too be duplicated. In the same day itself one can send has many sms as they want. But...
Hi all, Im having 12 tables in a database. There are duplications inside the tables,also outside the tables. One record in one table may be...
Thank U for the solution....
Hi all, How can i retrieve a record that starts with a particular number,say 5? Thanks In advance Jeen
Hi, I need only unique mobileno. and other detail can be of old or new.That doesnt matter.But only one message from that mobileno.All the other...
Hi all, Im having problem and im spending half of the time for this. I have a databse for sms chat service. and a table containing the details such...
Thank U so much... Jeen
Hi all, Im having a table with 7 lakhs record.TabIe have only one field.In that,each record start with a common set of number. I want to delete that...
Hi, In sql2000 export/import we can choose sql express know?Using that i tried. I dont know whether its the correct format or not. Regards, Jeen
Hi all, In database,we have all task,from that i tried to export one table from sql2000 to sqlexpress.Will it work properly? I downloaded sql2005...
hi all, but my problem is that i installed sqlexpress first then sql2000.While exporting from sql2000 to access or excel ,its not working.. I know...
Hi all, I want to install SQL 2000 and also SQL Express 2005.Which should be installed first? What all are the steps for installing SqlExpress?Pls...
Hi, Actually my table deals with mobileno: and the detail such as message,language,place,category. This records are used for sms purpose. So i need...
Hi all, Im having two tables with 1 crores of record each. I want to avoid its duplication.But when im giving the query in query analyser for...
Thank You. Jeen
Separate names with a comma.
