You'll need to post sample data illustrating the problem and the desired results.

Drew

Actually, why are you using a subquery in the first place. Doesn't the following give you what you want?

UPDATE PLU_1

SET DSPL_DESCR = replace ([DSPL_DESCR],'"','in')

WHERE AND DSPL_DESCR LIKE '%"%'

AND len(replace...

The problem is that your REPLACE function is increasing the length of the string beyond the maximum allowed and you haven't correctly accounted for that fact. Given your subquery,...

This is a presentation issue and is best handled in the presentation layer, not the database layer. You don't mention what you are using for your presentation layer, but...

Yes, I already have it installed on my laptop...

Naming...

If you just want the differences without updating, the easiest approach is to use the EXCEPT statement.

SELECT [id], [name], [address], meter_flag, end_date

FROM TableB

EXCEPT

SELECT [id], [name], [address], meter_flag, end_date

FROM TableA

This will...

You're looking for the MERGE statement, which was introduced in SQL 2008. You can find more information in BOL. We still don't have SQL 2008, so I can't...

I would use Row_Number, because using MAX() in a subquery has the possibility of duplicate values if there are multiple records with...

Welsh Corgi (12/29/2011)

---

I guess that it depends because you may not always have a...

I should mention another advantage of STUFF(). You're not cutting the string into pieces and reassembling them, so you don't have to worry about getting the pieces in the...

I prefer using STUFF rather than SUBSTRING and concatenation for a couple of reasons:

* It's language independent. The substring approach will fail if the language settings don't match...

cometav2011 (12/29/2011)

---

I want to get the top 80% of a cumulative sum of a numeric field. Thanks but i have more than 1 mln rows and i am newbees....

roryp 96873 (12/29/2011)

---

If you want to get the top 80% of a cumulative sum of a numeric field, you have to do something like this (assuming you want them ordered...

You realize that this is a presentation issue and is best handled in the presentation layer.

Drew