Good question, Ron. It really made me look at the square brackets and field names and think it through before answering.

bryan van ritter (9/17/2013)

---

Hi,

i am trying to convert a nvarchar column to a decimal value.

the nvarchar column has empty records as well as NULL values.

now when i try...

Grilling

Oh yeah...I forgot to say "congratulations and good luck" with the new position. 🙂

Grant Fritchey (9/17/2013)

---

Since the data is critical to the business, I'd suggest two things. First, ensure that the backups are meeting the business requirements. Talk to someone from the business...

Greg Edwards-268690 (9/17/2013)

---

Steve Jones - SSC Editor (9/16/2013)

---

Greg Edwards-268690 (9/16/2013)

---

Hope those in Colorado are doing OK.

Floods are so devastating.

Especially when in areas you'd never expect them, and not related to...

Speed

Sean Lange (9/16/2013)

---

+1000

Do yourself a massive favor and change your datatype to...

I just got to learn something new. I prefer to stay within native SQL where possible, but it's still good to learn new things. Thank you.

batgirl (9/16/2013)

---

Jeff Moden (9/16/2013)

---

Greg Edwards-268690 (9/16/2013)

---

Hope those in Colorado are doing OK.

Floods are so devastating.

Especially when in areas you'd never expect them, and not related to spring run off.

My prayers...

Provided that you really do have numeric data in all your rows, the CAST would be a better approach that string parsing to find a decimal. The real question...

Koen Verbeeck (9/15/2013)

---

The question itself is great, however the explanation is lacking.

There's no reference, and the explanation itself is incorrect.

There's no variable that is "reset".

The DECLARE is not ignored, it...

No problem at all - glad to help. At least you're going to be able to avoid the pain associated with having a trigger create text files. 🙂

Good question - thanks.

SQLSteve (9/12/2013)

---

The only people who can edit jobs is the job owner and people with SA. So unless people have a requirement to edit their jobs on a regular basis...