Actualy, if you do a search for "DELETE DUPLICATES", you come up with just a couple of articles which use cursors and group bys and adding columns and using MAX/GROUP...

Vishal,

If your field list looks like this...

field value: Oracle,VB,ASP,PHP

field value: Java,VB,PHP,MYSql

field value: Java,VB,Oracle,Asp.net,MSSQL,Asp

field value: Windows,HASP,Excel,VBA

Consider the following code to keep from listing the 4rh line when looking for ASP and...

And, you might want to consider using the user name in the 3 part naming convention as part of best practices...

With 7 million rows of data, I'm thinking that you'll get a recompile on run anyway just due to the number of changes in the data.  So, I gotta ask,...

Chris,

Likewise it's interesting to think that databases are not used for performance... whatever.  The real key is that the inclusion of the NOLOCKs greatly reduced the number of deadlocks in...

Chris,

Yup... I agree on the data integrity thing but considering that a ROLLBACK is supposed to be (and, fortunately, is) an extremely rare occurance (and then usually only on the...

>I can only say that I would not do that.

Why not, Chris?

Thanks for the reply, Chris.  Your experience seems to contradict what BOL says.  Now, THAT's never happened before, eh?   Kinda why I asked if anyone had experience with...

Rumor has it that there are some very stiff penalties for storing unencrypted credit card information and other seemingly minor infractions on safeguards.  I would say there's no such thing...

Just for grins, how fast does it run without the ORDER BY?  If it's really fast, use the 14 row result set as a derived table and select from THAT...

Just a quick thought... why does the BCP login/password need rights to anything but the destination table?  Make a user that only has rights to the input staging table (you...

This will convert the number of seconds since midnight to a datetime (for today) datatype so you can do the join...

SELECT DATEADD(ss,secondssincemidnightcol,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0))

Nice job Sushila.... I use EM to troubleshoot other people's more complex joins and, occasionally, to make my own.  And, I "steal" code from it and QA quite a bit...

The "best" way would be to not store data in such a fashion...

That, not-with-standing... something like this should work...

 SELECT c.CategoryName,

        c.CategoryID

   FROM Category c,

        UserCategory uc

  WHERE ','+uc.CategoryID+',' LIKE...

Admittedly, I've not done much with Federated Servers but I'm not sure why the relatively simple process of ETL would justify the need even in a world wide setting.  The...