Hi Debbie,

I think that the problem is that you shouldn't need to update anything that is in this format. I can understand, that you create some report or whatever it...

Just re-read your post and I think you have one more problem in your query.

In words you have stated "to filter out any records where it finds those 3 Names...

Hi,

if you want to include all rows except those mentioned in the last line, and want to retain rows with NULL values in the resultset, you will need something like...

Hello,

any time you move the procedure into different environment, its performance may change - sometimes significantly. I have absolutely no idea what the procedure is doing, how large are the...

Hi Luis,

the original poster didn't report any problems, it was just me using the wrong version 🙂 (and I was simply interested in how it works, so no, I don't...

Thanks, so it is. It must be that heat - I had SQL 2012 Management Studio running, but was connected to 2008 server :hehe:. It works fine on SQLS 2012....

Hello Drew,

your solution looks interesting and uses something I didn't know before (BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING)... but, unfortunately, all it does for me is :

Msg 102, Level 15,...

Hi,

in case of such a problem in performance, I would start with indexes.

Are the same indexes defined on both databases?

Are indexes on the database in good shape? Is there...

But if I would want to do such check, I would probably in the first step compare the length (if difference of the lengths is more than 2, no more...

Hi,

are both compared strings always of the same length? In your examples they always have 7 characters, but is that a rule?

If not, please explain whether "Pand" and "Panadol" should...

Hi mitzy,

seems that problem is in understanding how PARTITION and ORDER BY works. In your code, the two ROW_NUMBER columns have the same in PARTITION clause, only the ORDER BY...

Hi,

if I understand you correctly, then you need to use DENSE_RANK, not ROW_NUMBER. ROW_NUMBER with the PARTITION BY Name means "for each new name, start counting from 1"

Try this:

DENSE_RANK() OVER(ORDER...

Hello,

I don't understand what you mean by that. If a column has DEFAULT,...

Hello,

unfortunately, I was too optimistic in saying that I already understand the data. There still is something that doesn't fit... Look at the MED PART. In the original table, you...

Hello,

if you need a quick answer, please read this and post data in easily consumable format:

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

To get...