Please refer to the link in my signature for an example of how to post table DDL / Sample Data here. Once we have that, we can get you...

Indeed. The problem at the moment is that I don't really understand how to read execution plans / see the specifics of which might be better for what reason....

Oops, I was misreading it, I kept thinking he wanted the extra space to show the missing value. In that case:

[font="Courier New"]

DECLARE @A VARCHAR(10),

   @b-2 VARCHAR(10),

   @C VARCHAR(10),

   @d...

Why can't you just use a space as your replacement instead of an emty string?

[font="Courier New"]DECLARE @A VARCHAR(10),

   @b-2 VARCHAR(10),

   @C VARCHAR(10),

   @d VARCHAR(10),

   @E VARCHAR(10),

   @f VARCHAR(10),

   @Combined VARCHAR(20)

SET...

GilaMonster (11/20/2008)

---

It's not only not beneficial, it can be harmful.

Duplicates in an IN are ignored. All that's important to the IN is what values exist, not how many times...

Makes sense. That said, I've read that in certain circumstances, such as IN clauses, it's usually beneficial to add DISTINCT, even if you shouldn't really need it. Not...

Hi.. I don´t need exactly the value as you sample in your query

SELECT '2008-11-17',569512.00 UNION all

SELECT '2008-11-17',966786.00 UNION all

SELECT '2008-11-17',465119.00

I need the value of this field subtract from...

Can you make this join 1 to 1 ? b.BRL_ID = d.BRL_ID

Where did you read that DISTINCT had a high cost associated with it?

Please refer to the link in my signature for how to post table definition / sample data here.

I'm thinking something like this should also work... assuming username is enforced unique.

[font="Courier New"]UPDATE @AppUsers

SET    UserName = COALESCE(@NewUserName, UserName),

            Classification = COALESCE(@NewClassification,Classification),

            Merchant = COALESCE(@NewMerchant,Merchant)

    WHERE UserName = @OldUserName[/font]

The quirk of this method is...

You were actually really close. The error likely comes from the double quotes instead of single quotes. What does this give you?

--UPDATE [StarcalClone].[StarCal].[tbl_user]

SELECT [starcalclone].[StarCal].[tbl_user].[s_name], CP.[last_first_name], *

--SET ...

If RedundantData is constantly being written to, you could possibly have some issues with extra rows being deleted in the second or third delete statements that weren't deleted out of...

Instead of:

declare @id varchar (10)

declare id_cur cursor for

select id

from redundantdata

open id_cur

fetch next from...

I don't really understand how that's going to work better than the method I proposed. Don't get me wrong, it doesn't bother me that you're going a different route,...

Please read the article in my signature on how to post table definition / sample data here. This could be very simple or somewhat difficult depending on the structure...