Guest Analizer1 Posted January 11, 2008 Posted January 11, 2008 Hi Hope you can help.... What would be the most efficient way to de dup a table I have like 10 columns i need to Check against.... our business rule is any incomming information can't be within today -90 , ie 90 days a Example would be helpful Thanks
Guest Danny Sanders Posted January 11, 2008 Posted January 11, 2008 Re: duplicates HuH????? Not a clue as to what you are asking. DDS "Analizer1" <dvs_bis@sbcglobal.net> wrote in message news:4nOhj.5731$pr6.5507@nlpi070.nbdc.sbc.com... > Hi Hope you can help.... > > What would be the most efficient way to de dup a table > I have like 10 columns i need to Check against.... > > our business rule is any incomming information > can't be within today -90 , ie 90 days > > a Example would be helpful > Thanks > > > >
Guest Meinolf Weber Posted January 11, 2008 Posted January 11, 2008 Re: duplicates Hello Analizer1, What is your question about what kind of problem from which software/operating system? Best regards Meinolf Weber Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights. ** Please do NOT email, only reply to Newsgroups > Hi Hope you can help.... > > What would be the most efficient way to de dup a table > I have like 10 columns i need to Check against.... > our business rule is any incomming information > can't be within today -90 , ie 90 days > a Example would be helpful > Thanks
Guest Analizer1 Posted January 12, 2008 Posted January 12, 2008 Re: duplicates sqlserver 2005 windows 2005 enterprise server(s) we have transactions comming in from the web site via uploades files 1 to 5000 rows at a time no unique identifiers...they all get new keys through the day we process these new rows of data one part of the processing is to verify if a row of data (5 to 10 columns) identify it as duplicate of a previous sent row my question still is how to efficiently check for duplicates against this table using 5 to 10 columns i hope ive explained myself better thanks so i have a master table mymain table ... "Meinolf Weber" <meiweb(nospam)@gmx.de> wrote in message news:ff16fb667cbf28ca22c2386f6bd0@msnews.microsoft.com... > Hello Analizer1, > > What is your question about what kind of problem from which > software/operating system? > > Best regards > > Meinolf Weber > Disclaimer: This posting is provided "AS IS" with no warranties, and > confers no rights. > ** Please do NOT email, only reply to Newsgroups > >> Hi Hope you can help.... >> >> What would be the most efficient way to de dup a table >> I have like 10 columns i need to Check against.... >> our business rule is any incomming information >> can't be within today -90 , ie 90 days >> a Example would be helpful >> Thanks > >
Recommended Posts