tomes12 (2/21/2013)

---

Hi, thanks for the quick response.

Of course, I see what you're saying.

Yes, mirroring/log shipping is all an option and under consideration.

That still asks the question how would it work...

Although replication may seem like a good idea, I'm not sure it was intended by Microsoft to be used as a DR solution. Have you considered mirroring or log shipping?

adonetok (2/19/2013)

---

I ran a script below but some blank records are still showing up.

What is wrong?

AttachmentKey is varchar(175)

SELECT AttachmentKey

FROM ...

Thanks for this. I see what you're doing but I will have to play around with it to get it to fit with my name matching matrix which looks something...

I don't understand what you mean by a multi step UNION. Can you give a simple example?

anthony.green (2/19/2013)

---

Abu Dina (2/19/2013)

---

The problem is with this:

(modify_date >='2012-01-28 15:43:46.077' or modify_date <='2012-12-28 15:43:46.077')

Your query is looking for record where the modified date = '2012-01-28 15:43:46.077'

Slight change to Tony's version:

select...

The problem is with this:

(modify_date >='2012-01-28 15:43:46.077' or modify_date <='2012-12-28 15:43:46.077')

Your query is looking for record where the modified date = '2012-01-28 15:43:46.077'

Slight change to Tony's version:

select create_date, modify_date from...

Replace

select @van_id + replace(convert(varchar(11), @nextdel, 113), ' ' ,'') datekey from replicationLock

set @count = @@rowcount

with :

SELECT @count = COUNT(@van_id + replace(convert(varchar(11), @nextdel, 113), ' ' ,'')) from replicationLock

Sure, see below: You can set...

If this is a one off exercise then no need to create a sproc for it to be honest.

You can use the Import/Export utility to import your ID into a...

I've also found that if a function has over 200 IF statements, that it's time to go back to the drawing board. Many such "hopeless" functions frequently do have...

Jeff Moden (2/15/2013)

---

byecoliz (2/15/2013)

---

thank you all for that new code. Abu Dina, you're right on the return correction. Now when i do that correction the function removes only the 'A'...

Take the others' advice and ditch the loop for the inline table valued function.

Jeff Moden (2/14/2013)

---

Abu Dina (2/14/2013)

---

Yup, I made this decision in July last year however, as hard as I tired...

Arrghh David beat me to it! 😛

CREATE FUNCTION dbo.FN_REMOVEL_VOWELS (@STRING VARCHAR(max))

returns varchar(max)

as

begin

RETURN REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@STRING, 'A', ''), 'E', ''), 'O', ''), 'U', ''), 'I', '')

END

SELECT DBO.FN_REMOVEL_VOWELS('INFORMATION SYSTEM')

Quick note about your original...