Looks correct to me.

That could be a rather large email.

But yes you can do that.

start with a little reading on the procedure that sends emails.

http://msdn.microsoft.com/en-us/library/ms190307.aspx

We would need more details. The info is pretty limited in order to provide a viable solution.

DECLARE @amt VARCHAR(20) = '5000'

SELECT REPLACE('$' + CONVERT(VARCHAR(20),(CAST(@amt AS MONEY))),'$-','-$')

Stefan Krzywicki (1/16/2013)

---

SQLRNNR (1/16/2013)

---

I think you...

Thanks for the question

I think you can rent one...

Lynn Pettis (1/15/2013)

---

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! Seems...

dwain.c (1/15/2013)

---

Thought I'd resurrect this thread which has now gone dormant for nearly 24 hours to say:

Woooohoooo!!! My 2000th post! Time to celebrate!

Good grief! Seems like only...

dedicatedtosql (1/15/2013)

---

Thanx for the advice on the Ola Hallengren script. I will suerly look into it. The only prob is I would like to go with those scripts that I...

What are you trying to accomplish?

While there is Ola's script, there is also a widely accepted script by Michelle Ufford

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

This one is also widely accepted and works.

Identity Seed problems

purple

You're welcome.