Try this

DECLARE @dollar TABLE (id INT IDENTITY(1,1),Cost INT)

INSERT INTO @dollar

( Cost )

VALUES (-4255),(25454),(467834)

select ID, GETDATE() as 'Date', REPLACE('$' + CONVERT(VARCHAR(20),CONVERT(MONEY,SUM(Cost))),'$-','-$') Dollars

,...

http://support.microsoft.com/kb/2489376

Grant Fritchey (2/12/2014)

---

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

GilaMonster (2/12/2014)

---

Benki Chendu (2/12/2014)

---

Gila - I would need help in showing my client a document which says 5000 is an agreed value. I can then...

What have you built so far for you query to do that update?

That will work.

But why not apply those transaction log backups to the target as the backup occurs? You could logship those databases and keep them in sync and then...

parsnip

I just read the rest of your problem title and had only gone off the description in your post.

Exporting reports as pdf to different folders is a different thing.

Sounds like...

Try this series of articles (the link to the first article is in this article I am posting).

http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/

I show how to export both the data sources (part 2) and the...

surgery

Steve Jones - SSC Editor (2/12/2014)

---

As Gail mentioned, disasters vary. It's easy to think of HA as protecting you from disaster, but it doesn't. Don't conflate the idea of HA...

GilaMonster (2/12/2014)

---

Essential. Absolutely essential.

There's no procedural or application code that will stop someone from updating a table directly if they have permissions, or stop a newly written app from putting...

GilaMonster (2/12/2014)

---

Eugene Elutin (2/12/2014)

---

...a senior database developer colleague of mine described the use of foreign keys as "purely academic" citing that FK's provide little benefit that can't be enforced through...

Are you building a dynamic sql string in your cursor and then executing that string?

pmadhavapeddi22 (2/12/2014)

---

Jeff,

I am sorry if I have confused you.

I still stand on the same point that there are set of update statements in a stored procedure.Due to these updates, CPU...

david.wright-948385 (2/12/2014)

---

sknox (2/12/2014)

---

...This can be alleviated by formatting, e.g:

WHERE

(

(a = b)

OR

(b = c)

)

AND

...

as opposed to

WHERE ((a...