I don't quite understand...

I can't think of any way that a specific server can alert you that it's services have shut down. You will need to use a process where an external server...

Well, this doesn't use RegEx (just plain ole T-SQL), but it accomplishes what you're wanting:

select * from #temp where [text] like '%[0-9]%'

Since you want to return a 1/0 for the...

For those of us in the Northern Hemisphere, that just sounds so wrong!

ncodner (3/19/2010)

---

@WayneS - you're saying if I do the deletion in a loop there will be no locks on the table? Is this better than specifying 'no lock' in the...

Assuming that you read Stefan's post, and you need to perform...

steveb. (3/18/2010)

---

you can do an update based upon an inner join

from your code provided it would look something like this;

UPDATE Leas

SET Leas.amount = Cmrecc.amount

FROM...

Duplicate post. Use http://www.sqlservercentral.com/Forums/Topic885560-1292-1.aspx discussion.

Does this do it for you?

declare @test-2 varchar(50),

@num int

set @test-2 = '000150000-'

set @num = left(@test,DataLength(@test)-1) * case when right(@test,1) = '-' then...

Roy Ernest (3/18/2010)

---

Everyday morning I open up my email, I see atleast 50 replies on the THREAD. I am going on vacation from tomorrow onwards till April 12th. I wonder...

Paul White (3/17/2010)

---

WayneS (3/17/2010)

---

In BOL for ODBC Scalar Functions, it has a syntax of {fn ...}. Do you have a link that shows the use of d/t/ts like you used...

This will list a few things...

http://www.lmgtfy.com/?q=sql+server+2008+what%27s+new

Paul White (3/16/2010)

---

Aside...

Have you tried transforming it to an int, and then back to a string? That seems like it should do what you're trying to accomplish.

tstaker (3/16/2010)

---

Grant Fritchey (3/16/2010)

---

CirquedeSQLeil (3/16/2010)

---

Roy Ernest (3/16/2010)

---

CirquedeSQLeil (3/16/2010)

---

You wrote...