I am very grateful that there are so many developers out there willing to share their work for free, but I need to make a living and most ways of...

If I may make a suggestion, if this is a query you run often, consider restructuring your tables so that, for the fields on which you are searching, the portions...

You're welcome.

- Les

P.S.

Just out of curiosity, rough guess, what kind of speedup did you see over using your cursor approach?

Try this:

UPDATE mjtest

SET duplicate_with = MyAlias.DupId

FROM mjtest

LEFT JOIN

(

select IDSrc.InvoiceID, DupID=MIN(DupSrc.InvoiceID)

FROM MJTest IDSrc

CROSS JOIN MJTest DupSrc

WHERE IDSrc.VendorNumber like '%' + DupSrc.VendorNumber + '%'

AND IDSrc.CheckNumber...

That's why I was presuming the edits occurred at a regular interval or some other recognzable event. If updates are only done by a single process every day at...

maiphuong2703 (12/15/2009)

---

@Jack: My English is not so well, so I am sorry if I may not be able to understand all you talked.

I have understood it as following:

TABLE DEMO(ID, Name,...

I generally gravitate towards the big, kitchen-sink apps, usually because I want to do things that most people, apparently, do not, or I want to do a lot more things...

shekihan (9/10/2005)

---

RecentlyI have had discussionwith my colleaguesregarding the best database design practicies. Our opinions regarding whether to use composite keys as a primary key (as opposed to one-field-key)splitted into two...

The reason to avoid cursors is because they...

I'm confused -- you seem to be building this "column list" as a concatenated string with bracketed names from a table where the values are in individual rows, then you...

Thanks.

One thing you'll see as you flip through the year's worth of discussion is that this is more of a water-cooler environment and that the kvetching about posts...

Bob Hovious 24601 (11/24/2009)

---

Welcome to The Thread, Les!! 😀

In order to avoid redundancy and repetition and redundancy, we have established an informal rule that newcomers first review...

[highlight=#1]I don't see a way to delete this so I guess you can just ignore it -- my Newbie stripes are showing here. When I posted this I didn't...