stewsterl (12/15/2009)

---

How would I get the results as MONEY? I've tried.

then '$' + CONVERT(money, total_amount)

But the $ does not show up for some reason.

current results 10495.00

Need $10,495.00

Any ideas on...

In addition to what Grant said, was there anything else that was running at execution time?

A suggestion:

Try writing it out in pseudo-code first. Once you have the pseudo-code, you can start learning the commands that fit the logic you need.

The following doc would also be a good read:

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SQL2005SecBestPract.doc

A quick note - that report will need to be opened under "Standard Reports" first. Once done, then it will cache to the context menu shown in the graphic.

Trivial

NP - you're welcome.

Question is: can you actually hula hoop?

Interestingly with this query are the results I am seeing.

I neglected to go any further in my testing when the update statement showed 0 row(s) affected.

Thus, I selected the 0...

This years Christmas gift from the Thread to all who have contributed during the past year :hehe:

The output you provided, is that for the successful job or the failed jobs?

Also, when you run the jobs from the SQL agent, do you get a job completed successfully...

The Dixie Flatline (12/15/2009)

---

The Thread ebbs and flows, Bru. 🙂

Barry (aka MISTER 10K) made an heroic effort to participate in the final sprint down the stretch and everyone...

example google query:

sql server tables created date

yields the following result:

http://stackoverflow.com/questions/1171019/sql-server-table-creation-date-query

Then a good use of that result would be to try the script. If you are having difficulties with that...

corn-dodger