You could use a parameter:

DECLARE @parameterName varchar(25)

SET @parameterName = 'AR-46'

Then replace all your where's to WHERE holder_Version_Code_Enrollment = @parameterName

The other option is to do this in separate queries starting with checking col 3 and moving data left. Then column 2.

Is this going to be a regular operation, or are you trying to clean existing data where new constraints have been placed in the application that is inserting the data...

Maybe I am misunderstanding you. You stated

You do not mention any...

If you have only 3 fields just do 3 simple case statements. Shouldn't be that much code. Can't think offhand how to do it better.

Please refer to the article linked in my signature by Jeff Moden to see how to properly post your question.

Disable the sa account and only use individual accounts. Clearly too many people have the sa account credentials...

I think for auto-complete to work effectively, the entire data set should be loaded for the context and then filtered programmatically as each letter is typed. Not calling a stored...

+1 Lowell! I knew I would need this some day after reading the post. Today was that day!

andersg98 (4/9/2012)

---

When it comes to replication I have stopped asking "Why?" or even "WTH? Sometimes when you try a simple schema change it works and sometimes you get errors...

andersg98 (4/9/2012)

---

You might be able to remove the Article from the publication, reinitialize the subscription (thus removing it from replication) then alter the table, add the Article back into the...

Why are you looking for an alternative way? Is this query slow? Do you not like IF ELSE? If it works, why change it?

We always try to keep the server name the same. This way, they do not have to change the connection strings in every single application config.

I'm not sure that you really understand what a trigger is. A trigger fires when an event occurs. If there is no event, there is no firing; i.e. before...

I can tell you from experience that it is not a valid upgrade path to go from EE to dev. In fact, I just ran into the issue on Friday.