Any ideas if something similar can be done using DTS?

Yes this is what I want to do. Thanks for your help!!

Are you joining to multiple tables? If so you can use outer join (right or left) to select from the table where there might not be data.

I know there have been plenty of good replies already, but when I have a lot of concatenated columns or aliased columns the easiest way for me to handle the...

Find a book by Itzik Ben-Gan. He is a T-Sql genius. He also teaches classes... http://www.solidq.com/ Also, depending on where you live you could try to...

The first thing for the search on my local machine worked great. Thanks for your help!

This may seem like a silly response, but in 2008 xp_cmdshell is disabled by default. I found an article that shows how to enable it. http://blog.sqlauthority.com/2007/04/26/sql-server-enable-xp_cmdshell-using-sp_configure/ I...

if you need to replace the PL with ST, you can use the function replace in the set.

so it would be

Update WLI

set WLI.linPartNum = replace(WLI.linPartNum, 'PL', 'ST')

from webOaLineItems as...

I do this kind of thing all the time.

Update a

set a.field = b.field

from tablea a

inner join tableb b

on a.field = b.field

where a.field like 'Whatever%'

I have never gotten a...

Recommended:

You Don't Mess with the Zohan

Indian Jones and the Kingdom of the Crystal Skull

Get Smart (Surprisingly funny)

Skip:

Burn after Reading

Ghost Town

Nights in Rodanthe

So I ended up using the stored procedure [DeleteSubscription] and deleting the subscriptions 1 at a time, all 400+ of them. Sql Server Agent had to be running, but...

Thanks for the ideas, however I tried to do that, delete from subscriptions, and I just picked one subscription to delete and it still sends out the email. I...

I am also looking for this same thing. I have a report that has date as the selection criteria, and they don't want to default it to the current...

After further review this is service pack 4, oops. I should have realized this.

I am on version:

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

May 3 2005 23:18:38

Copyright (c) 1988-2003 Microsoft Corporation

Standard Edition on Windows NT 5.2 (Build 3790:...