My first thought immediately of a perfect job would be that of a Sound Engineer or Foley Artist.  It's interesting actually that I'd been studying that in a Music School...

That should work perfectly.  It's always the simple solutions you look right past.

Thanks a bunch!

-Luke.

In other words, There would be 1 ItemNumber and 6 (2 fields by 3 records) addtional fields per row.

Thanks again.

Yes the sequence will always be 1,2,or 3 and the ItemNumber  is what I to pivot on, while the other dtat field need to be strung out into 1 line.  Unfortunately...

If you are really looking for a solution to your problem...

My local community's news stations have "Investigative Reporting" Teams that run around and cause all manner of problems for ht...

Do you really need to it be 1 hour, or is that just an example, because if it's only a 5-15 minutes you could add an execute SQL task where you...

Congrats on 5 Great years.  This site is an invaluable resource.  Thanks for all you do, and remember to say thanks to your spouses for supporting you while this "busy...

I'd imagine that you should be able to do it with the DTS export wizard.  Dbase is one of the file it can write to, you just need to have...

Wow no wonder it wasn't working... forgot all my ends... Thanks!

Always helps to have a second set of eyes...

Thanks again!

You could perhaps backup the database and then compress it with winzip or some other such tool.  I don't think you'd be able to get it down to a CD,...

Depending on your environment, a great tool I've found to do this is called Servers Alive.  http://www.woodstone.nu/salive/  You can do everything from a simple ping to checking the statuses...

I've used Crystal, Cognos, and have written my own using Cold Fusion.  I much prefer writing my own stuff, mainly because I can get exactly what I want everytime.  It...

Couldn't you do something like what was suggested in this post.  Obviously you'd be running your insert statement instead of deleting...  Also insert 25000 per minute instead of 10000 upping...

If you're just trying to format your code a bit better you can check out this site.  It's been helpful to me in the past.

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl