Check with the team that manages the SMTP server - see if they are using any filtering to allow only defined servers to send mail. Also, validate any credentials...

Sorry - that doesn't make sense to me. If you are getting actual duplicate values - you have an issue with your query. Otherwise, your totals would be...

You should probably work on eliminating the duplicates from the data - instead of trying to hide the duplicates in the report.

Sean Lange (7/1/2011)

---

And nobody mentioned....AWESOME JOB providing details, ddl, sample data...all the things required to make it easy for everybody to help. We all say it until we are blue...

I would recommend that you check the recovery model of the source database. Is it full recovery? If yes, are you backing up the transaction log on a...

I may be missing something here, but why would you pad a numeric value with spaces at the end? I would think a better format would be to pre-pend...

Could you switch this up and provide the users with an Excel spreadsheet that accesses the database and refreshes the data?

Excel has the ability to run queries against ODBC/OLEDB data...

You have two problems with your queries. In the first query, you have essentially turned it into an INNER JOIN by including a column from the unpreserved table (outer...

In addition to what others have pointed out - you should always specify the length of the data type when casting or converting. Using this:

SELECT convert(varchar, duedate, 112) FROM...

Why not use a utility like WinRAR to compress and span (if needed). Most likely, using a compression utility will give you a long time before you have to...

Why would you have the same function in multiple databases that do different things?

Or, do you have a single database that contains these functions but you do not know the...

coder_t2 (6/26/2011)

---

Hey guys, I tried upgrading my SQL Server 2005 to SS2008 and kept running into issues. Namely, the database engine handle failed error. So I ended up just uninstalling...

george sibbald (6/24/2011)

---

seconded, thirded, fourthed and fifthed. Not for service packs, nada.

These need applying in a controlled manner at agreed times, backups taken, with testing afterwards and a backout in...

For a service account, you never want to use a personal login. You need to create a separate account just for SQL Server, and depending on your specific requirements...

If this DBA changed data on the client's system - and is employed by the client, there really is not much you can do except work with the client's management...