There are all sorts of books and training materials out there. Some of the stuff for certification exams can also be useful for learning the basics of SQL Server.

First...

And if there are error messages, don't forget to include them in your post.

I've stopped using NOLOCK just because of the drawbacks. I want to see all the data, so I'll take a little bit of a performance hit just to make...

Glad you found it. Thanks for posting the solution!

ToString() would certainly return the values but you can't SUM() a string. So I would still have to do an additional conversion to get the money or smallmoney values...

Try Matt's suggestion first.

It's the Microsoft Self-Paced Training Kit for 70-441. I don't have it on me at the moment (it's at work), but the cover is blue and it has a...

Without knowing at least one column name, there's no good way to do a delete other than manually before the run of the package.

I recommend redirecting the rows out of...

If I'm not mistaken (someone correct me if I am), the Image datatype is actually stored in the DB as a binary file. Therefore, there is no good way...

If all else fails, you might have to back up all your databases, uninstall and then reinstall SQL Server, then restore all your databases.

But try the MSDB restore first. ...

Why are you using SQL to delete from an Excel spreadsheet? What are you trying to accomplish?

and this link:

http://blogs.neudesic.com/blogs/pete_orologas/archive/2006/10/12/416.aspx

Check this link out and see if it helps:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2553214&SiteID=1

Given the staff changes issue, you need to start documenting what it is you're training the back up people on. Create a binder filled with details on what you...

If the group is really tight knit, you might want to consider your approach to them carefully. You don't want them to think you're trying to steal one of...