The fact that you found this website means your on the right track.  Try the "Best of SQL Sever Central" books.

I like the microsoft press books too.

You probably want to condiser truncating the log too.

I'm on a Crystal Reporting team project at this moment (with a Sybase backend, ugh!) and we are converting every report that we can from using linked tables and views...

As a developer who codes both asp and sql I've found that the answer usually lies with which ever makes the client happier.  If clean asp code is the clients...

While Access can certainly handle this job, everyone should also have a browser on their pc.  Write an ASP page or add another form to your VB app. 

Either one...

My last post was incorrect, as was my first since the group by needed to be done in an Exists clause.  This should give you what you need.

SELECT p.PersonID, p.PersonName,...

You got the results that you asked for.  Max Date and Max Amount. 

If all you want is the Amount on the Max Date then remove the Max criteria from...

Instead of selecting all the results from Rent you need to select the MAX Rent so add a Select Statment in place of the Table Rent and use a Group...

I've used Erwin, Visio and Rational Rose for creating ERM Diagrams.

But for capturing images, wether they are of database diagrams, icons, windows, menus, or regions Snag-IT is the way to...

In similar situations I've created and formated my excel sheet and used an active-x tast to look through my recordset and dump data to the xls.

It's takes just a...

Another thought would be to use active-x tasks in your transformation with a replace statement.  If all your dealing with is somehting that is quoted you can use replace(fieldx, """,...

Julie,

I've always dumped my data into a dummy or temp table first, with no restrictions on the data, (every field is a varchar) and then copied the good data into...

I've found that it is often easiest to export my data to a folder on the server, manipulate the xls then use the file system object to move the file...

To automate the file save/rename process try using the File System Object. It's quick and easy.

In combination with global variables and the Dynamic Transformation Task you can...

If the FTP Server is within your domain you should be able to use the File System Object to retrieve and delete your files as well as post you new...